Hello folks,

is there a way how I can avoid Null Values in datasets when they are filled
with a dataadapter. (Of cours I could change my querey so that no Null
values are returned, but I can't do so in my case). I have tryed to set
nillable property to false and set a default value, but then all lines
contain the default value even those where data is returned from the query.

So, how can I change all null values to emty string or 0?

Thank you very much


Anton

SELECT IsNull(myColumn1, 0), IsNull(myColumn2, 0), IsNull
(myStringColumn, '') from myTable


>-----Original Message-----
>Hello folks,
>
>is there a way how I can avoid Null Values in datasets
when they are filled
>with a dataadapter. (Of cours I could change my querey
so that no Null
>values are returned, but I can't do so in my case). I
have tryed to set
>nillable property to false and set a default value, but
then all lines
>contain the default value even those where data is
returned from the query.
>
>So, how can I change all null values to emty string or 0?
>
>Thank you very much
>
>
> Anton
>
>
>.
>

Thanks Ryan,

but I wanted it to be done clientside not on sql server, e.g. doing
someting to the dataset or just converting.


Any other Suggestions from anybody?


Thanks

Anton

Have a look at the .Parse and .Format events.


"Anton Sommer" <anton.schamy_no_spam_@arcor.de> wrote in message
news:bie21h$12c$01$(E-Mail Removed)...
> Hello folks,
>
> is there a way how I can avoid Null Values in datasets when they are
filled
> with a dataadapter. (Of cours I could change my querey so that no Null
> values are returned, but I can't do so in my case). I have tryed to set
> nillable property to false and set a default value, but then all lines
> contain the default value even those where data is returned from the
query.
>
> So, how can I change all null values to emty string or 0?
>
> Thank you very much
>
>
> Anton
>
>

If you use typed dataset, when you define dataset through
XSD file, you can specify the NULL value . Or you can
derive a sub class from dataset and put the default logic
there.

Ann

>-----Original Message-----
>Hello folks,
>
>is there a way how I can avoid Null Values in datasets
when they are filled
>with a dataadapter. (Of cours I could change my querey
so that no Null
>values are returned, but I can't do so in my case). I
have tryed to set
>nillable property to false and set a default value, but
then all lines
>contain the default value even those where data is
returned from the query.
>
>So, how can I change all null values to emty string or 0?
>
>Thank you very much
>
>
> Anton
>
>
>.
>

Thank ann

I use typed datasets but where can I set a null value because setting a
default value of the column surprisingly sets all rows to the default value
even when the DataAdapter fills values for that row.

Thank you
> If you use typed dataset, when you define dataset through
> XSD file, you can specify the NULL value . Or you can
> derive a sub class from dataset and put the default logic
> there.
>