MySQL基本语句和连接字符串

MySQL基本语句和连接字符串

【字体：小 大】

MySQL基本语句和连接字符串

作者：不详 文章来源：网络 点击数：201 更新时间：2007-1-21

需要先下载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();

[责任编辑:电脑技巧]