西夏普的部落格

1.前言:
本範例說明基本常用的MySQL連線字串的設定。

2.說明:
完整的連線字串說明請參考:
http://www.connectionstrings.com/mysql/

程式碼:

public static MySqlConnection MyOpenConn(string Server, string Database, string dbuid, string dbpwd)
{
	//string cnstr = string.Format("server={0};database={1};uid={2};pwd={3}", Server, Database, dbuid, dbpwd);//標準連線設定
	//string cnstr = string.Format("server={0};database={1};uid={2};pwd={3}; Connect Timeout=180", Server, Database, dbuid, dbpwd);//逾時連線時間設定
	//string cnstr = string.Format("server={0};database={1};uid={2};pwd={3}; Port=3306", Server, Database, dbuid, dbpwd);//通訊端口設定，MySQL的預設端口為3306
	//string cnstr = string.Format("server={0};database={1};uid={2};pwd={3}; Charset=utf8", Server, Database, dbuid, dbpwd);//編碼設定
	string cnstr = string.Format("server={0};database={1};uid={2};pwd={3}; Port=3306; Connect Timeout=180; Charset=utf8", Server, Database, dbuid, dbpwd);//複合設定
	MySqlConnection icn = new MySqlConnection();
	icn.ConnectionString = cnstr;
	if (icn.State == ConnectionState.Open) icn.Close();
	icn.Open();
	return icn;
}