vs2008下c#连接MySQL数据库

 使用MySql.Data.dll(5.0.9.0)组件来实现，先安装，后在引用中添加刚才安装的MySQL.Data,在头文件中添加using MySql.Data.MySqlClient;

            MySqlConnection Conn = new MySqlConnection("Database='"+database+"';Data Source='"+local+"';User Id='"+user+"';Password='"+password+"'");//连接MySQL数据库
           
            MySqlDataAdapter Da = new MySqlDataAdapter("select distinct name,id,pin_all from "+table+" ", Conn);
            DataTable Dt = new DataTable();
            Da.Fill(Dt);

这些是连接MySQL数据库的代码；

        public static long RunSqlDatacmd(string sql)
        {
            MySqlConnection dbconn = new MySqlConnection("Database='" + database + "';Data Source='" + local + "';User Id='" + user + "&