What is wrong with the following code?

[Kavya Rao]

Hi,

Below is the code snippet where i would like to display a msgbox if there are no matching records. I always get a NullReferenceException at iRows = ds.Tables("dt").Rows.Count

Please help me solve it
Thanks

Try
Dim sql As String = "Select * from property where accountno = " & id.ToString '& "%'"
Dim sa As MySqlDataAdapter = New MySqlDataAdapter
sa.SelectCommand = New MySqlCommand(sql, conn)
Dim ds As New DataSet
Dim dt As DataTable = New DataTable("property")
Dim iRows As Integer = New Integer


Try

dt.Columns.Add("accountno")
ds.Tables.Add(dt)
iRows = ds.Tables("dt").Rows.Count
MsgBox(iRows, , "Number of datarows: iRows")
'test the value of iRow
If iRows > 0 Then
'No datarows present
Else
'at least one datarow present
End If

[MrMancunian]

iRows = ds.Tables("dt").Rows.Count refers to a datatable you called "dt", but you only created a DataTable called "property".

Steven

[Kavya Rao]

Thanks a lot :)