C#连接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},\t\t\tddddd:{1},\t\t {2}",DBReader.GetString(0), DBReader.GetString(1),DBReader.GetString(3));
                }
                Console.WriteLine("0000");
            }
            catch (Exception e)

[1] [2] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:使用C#查询路由接口，同时小议一些.net 2.0的诡异API

下一篇:采用C#泛型实现数据库之间的切换