C#使用MySQLDriverCSS连接MySQL数据库的方法

    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},tttddddd:{1},tt {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"]);  
                }  
                  
                  
            }