[Solved] Anyone Using Sqlserver As Db And Csqldataprovider?

Hello,

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.

Perhaps this post can help you. I applied it to solve a similar problem with CActiveDataProvider (not CSql…) so YMMV.

Thanks so much for the link. I changed CMssqlCommandBuilder.php to use OFFSET & FETCH and it works totally fine.

Glad you could solve the problem! :)