«

I'm outputting data from a SQL server database to a web form (C#).

How can I detect if a value is null in the database?

Thanks

Andrew,

To check if a value is null compare to DBNull.Value.

Ex:

if (myTable.Rows[0][0] == DBNull.Value)
...

On Wed, 25 Feb 2004 18:41:34 GMT, Andrew Banks
<> wrote:

> I'm outputting data from a SQL server database to a web form (C#).
>
> How can I detect if a value is null in the database?
>
> Thanks
>
>

Thanks Wes,

It's appreciated

"Wes Brown" <> wrote in message
news...
> Andrew,
>
> To check if a value is null compare to DBNull.Value.
>
> Ex:
>
> if (myTable.Rows[0][0] == DBNull.Value)
> ...
>
> On Wed, 25 Feb 2004 18:41:34 GMT, Andrew Banks
> <> wrote:
>
> > I'm outputting data from a SQL server database to a web form (C#).
> >
> > How can I detect if a value is null in the database?
> >
> > Thanks
> >
> >
>

In vb, how can I do the same. I mean.... to see if a DataSet it is empty?


--

Thank's (if you try to help me)
Hope this help you (if I try to help you)
ruca

"Wes Brown" <> escreveu na mensagem
news...
> Andrew,
>
> To check if a value is null compare to DBNull.Value.
>
> Ex:
>
> if (myTable.Rows[0][0] == DBNull.Value)
> ...
>
> On Wed, 25 Feb 2004 18:41:34 GMT, Andrew Banks
> <> wrote:
>
> > I'm outputting data from a SQL server database to a web form (C#).
> >
> > How can I detect if a value is null in the database?
> >
> > Thanks
> >
> >
>