VB.Net 2005 Null Error

[shresthau]

Hello,
I need help.

I have problem for VB.Net 2005.
My backend database is SQL Server 2005

I wrote the following code:

strSQL="Select FName, LName, MName FROM tblInfo"
RsOpen(strSQL)
If Rs.RecordCount>0 Then
Rs.MoveFirst

txtFName.Text=Rs.Fields("FName").Value
txtMName.Text=Rs.Fields("MName").Value
txtLName.Text=Rs.Fields("LName").Value
End If

My problem is MName filed is null value. How can i check the null value?
I tried IsNull function in VB but in VB.Net there is no IsNull function.
Please anybody know the function for check IsNull ?

RaJaN

[semomaniz]

I think this will help you. I think in vb you will have to check for null value with the keyword nothing. The example is as follow

[code = vb.net]
Dim sTest As String
If (sTest Is Nothing) Then
Console.WriteLine("sTest is Null")
End If
[/code]

In you case i belive this should work,

if (Rs.Fields("MName").Value IS Nothing) then txtMName.Text = "The value is NULL"else txtMName.Text = Rs.Fields("MName").Valueend if
 

hope this helps.

semomaniz

Hello,
I need help.

I have problem for VB.Net 2005.
My backend database is SQL Server 2005

I wrote the following code:

strSQL="Select FName, LName, MName FROM tblInfo"
RsOpen(strSQL)
If Rs.RecordCount>0 Then
Rs.MoveFirst

txtFName.Text=Rs.Fields("FName").Value
txtMName.Text=Rs.Fields("MName").Value
txtLName.Text=Rs.Fields("LName").Value
End If

My problem is MName filed is null value. How can i check the null value?
I tried IsNull function in VB but in VB.Net there is no IsNull function.
Please anybody know the function for check IsNull ?

RaJaN

[Shashi Sadasivan]

what sort of data type is RS ?

[GayathriP]

You can use isDBNull(<FieldValue) to check for the NULL values.