C#Update批量更新数据

最新推荐文章于 2025-05-30 09:03:51 发布

转载最新推荐文章于 2025-05-30 09:03:51 发布 · 6.5k 阅读

文章标签：

#da.Update #OleDbCommandBuilder #Parameters

C# 专栏收录该内容

43 篇文章

订阅专栏

本文介绍了使用OleDbDataAdapter和OleDbCommand手动构建SQL语句来批量更新、插入和删除数据库表的方法，并展示了如何通过OleDbCommandBuilder来自动生成这些SQL语句。

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

批量更新表之手动生成sql；

string sql1 = "update Users set User_name=@User_name where User_id=@User_id ";

string sql2 = "insert into Users (User_id,User_name) Values (@User_id, @User_name )";
string sql3 = "delete from Users where User_id = @User_id";

OleDbCommand cmd1 = new OleDbCommand(sql1, m_conn);
OleDbCommand cmd2 = new OleDbCommand(sql2, m_conn);
OleDbCommand cmd3 = new OleDbCommand(sql2, m_conn);

cmd1.Parameters.Add("@User_name", OleDbType.VarChar, 50, "User_name");
cmd1.Parameters.Add("@User_id", OleDbType.VarChar, 30, "User_id");

cmd2.Parameters.Add("@User_id", OleDbType.VarChar, 30, "User_id");

cmd2.Parameters.Add("@User_name", OleDbType.VarChar, 50, "User_name");

cmd3.Parameters.Add("@User_id", OleDbType.VarChar, 30, "User_id");

OleDbDataAdapter da = new OleDbDataAdapter();
da.UpdateCommand = cmd1;

da.InsertCommand = cmd2;

da.DeleteCommand = cmd3;

da.Update(m_ds , "Users");

批量更新表之自动生成sql；

OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommandBuilder cbIn = new OleDbCommandBuilder(da);
OleDbCommand cmdIn = new OleDbCommand("select * from Users" , conn);
da.SelectCommand = cmdIn;
da.Fill(m_ds, "Users");
m_ds.Tables[0].Rows[1].Delete();
m_ds.Tables[0].Rows[2]["User_name"] = "wwwwwwww";

m_db.Update(m_ds, "Users");//修改

引自：http://www.cnblogs.com/fellowcheng/articles/533351.html