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

精选转载

c1230v 2010-03-16 16:59:20 博主文章分类：.NET

文章标签 实例代码 MySQL 数据库教程 文章分类 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"]);
            }


        }