C# DB Null?

[Adam J Knight]

Hi all,

How can i determine if a reader record is DBNull is C#???
What reference do i need?

if(rdrExam["OutcomeID"].??)
{
Response.Write("Here I am");
}

Cheers,
Adam

 

[Patrick.O.Ige]

Hi Adam how is the weather over there..Have u tried...if
(!IsDBNull(rdrExam.GetValue(4))) {
Response.Write("Here I am");}

 

[john smith]

Hi Adam how is the weather over there..Have u tried...if
(!IsDBNull(rdrExam.GetValue(4))) {
Response.Write("Here I am");}

Hi all,

How can i determine if a reader record is DBNull is C#???
What reference do i need?

if(rdrExam["OutcomeID"].??)
{
Response.Write("Here I am");
}

Cheers,
Adam

This is faster than IsDBNull(), however both ways should work...

if (!rdrExam["OutcomeID"].Equals(System.DBNull.Value))
{
Response.Write("Here I am");
}

 

[Karl Seguin [MVP]]

if (rd["OutcomeId"] != DBNull.Value)
{
}

Karl

--
http://www.openmymind.net/

Hi Adam how is the weather over there..Have u tried...if
(!IsDBNull(rdrExam.GetValue(4))) {
Response.Write("Here I am");}

Hi all,

How can i determine if a reader record is DBNull is C#???
What reference do i need?

if(rdrExam["OutcomeID"].??)
{
Response.Write("Here I am");
}

Cheers,
Adam

This is faster than IsDBNull(), however both ways should work...

if (!rdrExam["OutcomeID"].Equals(System.DBNull.Value))
{
Response.Write("Here I am");
}

 

[Otis Mukinfus]

Hi all,

How can i determine if a reader record is DBNull is C#???
What reference do i need?

if(rdrExam["OutcomeID"].??)
{
Response.Write("Here I am");
}

Cheers,
Adam

if(rdrExam.GetValue(indexOfOutcomeID) == DBNull.Value)
{
//handle the null
}
else
{
//do something with the value;
}

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com