C#操作Mysql

最新推荐文章于 2024-09-14 23:40:18 发布

hujiyu2008

最新推荐文章于 2024-09-14 23:40:18 发布

阅读量275

点赞数

分类专栏： Mysql 文章标签： c# exception server mysql user

本文链接：https://blog.csdn.net/hujiyu2008/article/details/7590163

版权

Mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

首先下载下来Mysql.data.dll

然后将其参照到工程里。

......

using MySql.Data.MySqlClient;

......

试验用代码：

MySqlConnection myConn = new MySqlConnection();
   MySqlCommand myCom = new MySqlCommand();
   try
   {
    myConn.ConnectionString = "Server=serverIP;Database=test;Uid=user; Pwd=password;";
    myConn.Open();
    myCom.CommandText = "select * from products";
    myCom.Connection = myConn;
    MySqlDataReader myReader = myCom.ExecuteReader();
    Console.WriteLine("Old result is :");
    while(myReader.Read())
    {
     Console.WriteLine(myReader[0] + "   " + myReader[1]);
    }
    myReader.Close();
    Console.WriteLine("Now update start.");
    myCom.CommandText = "update products set productName = \"new name\" where productCD = 1";
    myCom.ExecuteNonQuery();

    Console.WriteLine("New result is :");
    myCom.CommandText = "select * from products";
    myReader = myCom.ExecuteReader();
    while(myReader.Read())
    {
     Console.WriteLine(myReader[0] + "   " + myReader[1]);
    }
   }
   catch(Exception ex)
   {
    Console.WriteLine(ex.Message);
   }
   finally
   {
    myConn.Close();
   }