C#连接MySql

导入mysql的dll

using System;
using MySql.Data.MySqlClient;

namespace netlinkmysql
{
    class Program
    {
        static void Main(string[] args)
        {            
            string connectStr = "server=127.0.0.1;port=3306;database=gamedb;user=root;password=root";
            MySqlConnection c = new MySqlConnection(connectStr);
            try
            {
                //试着运行这里的代码
                //Read(c);
                Insert(c);
            }
            catch(Exception e)
            {
                //如果报错执行这里
                Console.WriteLine(e.ToString());
            }
            finally
            {
                //执行完上面的代码之后，执行这里
                c.Clone();
            }
            Console.Read();
        }
        //插入数据
        private static void Insert(MySqlConnection c)
        {
            c.Open();
            string sql = "INSERT INTO `gamedb`.`users` (`username`, `password`) VALUES ('11', '22')";
            //创建命令
            MySqlCommand cmd = new MySqlCommand(sql, c);
            var result = cmd.ExecuteNonQuery();//执行SQL语句
        }
        //获取数据
        private static void Read(MySqlConnection c)
        {
            c.Open();
            string sql = "select * from users";
            //执行SQL语句
            MySqlCommand cmd = new MySqlCommand(sql, c);
            //获取数据集
            MySqlDataReader reader = cmd.ExecuteReader();
            //读取第一行
            reader.Read();
            //显示第一行的1-4个数据
            Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString() + reader[3].ToString());
            //读取第二行
            reader.Read();
            //显示第二行的1-4个数据
            Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString() + reader[3].ToString());
            Console.WriteLine("已经建立连接");
        }
    }
}