ISNULL FUNCTION

[Ezzeddin]

How can I use ISNULL() function in asp.net

Thanks

 

[William Ryan]

string s = "SELECT ISNULL(myField, ValueIfItsNull) From MyTable";

myCommand.CommandText = s;
....then execute your query here.

 

[Scott M.]

IsNull has been replaced with IsDBNull()

If IsDBNull(x) then exit sub