Counting the DataGrid Record question?

[murphyc]

I use the SQL command to select the record and display in the datagrid. But i don't know how to count how many record i select. I want to display the number of record in the label.caption. I found the VB can do the "Label2.Caption = DataGrid1.Columns.Count" But no datagrid1.row.count canbe use, so pool....!! Does anyone help me??? Thanks a lot

 

[ttmac]

Are you using the SQL to return a recordset? If so you can use the recordset.count method to return the number of records. Much cleaner.