如何获取数据库表的记录总数？

[hsx49949046]

Dim sql As String
Dim ds As New DataSet
ds.Clear()
sql = "select * from name "
Dim cmd As New OleDbDataAdapter(sql, Conn)
cmd.Fill(ds, "name")
Dim myvalues(0) As String
Dim listview As New ListViewItem
For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
listview.Text = ds.Tables(0).Rows(i)("id")
listview.SubItems.Add(ds.Tables(0).Rows(i)("**"))
listview.SubItems.Add(ds.Tables(0).Rows(i)("**"))
listview.SubItems.Add(ds.Tables(0).Rows(i)("**"))
listview.SubItems.Add(ds.Tables(0).Rows(i)("**"))
listview.SubItems.Add(ds.Tables(0).Rows(i)("**"))
ListView1.Items.Add(listview)
listview = New ListViewItem()
Next
Me.Label3.Text = 这里显示name表的记录总数。
请问该怎么写？才能输出name表的记录总数？
先谢谢了。

[ljdzyc2008]

ds.Tables("name").Count

[ljdzyc2008]

ds.Tables("name").Rows.Count

[wuyi8808]

Me.Label3.Text = ds.Tables(0).Rows.Count.ToString()

[Forrest23]

楼上都对~