Dim cmd As SqlCommand = New SqlCommand("SELECT qnumber," + item + " FROM tencmpC1", cc)
Dim adp As New SqlDataAdapter(cmd)
cmd.Connection.Open()
Dim ds As new Data.Dataset
Dim dt as new Data.DataTable
adp.Fill(ds)
dt=ds.Tables(0)
Dim count as Integer=dt.Rows.Count
2
solved How to count rows from SQL DB table in VB.NET WPF application? [closed]