Reading a text field -- dotnet ado.net

William Vaughn [MVP]
4/2/2008 11:05:35 AM

From my site (an excerpt from my book):
http://www.betav.com/Files/Content/Whitepapers/Using%20the%20ADO%20Stream%20Object%20to%20Manage%20BLOBs.htm

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
[quoted text, click to view]

Josh
4/2/2008 4:58:02 PM

How do I get the data out of an MS-SQL Text field efficiently

A simple "SELECT [FieldName] FROM [Table]" unfortunately returns a truncated
version of the fields contents ( which actually contains an entire book ).

I know that your not supposed to do a simple select, but my Google-Fu is
weak and I dont know what words to search for.

Can anyone supply some hints?

Thanks

Cor Ligthert[MVP]
4/3/2008 7:10:01 AM

Josh,

As I saw Bill's code, then I assume that this will work as well.

http://www.vb-tips.com/DataSetImage.aspx

(Be aware that you don't need the office offset)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet ado.net

dotnet ado.net : Reading a text field