Step1:App.config文件里進行配置

<?xml version="1.0" encoding="utf-8" ?> <configuration><startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" /></startup> <connectionStrings><add name="Connect" connectionString="server=localhost;user=root;pwd=admin;database=BlackCat"/></connectionStrings> </configuration>

Step2:添加引用

?

Step3:使用

public class MySqlHelp{public static string connectString = ConfigurationManager.ConnectionStrings["Connect"].ConnectionString.ToString();/// <summary>/// 執行sql語句返回受影響的行數/// </summary>/// <param name="sql"></param>/// <returns></returns>public static int ExecuteSql(string sql){int count;using (MySqlConnection con = new MySqlConnection(connectString)){using (MySqlCommand cmd = new MySqlCommand(sql, con)){try{con.Open();count = cmd.ExecuteNonQuery();return count;}catch(MySqlException e){con.Close();throw e;}}}} }

?

轉載于:https://www.cnblogs.com/berlinman/p/10050376.html

總結

以上是生活随笔為你收集整理的访问Mysql数据库，连接字符串配置的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。