How to count rows from SQL DB table in VB.NET WPF application? [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 10 years ago.

Improve this question

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.

please answer this question if you understand know?

Waqas Ali
– Waqas Ali

2015-05-30 15:25:46 +00:00
Commented May 30, 2015 at 15:25 — Waqas Ali
– Waqas Ali, Commented May 30, 2015 at 15:25

Mahadev · Accepted Answer · 2015-05-30 12:32:32Z

-1

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

answered May 30, 2015 at 12:32

Mahadev

8561 gold badge19 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Waqas Ali Over a year ago

Dear mahadev error arises Cannot find table 0. stackoverflow.com/users/1662394/mahadev

anon Over a year ago

@WaqasAli If the answer doesn't answer your question, please don't accept it.

Collectives™ on Stack Overflow

How to count rows from SQL DB table in VB.NET WPF application? [closed]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related