Hi everyone(happy new year!!),


Well, here we go... I have a problem with datsets, ado.net as i
understand ..I have a sp that in query analizer retrieve 13 columns and

the last 3 like the others have data, but when i see the dataset which
gets the data the last columns are system.dbnull, and here after
several tests, i am begging your help guys...did anyone have this
problem???? i ll be thankfull really for any help u can post...


Thanks in advance...

No, never heard of this issue. You will have to post relevant code or a
short example illustrating the problem.

"Buho" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi everyone(happy new year!!),
>
>
> Well, here we go... I have a problem with datsets, ado.net as i
> understand ..I have a sp that in query analizer retrieve 13 columns and
>
> the last 3 like the others have data, but when i see the dataset which
> gets the data the last columns are system.dbnull, and here after
> several tests, i am begging your help guys...did anyone have this
> problem???? i ll be thankfull really for any help u can post...
>
>
> Thanks in advance...
>

I'd try putting any of the ntext/text or image data types
at the end of your select clause.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp





"Buho" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi everyone(happy new year!!),
>
>
> Well, here we go... I have a problem with datsets, ado.net as i
> understand ..I have a sp that in query analizer retrieve 13 columns and
>
> the last 3 like the others have data, but when i see the dataset which
> gets the data the last columns are system.dbnull, and here after
> several tests, i am begging your help guys...did anyone have this
> problem???? i ll be thankfull really for any help u can post...
>
>
> Thanks in advance...
>

I just read a kb article that gave me some hope but nothing, i was
checking the Stored Proc but it dont use any of the causes of this bug,
here is for someone :P who need it:
FIX: Data Loss Occurs When You Deserialize a Serialized Dataset When
Column Names Contain a Colon Character

Pd: Thanks for the answers