MySQL basic statement and connection string _ MySQL

Download mysqlnet.exe first, and then reference CoreLab. mySql. dll basic statement insertinto 'mis '. 'users' (name, age) values (ywm, 13) selectid, name, agefrom 'mis '. 'users' limit0, 50deletefrom 'mis '. 'users' whereid8update 'mis '. 'users' setnameywm1wh mysql string MySQL statement

Download mysqlnet.exe first, and then reference CoreLab. MySql. dll

Basic statement

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

Connection string

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