ASP.NET - Problem with Grid View and SQL data source
Ignore the title - Problem with Grid View and SQL data source
I've already managed to connect and access data from my database using MySQL.
But now, in another page, I have a Grid View with sql data source. I used VS 2008 to create it,
and in my .asxp file I have:
And in my web.config:
And I'm getting :
But... Where is the problem after all? I'm already using MySql.Data.dll sucessfuly, I dont understand whats the problem..
Edit:
Nobody can help me ?
Ignore the title - Problem with Grid View and SQL data source
I've already managed to connect and access data from my database using MySQL.
But now, in another page, I have a Grid View with sql data source. I used VS 2008 to create it,
and in my .asxp file I have:
Code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:PWSConnectionString %>"
ProviderName="<%$ ConnectionStrings:PWSConnectionString.ProviderName %>" SelectCommand="SELECT * FROM Filmes
"></asp:SqlDataSource>
And in my web.config:
Code:
<connectionStrings>
<add name="PWSConnectionString" connectionString="server=server;user id=machado_xxxx;password=xxxx;persist security info=False;database=machado_xxxx"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
And I'm getting :
Failed to find or load the registered .Net Framework Data Provider 'MySql.Data.MySqlClient'.
But... Where is the problem after all? I'm already using MySql.Data.dll sucessfuly, I dont understand whats the problem..
Edit:
Nobody can help me ?
Last edited: