Check if record is null

[Andrew Banks]

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

[Wes Brown]

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
<ba****@nojunkblueyonder.co.uk> 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

[Andrew Banks]

Thanks Wes,

It's appreciated

"Wes Brown" <we*@weDONTslandiSPAMa.orMEg> wrote in message
news:op**************@msnews.microsoft.com...

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
<ba****@nojunkblueyonder.co.uk> 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

[ruca]

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" <we*@weDONTslandiSPAMa.orMEg> escreveu na mensagem
news:op**************@msnews.microsoft.com...

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
<ba****@nojunkblueyonder.co.uk> 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