CODEWITHSUNDEEP
vb.netms-access
user3148632
user3148632

Reputation: 79

VB.Net Checking if DataSet has rows or not

 Private Function Gelobee() As DataSet
    Dim connection As OleDb.OleDbConnection = New OleDbConnection
    connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=CMP.accdb"
    connection.Open()
    Dim da As OleDb.OleDbDataAdapter = New OleDbDataAdapter("SELECT IDDesc FROM [ItemDesc] WHERE IDPartNo = '" & PartNoTxt.Text & "';", connection)
    Dim ds As New DataSet
    da.Fill(ds, "FilteredDesc")
    connection.Dispose()
    connection = Nothing
    If ds.Tables.Count > 0 Then
    If ds.Tables[0].Rows.Count > 0 Then
            DescTxt.Text = ds.Tables(0).Rows(0).Item(0)
        Else
            DescTxt.Text = "No Description"
        End If
    End If

    Return ds
End Function

Hi, I'm trying to check if the data set has rows. But it's giving me error at "ds.Tables[0].Rows.Count > 0". Anything wrong with my code? I tried to search all over the net but I can't seem to find an answer.

Upvotes: 5

Views: 26816

Answers (2)

Madhawas
Madhawas

Reputation: 391

Your error is you have used "[]" in VB.net instead of "()"

Your code should be corrected as 

ds.Tables(0).Rows.Count

Upvotes: 2

Anthony Chu
Anthony Chu

Reputation: 37520

VB.NET syntax to access an indexer should be with parentheses...

If ds.Tables(0).Rows.Count > 0 Then

Upvotes: 10

Related Questions