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"]);

            }

            

            

        }

这是一个简单的例子。
在这里有个问题：dataset如果没设主键的话，可能会引起一些对数库操作的问题，比如会造成updata出现错误。