ASP.NET error when trying to configure ListView + SqlDatasource for a MySql Table
- by stighy
Hi, i'm using ASP.NET + a MySql Db.
I'm trying to configure a ListView so i've written:
<asp:SqlDataSource ID="dsDatiUtente" runat="server" ConnectionString="Server=12.28.136.29;Database=mydb;Uid=m111d1;Pwd=fake;Pooling=false;"
ProviderName="MySql.Data.MySqlClient"
SelectCommand="SELECT * FROM user WHERE idUser=@IdUser"
/
At the beginning of my aspx page i've added
<%@ Import Namespace="MySql.Data.MySqlClient" %>
But if i click to the sqldatasource and click "Refresh Schema" i got this error:
"Unable to retrive schema.... Unable to find the requested .Net Framework data provider"
For instance, i've installed it , but i've also uninstalled old version, then installed new versions. In my project i simple copy Mysql dll into "bin" folder, then add a reference to that dll.
I'm not sure is the corrected way...
I need to have the "refreshed schema" to permit vs.net to build automatically my listview ... if i can't to "auto build" listview, i have to write all code by hand, and it is a too expensive work me :(
What i'm wrong ?
Thank you!