To Find the total records in database [Plz Help]

[nison_jose]

I populate the records from the database in to the dataset using the DataAdapter.In the fill method I gave the the startrow and maximum row prameters.I need only 50 records at a time.Is there any way to find the total number of records in database ,without a query.When I take the record count of datatable it only gives 50 records.I can't find such a property to DataAdapter. After all DataAdapter is only used for one table is there any method to get the total record count of table in database using the same DataAdapter

Thanks in advance,Plz help me.