ASP.NET 连接MySql数据库

 

[csharp] ​​view plain​​​ ​​copy​​  

<connectionStrings>  <add name="MySQLConnString" connectionString="Server=your_MySql_Server_IP;Port=3306;Database=databaseName;Uid=username;Pwd=yourpassword;pooling=false;" providerName="MySql.Data.MySqlClient"/>   </connectionStrings>  

1. 
   

4. 在你的代码前面添加using MySQL.Data.MySqlClient;

下面是个简单的连接Mysql 并且使用的例子

[csharp] ​​view plain​​​ ​​copy​​  

1. 1. 
      
2. protected void Page_Load(object sender, EventArgs e)  
3. {  
4. DataSet ds_temp = GetObjects();  
5. ListBox1.DataSource = ds_temp;  
6. ListBox1.DataTextField = "yourColumn";  
7. ListBox1.DataValueField = "yourColumn";  
8. ListBox1.DataBind();  
9. }  
10. 
    
11. protected static DataSet GetObjects()  
12. {  
13. DataSet ds_temp = Connection_cls.GetDataSetQuery("SELECT yourColumn FROM yourtable", null);  
14. return ds_temp;  
15. 
    
16. }  
17. 
    
18. private static string getHostString()  
19. {  
20. string host = ConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;  
21. return host;  
22. }  
23. public static DataSet GetDataSetQuery(string sql, ArrayList paramList)  
24. {  
25. using (MySqlConnection conn = new MySqlConnection(getHostString()))  
26. {  
27. try  
28. {  
29. conn.Open();  
30. MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);  
31. da.SelectCommand.Parameters.Clear();  
32. if (paramList != null)  
33. {  
34. for (int i = 0; i < paramList.Count; i++)  
35. {  
36. da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);  
37. }  
38. }  
39. DataSet ds = new DataSet();  
40. da.Fill(ds);  
41. return ds;  
42. }  
43. finally  
44. {  
45. conn.Close();  
46. }  
47. }  
48. }  
    1. 
       

Mysql官方.net连接文档：

I'm using Visual Web Developer 2010 Express Edition (and Visual C# 2010 Express) with MySQL. This is what I did:

1 - Download and install MySQL connector(just to get MySql.Data.dll).

2 - VWD 2010 in the Solution Explorer add reference to MySql.Data.dll(usually in c:\program files\MySQL\MySQL Connector Net(your version here)\Assemblies\v4.0 or v2.0)

3 - In the web.config add your string connection:

<connectionStrings>

<add name="MySQLConnString" connectionString="Server=your_MySql_Server_IP;Port=3306;Database=databaseName;Uid=username;Pwd=yourpassword;pooling=false;" providerName="MySql.Data.MySqlClient"/>

</connectionStrings>

4 - In the code behind type in: "using MySQL.Data.MySqlClient;"

Now you can use it as in this example:

protected void Page_Load(object sender, EventArgs e)

{

DataSet ds_temp = GetObjects();

ListBox1.DataSource = ds_temp;

ListBox1.DataTextField = "yourColumn";

ListBox1.DataValueField = "yourColumn";

ListBox1.DataBind();

}

protected static DataSet GetObjects()

{

DataSet ds_temp = Connection_cls.GetDataSetQuery("SELECT yourColumn FROM yourtable", null);

return ds_temp;

}

private static string getHostString()

{

string host = ConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;

return host;

}

public static DataSet GetDataSetQuery(string sql, ArrayList paramList)

{

using (MySqlConnection conn = new MySqlConnection(getHostString()))

{

try

{

conn.Open();

MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);

da.SelectCommand.Parameters.Clear();

if (paramList != null)

{

for (int i = 0; i < paramList.Count; i++)

{

da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);

}

}

DataSet ds = new DataSet();

da.Fill(ds);

return ds;

}

finally

{

conn.Close();

}

}

}