如何在 VB.NET WPF 应用程序中计算 SQL DB 表中的行数? [英] How to count rows from SQL DB table in VB.NET WPF application?

问题描述

我只想要针对特定​​查询的记录数量，仅此而已.例如从表中选择计数(列名)答案 = 15

I just want who many number of record comes against specific query, nothing else. for example select count(column name) from table answer = 15

  Dim cmd As SqlCommand = New SqlCommand("SELECT  qnumber," + item + " FROM tencmpC1", cc) 
            Dim adp As New SqlDataAdapter(cmd)
            cmd.Connection.Open()


            Dim oleRdr As SqlDataReader = cmd.ExecuteReader
            'txt1.Text = oleRdr.HasRows

                oleRdr.Read()
                Dim count As Integer
                While oleRdr.Read()
                    count = count + 1
                End While
                txt1.Text = count


            oleRdr.Close()

我尝试使用此代码从查询中获取行数但未能获取.请给我一段代码，任何人.

I try this code to get number of rows from query but failed to get. Please give me piece of code, anyone.

推荐答案

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    

这篇关于如何在 VB.NET WPF 应用程序中计算 SQL DB 表中的行数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！