C#Update批量更新数据

           

批量更新表之手动生成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