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();