Is anyone using SQL Server as Database and CSqlDataProvider to query the database? I was having problem using pagination for Gridview. Here is my POST which explains the problem in details.
If you have used something similar please provide assistance or the SQL query from log messages which is used to retrieve data for different pages in pagination.
I will appreciate any kind of help/suggestions regarding this.