Null not support by .net?

[Sam]

I want to control textbox where if textbox is not empty process ADO.NET

If TextBox_Account.Text is not null then
Dim con As New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmd As New SqlCommand()
cmd.CommandText = "Select * from Info where ID = " &
TextBox_Account.Text"
cmd.Connection = con
end if

However, null does not support in .Net and advise to use system.dbnull.

Please advise how to use null in asp.net

 

[MasterGaurav]

No. It will never be null.

Check for the an empty string.

If TextBox_Account.Text <> String.Empty Then
.....
End If

--
Cheers,
Gaurav Vaish
http://www.mastergaurav.org
http://mastergaurav.blogspot.com
--------------------------------

 

[Lau Lei Cheong]

And for Visual Basic/vbscript, you should check for Nothing instead of null
in most case.
null is defined in other languages such as C++, C#, J#, etc.