Exception: The SQLDataSource 'dsMySQL' does not have paging enabled.
I am trying to write an ASP.NET app in VB2005 that, based on a query, access either a MSDE or a MySQL database and loads a GridView with the results. I haven't worked too much on the MSDE side yet because I feel pretty confident in that, but the MySQL side is giving me all kinds of problems I keep getting a NotSupportedException when I call the .Select method of the SqlDataSource control to which my GridView is bound to. I have tried setting the AllowPaging of the GridView to False (although i would rather have it set to True) and still I get the same error. Anyone know how to fix this?
[595 byte] By [
vbmon] at [2007-12-20]
Hi,
SqlDataSource is working with SQL Server(MSDE is the desktop edition of SQL Server).
For MySQL, it has its own provider.
Here is link for your reference.
MySQLDirect .NET Data Provider
http://www.crlab.com/mysqlnet/
If you still have any concern, please feel free to post here.
Best regards,
Peter Huang