SqlCommandBuilder 删除与更新的用法,附代码-优快云博客

本文链接：https://blog.youkuaiyun.com/brian0031/article/details/6653783

本文介绍了一个使用 C# 进行 SQL 数据库操作的例子，包括从 DataGridView 控件读取数据并更新到 SQL Server 数据库的过程，同时实现了数据的删除与更新。

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

using System.Data.SqlClient;

private void toolStripButton2_Click(object sender, EventArgs e) //保存
{
   string str = string.Empty;
   str = "SELECT [model] as 产品编号,[customer] as 客户别 FROM [wax_Data] where 1=2";
   try
   {
   dt = SQL.command(str).Tables[0]; //避免SQL的注入式攻击
   }
   catch
   {
   return;
   }
   for (int i = 0; i < dataGridView1.Rows.Count; i++)
   {
   DataRow drow = dt.NewRow();
   try
   {
   drow["产品编号"] = dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
   drow["客户别"] = dataGridView1.Rows[i].Cells[1].Value.ToString().Trim();
   }
   catch
   {
   return;
   }
   dt.Rows.Add(drow);
   ds_modify = new DataSet();
   DataTable dt_modify = dt.Copy();
   ds_modify.Tables.Add(dt_modify);
   }
   string con = string.Empty;
   con = "Server = (local)\\SQLEXPRESS;database = PCMIS;user = sa;pwd = Qz@!973?1";//本地数据库服务器
   SqlConnection conn = new SqlConnection(con);
   SqlDataAdapter adapter = new SqlDataAdapter();
   adapter.SelectCommand = new SqlCommand("SELECT [model] as 产品编号,[customer] as 客户别 FROM [wax_Data] where 1=2", conn);
   adapter.DeleteCommand = new SqlCommand("delete from [PCMIS].[dbo].[wax_Data] where " + str1, conn);
   SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
   try
   {
   conn.Open();
   adapter.DeleteCommand.ExecuteNonQuery();//删除数据
   if (ds_modify.Tables.Count > 0)
   {
   try
   {
   adapter.Update(ds_modify); //删除后,最后一行为空行时,会报错
   }
   catch
   {
   return;
   }
   }
   }
   finally
   {
   if (conn != null)
   {
   conn.Close();
   conn.Dispose();
   }
   if (adapter != null)
   {
   adapter.Dispose();
   }
   }
}