作者:拍友2502906483 | 来源:互联网 | 2018-04-20 06:14
需要先下载mysqlnet.exe,安装后引用CoreLab.MySql.dll基本语句insertinto`mis`.`users`(name,age)values(ywm,13)selectid,name,agefrom`mis`.`users`limit0,50deletefrom`mis`.`users`whereid8update`mis`.`users`setnameywm1wh
mysql字符串MySQL语句
需要先下载mysqlnet.exe,安装后引用CoreLab.MySql.dll
基本语句
insert into `mis`.`users` ( name, age) values ( "ywm", 13)
select id, name, age from `mis`.`users` limit 0, 50
delete from `mis`.`users` where id > 8
update `mis`.`users` set name = "ywm1" where id = 13
连接字符串
MySqlConnection cOnn= new MySqlConnection("User Id=root;Password=sa;Host=localhost;Database=mis;");
conn.Open();
MySqlDataAdapter da = new MySqlDataAdapter("select id, name, age from `mis`.`users` ",conn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
conn.Close();
DataGrid1.DataSource= ds;
DataGrid1.DataBind();