工作小筆記 年紀大了，常常會忘記….

使用ODBC連接MySQL Database

首先，必須先安裝MySQL ODBC Driver，http://dev.mysql.com/downloads/connector/odbc/

# using Odbc libarey
using System.Data.Odbc;

# 建立ODBC connection
OdbcConnection dbconnect = new OdbcConnection();

# 設定ODBC connection字串
String dbconnstr = "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Database=CSD;User=test; Password=1234;Option=3;";
dbconnect.ConnectionString = dbconnstr;

# 開啟DB連線，並執行SQL command
String sqlstr = "select pk,name from calltype limit 1";
dbconnect.Open();
OdbcCommand lv1_sqlcmd = new OdbcCommand(sqlstr, dbconnect);

# 讀取SQL command執行結果
OdbcDataReader lv1_rs = lv1_sqlcmd.ExecuteReader();
while (lv1_rs.Read()) {
String pk = lv1_rs[0].ToString();
String name = lv1_rs[1].ToString();
}

# 關閉DB連線
dbconnect.Close();

ComboBox分別給予名稱跟值

DataTable skill_dt = new DataTable();
skill_dt.Columns.Add("value");
skill_dt.Columns.Add("name");

skill_dt.Rows.Add("", "請選擇");
skill_dt.Rows.Add("A", "組別1");
skill_dt.Rows.Add("B", "組別2");
skill_dt.Rows.Add("C", "組別3");
skill_dt.Rows.Add("D", "組別4");
skill_dt.Rows.Add("E", "組別5");
skill_dt.Rows.Add("F", "組別6");

skill.DataSource = skill_dt;
skill.DisplayMember = "name";
skill.ValueMember = "value";