#眉標=MySQL、C#、UTF-8
#副標=MySQL Server開發應用（1）
#大標=前端C#後端MySQL
#作者=文／圖	葉建榮



===<反灰>=============
MySql.Data.MySqlClient.MySqlConnection  conn;
string  myConnectionString;
myConnectionString = "server=localhost;uid=root;pwd=runpc;database=test;";
try
{ conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
  conn.Open();  }
catch (MySql.Data.MySqlClient.MySqlException ex)
  { switch (ex.Number)
    { case 0:
     MessageBox.Show("不能連線到主機");
     break;
     case 1045:
     MessageBox.Show("帳號或密碼錯誤");
     break; }            }
==<end>==============




===<反灰>=============
//請記得最前面一行要加上using  MySql.Data.MySqlClient;
// myConnectionString語法如上例 
MySqlConnection myConnection = new MySqlConnection(myConnectionString);
string myinsertquery = string.Format("insert into customer(id,username)values ('{0}','{1}')",textBox1.Text, textBox2.Text);
MySqlCommand myCommand = new MySqlCommand(myinsertquery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
==<end>==============




===<反灰>=============
//請記得最前面一行要加上using  MySql.Data.MySqlClient;
// myConnectionString語法如上例 
conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
conn.Open(); 
cmd.CommandText = "insert into customer values (?id, ?username)";
cmd.Parameters.Add("?id", MySqlDbType.Int);
cmd.Parameters.Add("?username", MySqlDbType.Varchar);
cmd.Parameters[0].Value = int.Parse(textBox1.Text);
cmd.Parameters[1].Value = textBox2.Text;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
==<end>==============