C# MySQL 数据操作示例-优快云博客

本文链接：https://blog.youkuaiyun.com/hujiyu2008/article/details/7590163

本文介绍如何使用C#连接MySQL数据库，并演示了基本的数据读取与更新操作。通过具体的代码实例，展示了如何建立数据库连接、执行SQL查询及更新语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先下载下来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();
   }

C#操作Mysql