Bug's Life

//引用MySQL套件參考 
using MySql.Data.MySqlClient;   

//資料庫位址 
MySqlConnection myConnection = new MySqlConnection("server=資料庫IP; user id=資料庫使用者帳號; password=帳號的密碼; database=資料庫名稱; pooling=false; CharSet=utf8");   

//開啟資料庫 
myConnection.Open();   

/*更新*/
string update = string.Format("update 資料表 set 欄位1='{0}', 欄位2='{1}'", 值1,值2); 
MySqlCommand updateCmd = new MySqlCommand(update, myConnection); 
updateCmd.Connection = myConnection; 

//執行更新 
updateCmd.ExecuteNonQuery();   

/*新增*/
string AddNew = string.Format("INSERT INTO 資料表(欄位1, 欄位2) VALUES('{0}','{1}')", 值1, 值2); 
MySqlCommand AddNewCmd = new MySqlCommand(AddNew, myConnection); 
AddNewCmd.Connection = myConnection; 

//執行新增 
AddNewCmd.ExecuteNonQuery();   

/*刪除*/
string Del = string.Format("DELETE FROM 資料表 WHERE 欄位 = '{0}'", 值); 
MySqlCommand DelCmd = new MySqlCommand(Del, myConnection); 
DelCmd.Connection = myConnection; 

//執行刪除 
DelCmd.ExecuteNonQuery();     

//關閉資料庫 
myConnection.Close();