dataset columns with system.dbnull

30 Dec 2005 4:42 PM

Buho

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...

30 Dec 2005 4:50 PM

Marina

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

Show quote

"Buho" <josemoli***@gmail.com> wrote in message
news:1135960961.044802.159120@g47g2000cwa.googlegroups.com...
> 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...
>

30 Dec 2005 6:03 PM

Robbe Morris [C# MVP]

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

Show quote

"Buho" <josemoli***@gmail.com> wrote in message
news:1135960961.044802.159120@g47g2000cwa.googlegroups.com...
> 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...
>

30 Dec 2005 8:26 PM

Buho

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