c#操作MySql数据库

需要mysql.data.dll
数据库连接

//server数据库地址，user数据库用户名，password密码，database数据库名string ConnectString = string.Format("Server={0};User ID={1};Password={2};Database={3};", server, user, password, database);MySqlConnection conn = new MySqlConnection(ConnectString );conn.Open();//加数据库操作conn.Close();conn.Dispose();

添加

MySqlCommand command = conn.CreateCommand();string str = "INSERT INTO {0}(id,name)VALUES('{1}','{2}')";//{0}表名，{1}字段id的值，{2}字段name的值command.CommandText = string.Format(str, table, ID, Name);command.ExecuteNonQuery();

删除

MySqlCommand command = conn.CreateCommand();string str = string.Format("DELETE FROM {0} WHERE id='{1}'", table, IdNumber);command.CommandText = str;command.ExecuteNonQuery();

修改

MySqlCommand command = conn.CreateCommand();string str = "UPDATE {0} SET id='{1}',name='{2}'";command.CommandText = string.Format(str, table, Id, Name);command.ExecuteNonQuery();

清空表

MySqlCommand command = conn.CreateCommand();string str = string.Format("truncate table {0}", table);command.CommandText = str;command.ExecuteNonQuery();

查找

string command = string.Format("SELECT * FROM {0}", table);//MySqlCommand mycmd = new MySqlCommand(command, conn);MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);DataSet ds = new DataSet();adapter.Fill(ds);for (int i = 0; i < ds.Tables[0].Rows.Count; i++){    string id = ds.Tables[0].Rows[i][0].ToString();    string name = ds.Tables[0].Rows[i][1].ToString();}