I want to show No. of records through oledbDataAdopter

[mukesh]

Hi guys,

I want to know the no of records in dataset (OledbDataAdopter or OledbDataReader) in vb.net. Actully I want to show the no. of records at Title bar at the time of form loading.

Bye

thanks in advance

 

[Gambit_NI]

once you populate the dataset u just need to use

dataset.tables(0).rows.count

 

[jmcilhinney]

When you call Fill on a DataAdapter the function returns the number of rows retrieved.