How to count records from database using VB.NET ?

Question

I have the code below:

 Dim ds As New DataSet
 Dim sda As System.Data.SqlClient.SqlDataAdapter
 Dim sSQL As String
 Dim strCon As String

 sSQL = " .... MY QUERY HERE .... "

 strCon = appBase.dbConnString

 sda = New System.Data.SqlClient.SqlDataAdapter(sSQL, strCon)
 sda.Fill(ds, "MY TABLE FROM DB")


 dgRecordsContent.DataSource = ds.Tables("MY TABLE FROM DB")
 dgRecordsContent.DataBind()

 dgRecordsContent.Visible = True

 dbConn.Close()

How can I programatically count the number of rows from the datagrid that I'm showing the values in?

Fill is a method returning the number of rows

Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp

2015-12-10 18:23:18 +00:00
Commented Dec 10, 2015 at 18:23 — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Dec 10, 2015 at 18:23

PHeiberg · Accepted Answer · 2015-12-10 18:25:54Z

1

Provided that the DataTable being filled doesn't already contain any rows, you can get the count using:

int count = sda.Fill(ds, "MY TABLE FROM DB")

Otherwise you can access the rows in the DataTable using:

int count = ds.Tables("MY TABLE FROM DB").Rows.Count

answered Dec 10, 2015 at 18:25

PHeiberg

29.9k6 gold badges61 silver badges82 bronze badges

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

Comments

user474901 · Accepted Answer · 2015-12-10 18:25:28Z

0

you can use ds.Tables[0].Rows.Count

answered Dec 10, 2015 at 18:25

user474901

Comments

user5049245 · Accepted Answer · 2015-12-10 20:10:26Z

0

 Dim ds As New DataSet
 Dim sda As System.Data.SqlClient.SqlDataAdapter
 Dim sSQL As String
 Dim strCon As String

 sSQL = " .... MY QUERY HERE .... "

 strCon = appBase.dbConnString

 sda = New System.Data.SqlClient.SqlDataAdapter(sSQL, strCon)
 Dim num_rows=sda.Fill(ds, "MY TABLE FROM DB")

 MessageBox.Show(num_rows.ToString())  

 dgRecordsContent.DataSource = ds.Tables("MY TABLE FROM DB")
 dgRecordsContent.DataBind()

 dgRecordsContent.Visible = True

 dbConn.Close()

Please Check This Edit @Emi

answered Dec 10, 2015 at 20:10

user5049245

Collectives™ on Stack Overflow

How to count records from database using VB.NET ?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related