ASP.NET use SqlConnection connect MySQL

Question

This is the connection string saved in `web.config`: ``` ``` This is the code to connect to the database: ``` protected bool CheckPasswordBySqlServer(string strEmail, string strPsw) { if (strEmail.ToLower() == "admin") { return false; } string str = "select id,Rank,RankEnc,ParentUser,Company from tbl_User where userName=@UserName and password1=@password"; private string strConn = ConfigurationManager.AppSettings["conn"].ToString(); SqlConnection sqlConnection = new SqlConnection(strConn); bool flag = false; try { try { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand(str, sqlConnection); sqlCommand.Parameters.AddWithValue("UserName", strEmail); sqlCommand.Parameters.AddWithValue("Password", strPsw); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); if (!sqlDataReader.Read()) { flag = false; } else { this.Session["User…

Accepted Answer

`SqlConnection` is for SQL Server. You need `MySqlConnection` - this is not part of the .NET Framework, so you will have to download it and reference it in your project. You can then create a `MySqlConnection` object and connect to MySQL in your application:

```
MySqlConnection connection = new MySqlConnection(myConnString);
```

You will also have to use the `MySqlCommand` object rather than the `SqlCommand` object.

http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqlconnection.html

ASP.NET use SqlConnection connect MySQL

Solution

Problem

Related problems