C#使用MySQLDriverCS操作MySQL实例教程代码

C# 操作MySQL实例教程代码，发给喜欢代码的朋友，呵呵。

本文使用MySQLDriverCS操作MYSQL数据库，使用前请先引入MySQLDriverCS.dll文件，支持PHP4.0和PHP5.0

C#代码
static void Main(string[] args)   
        {   
            string sqlstr = "select * from manavatar";   
            MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString("192.168.0.13", "flashdata", "root", "root", 3306).AsString);   
            DBConn.Open();   
            //MySQLDataAdapter myadap = new MySQLDataAdapter(sqlstr, conn);   
            MySQLCommand DBComm = new MySQLCommand(sqlstr,DBConn);   
            MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); //DBComm.ExecuteReaderEx();   
            MySQLDataAdapter DTAdapter = new MySQLDataAdapter(sqlstr,DBConn);   
               
            DataSet myDataSet = new DataSet();   
            DTAdapter.Fill(myDataSet,"manavatar");   
             
            
            try  
            {   
                while (DBReader.Read())   
                {   
                    //Console.WriteLine("11");   
         Console.WriteLine("DBReader:{0},\t\t\tddddd:{1},\t\t {2}",DBReader.GetString(0), DBReader.GetString(1),DBReader.GetString(3));   
                }   
                Console.WriteLine("0000");   
            }   
            catch (Exception e)   
            {    
                Console.WriteLine("读入失败！"+e.ToString());   
            }   
            finally  
            {   
                Console.WriteLine("DBReader关闭");   
                Console.WriteLine("DBConn关闭");   
                DBReader.Close();   
                //DBConn.Close();   
            }   
               
            for (int i = 0; i < myDataSet.Tables["manavatar"].Rows.Count; i++)   
            {   
                Console.WriteLine("{0}",myDataSet.Tables["manavatar"].Rows[2]["user"]);   
            }   
               
               
        }