ISNULL FUNCTION

[Ezzeddin]

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

Thanks

[William Ryan]

Re: ISNULL FUNCTION

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

myCommand.Comma ndText = s;
....then execute your query here.

"Ezzeddin" <ezoarabi@hotma il.com> wrote in message
news:08af01c36f 15$57ff95b0$a60 1280a@phx.gbl.. .[color=blue]
> How can I use ISNULL() function in asp.net
>
> Thanks
>[/color]

[Scott M.]

Re: ISNULL FUNCTION

IsNull has been replaced with IsDBNull()

If IsDBNull(x) then exit sub


"Ezzeddin" <ezoarabi@hotma il.com> wrote in message
news:08af01c36f 15$57ff95b0$a60 1280a@phx.gbl.. .[color=blue]
> How can I use ISNULL() function in asp.net
>
> Thanks
>[/color]