using System;
using MySql.Data.MySqlClient;
 
namespace MySqlDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "server=127.0.0.1;port=3306;database=test_db;charset=utf8;user id=root;password=123456;pooling=false;";
            string sqlstring = "INSERT INTO users(name,sex) VALUES (@name,@sex);";
 
            using (MySqlConnection conn = new MySqlConnection(connectionString))
            {
                using (MySqlCommand cmd = new MySqlCommand())
                {
                    conn.Open();
                    cmd.Connection = conn;
                    cmd.CommandText = sqlstring;
                    cmd.CommandType = System.Data.CommandType.Text;
 
                    // 綁定參數
                    cmd.Parameters.AddWithValue("@name", "Nancy");
                    cmd.Parameters.AddWithValue("@sex", "Female");
 
                    try
                    {
                        // 返回受影響的行數, 執行INSERT語句, 返回創建條目數
                        //                  執行UPDATE語句, 返回更新條目數
                        //                  執行DELETE語句, 返回刪除條目數
                        int val = cmd.ExecuteNonQuery();
                        Console.WriteLine(val);
                    }
                    catch
                    {
                        throw;
                    }
                }
            }
 
            Console.Read();
        }
    }
}