How to count in DataTable displayed results from a query?

communi · Post by **communi** » Tue 13 Jun 2006 11:16

Hello,
in my VB2005 project I have a form with a MySQLDataTable (like in the DataTable sample). How can I count the displayed results of a query so I can make a label on this form like "Query results: xxxxx rows" where xxxx is the count of rows displayed?

Thank you!!

Serious · Post by **Serious** » Tue 13 Jun 2006 11:30

You can use MySqlDataTable.Rows.Count property.

communi · Post by **communi** » Tue 13 Jun 2006 12:03

Can you give me a short sample or code snippet how to use this property? I Couldn't find something about this property in documentation?

Thanks!

Alexey · Post by **Alexey** » Tue 13 Jun 2006 13:18

Here you are

Code: Select all

Label1.Text = MySqlDataTable1.Rows.Count.ToString

Communi · Post by **Communi** » Tue 13 Jun 2006 13:32

Great! Now it works fine!!! Thank you very much!!!

Alexey · Post by **Alexey** » Tue 13 Jun 2006 13:40

You are always welcome.