Hello

I'm having trouble using a datareader to retrieve mssql text datatype
fields. I can find examples where images are the data stored in the field
but the fields I need to work with have text in them. Can anyone point me to
some sample code.

Thanks,
Jim

Jim,

How are you trying to access it? The DataAdapter in the SqlClient
namespace should translate that into a string instance for you.


--
- Nicholas Paldino [.NET/C# MVP]
- (E-Mail Removed)

"Jim McCarthy" <(E-Mail Removed)> wrote in message
news:O9y2%(E-Mail Removed)...
> Hello
>
> I'm having trouble using a datareader to retrieve mssql text datatype
> fields. I can find examples where images are the data stored in the field
> but the fields I need to work with have text in them. Can anyone point me
> to
> some sample code.
>
> Thanks,
> Jim
>
>

I'm trying to use a datareader instead of a dataadapter and dataset. I'm
using so many dataadapters and datasets right now I was just trying to avoid
using another.



Another question -- do I need to use another dataset for each dataadapter I
use in a form or for that matter in my application.

Thanks,

Jim

"Nicholas Paldino [.NET/C# MVP]" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Jim,
>
> How are you trying to access it? The DataAdapter in the SqlClient
> namespace should translate that into a string instance for you.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - (E-Mail Removed)
>
> "Jim McCarthy" <(E-Mail Removed)> wrote in message
> news:O9y2%(E-Mail Removed)...
> > Hello
> >
> > I'm having trouble using a datareader to retrieve mssql text datatype
> > fields. I can find examples where images are the data stored in the
field
> > but the fields I need to work with have text in them. Can anyone point
me
> > to
> > some sample code.
> >
> > Thanks,
> > Jim
> >
> >
>
>

On Mon, 21 Mar 2005 12:58:57 -0700, "Jim McCarthy" <(E-Mail Removed)> wrote:

>I'm trying to use a datareader instead of a dataadapter and dataset. I'm
>using so many dataadapters and datasets right now I was just trying to avoid
>using another.
>
>
>
>Another question -- do I need to use another dataset for each dataadapter I
>use in a form or for that matter in my application.
>
>Thanks,
>
>Jim

Jim,

You can fill one DataSet from all of the DataAdapters, but that might not be
what you want. I would look at all of the DataAdapters and categorize their
use. Then I would fill DataSets that match the groups.

For instance if you have a lot of ListBoxes or DropDowns to populate, then a
DataSet filled by DataAdapters that only have Select Commands would be
appropriate.


>
>"Nicholas Paldino [.NET/C# MVP]" <(E-Mail Removed)> wrote in
>message news:(E-Mail Removed)...
>> Jim,
>>
>> How are you trying to access it? The DataAdapter in the SqlClient
>> namespace should translate that into a string instance for you.
>>
>>
>> --
>> - Nicholas Paldino [.NET/C# MVP]
>> - (E-Mail Removed)
>>
>> "Jim McCarthy" <(E-Mail Removed)> wrote in message
>> news:O9y2%(E-Mail Removed)...
>> > Hello
>> >
>> > I'm having trouble using a datareader to retrieve mssql text datatype
>> > fields. I can find examples where images are the data stored in the
>field
>> > but the fields I need to work with have text in them. Can anyone point
>me
>> > to
>> > some sample code.
>> >
>> > Thanks,
>> > Jim
>> >
>> >
>>
>>
>

Otis Mukinfus
http://www.otismukinfus.com