Unable to find the requested .Net Framework Data Provider. It may not be installed.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="%$ ConnectionStrings:HistoryConnectionString1 %>"
DeleteCommand="DELETE FROM History WHERE ID = @ID" ProviderName="%$ ConnectionStrings:HistoryConnectionString1.ProviderName %>"
SelectCommand="SELECT [ID], [a], [s], [d], [f], [g], [h], [Description] FROM [History]"
UpdateCommand="UPDATE History SET e= @e, a= @s, d= @d, f= @f, g= @g, h=@h, Description = @Description WHERE ID=@ID"
Error Solved:
Just add $ in connection string
asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="%$ ConnectionStrings:WeatherHistoryConnectionString1 %>"
DeleteCommand="DELETE FROM History WHERE ID = @ID" ProviderName="<%$ ConnectionStrings:WeatherHistoryConnectionString1.ProviderName "
Output:Application running successfully..