[MySQL][C#] ODBC 連線


private OdbcConnectionStringBuilder odbcConn = new OdbcConnectionStringBuilder();
private OdbcConnection myConn = new OdbcConnection();


odbcConn.Driver = "MySQL ODBC 5.1 Driver";
odbcConn["Server"] = "LocalHost";
odbcConn["Database"] = "ms";
odbcConn["Uid"] = "User";
odbcConn["Pwd"] = "12345678";
myConn.ConnectionString = odbcConn.ConnectionString;


myConn.Open();
OdbcCommand command = new OdbcCommand("SELECT * FROM XXX, myConn);
OdbcDataAdapter myAdapter = new OdbcDataAdapter(command.CommandText, myConn);
DataSet myDS = new DataSet();
myAdapter.Fill(myDS);
// 利用DataList 繫結資料
DataList1.DataSource = myDS;
DataList1.DataBind();

myConn.Close();