我想在label标签上显示SQL数据库表里的记录数

Question

我想在label标签上显示SQL数据库表里的记录数

Dim CnStr As String = "server=localhost;database=STdata;user id=sa;password=111"
cn = New SqlConnection(CnStr)
da = New SqlDataAdapter("select count(*) from chaifen", cn)
ds = New DataSet()
da.Fill(ds, "chaifen")
Label4.Text =？
cn.Close()

Answer 1

Dim CnStr As String = "server=localhost;database=STdata;user id=sa;password=111"
cn = New SqlConnection(CnStr)
da = New SqlDataAdapter("select count(*) from chaifen", cn)
ds = New DataSet()
da.Fill(ds, "chaifen")
Label4.Text =ds.tables("chaifen").Rows(0)(0).ToString()
cn.Close()