Archive for December, 2008
MySQL connection for .Net
Monday, December 1st, 2008
想用C#连MYSQL，搞了半天都没连上，无论是用ODBC，还是OLE。看了网上资料，原来是要用mysql专用的DLL。
引用专有类：
using MySql.Data.MySqlClient;
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString=”Server=127.0.0.1;Uid=root;Pwd=xxxxxxx;Database=test”;
MySqlDataAdapter da = new MySqlDataAdapter(”select * from test”,conn);
DataSet ds = new DataSet();
da.Fill(ds,”t”);
