导入包:MySql.Data.dll
添加命名空间MySql.Data.MySqlClient后,像操作SQLServer一样操作MYSQL,常用类MySqlConnection,MySqlDataAdapter,MySqlCommand都和SQLServer一样用,只是名字变了点,
连接语句:
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
1、获取数据:
public static MySqlConnection getMycon()
{
string mysqlst = string.Format("Server=192.168.1.20;Database=cy;Uid=sa;Pwd=123456;");
MySqlConnection con = new MySqlConnection(mysqlst);
return con;
}
public static DataTable getDataTable(string sqlst)
{
DataTable dt = new DataTable();
MySqlConnection con = getMycon();
con.Open();
MySqlDataAdapter ada = new MySqlDataAdapter(sqlst ,con);
ada.Fill(dt);
con.Close();
return dt;
}
- 1
- 2
- 3
- 4
- 5
- 6
前往页