MySql batch update

String connstring = @ "Data Source = localhost; Port = 3307; Database = test; User ID = root; Password = pass; Charset = utf8"; DataSet dataSet = new DataSet (); mySqlDataAdapter da = new MySqlDataAdapter (); using (MySqlConnection conn = new MySqlConnection (connstring) {MySqlCommand selectCommand = new MySqlCommand ("select * from dept order by deptno", conn ); da. selectCommand = selectCommand; da. fill (dataSet, "dept"); foreach (var dataRow in dataSet. tables [0]. select () {Console. writeLine (dataRow ["deptno"] + "-" + dataRow ["deptname"]);} MySqlCommand insertCommand = new MySqlCommand ("insert into dept (deptno, deptname) values (@ deptno, @ deptname) ", conn); MySqlParameter [] insertPara = {new MySqlParameter (" @ deptno ", MySqlDbType. varChar), new MySqlParameter ("@ deptname", MySqlDbType. varChar)}; insertPara [0]. sourceColumn = "deptno"; insertPara [1]. sourceColumn = "deptname"; foreach (var p in insertPara) {insertCommand. parameters. add (p);} da. insertCommand = insertCommand; MySqlCommand delCommand = new MySqlCommand ("delete from dept where deptno = @ deptno", conn); MySqlParameter [] delPara = {new MySqlParameter ("@ deptno", MySqlDbType. varChar)}; delPara [0]. sourceColumn = "deptno"; foreach (var p in delPara) {delCommand. parameters. add (p);} da. deleteCommand = delCommand; MySqlCommand updateCommand = new MySqlCommand ("update dept set deptno = @ deptno, deptname = @ deptname where deptno = @ deptno", conn ); mySqlParameter [] updatePara = {// new MySqlParameter ("@ id", MySqlDbType. int32), new MySqlParameter ("@ deptno", MySqlDbType. varChar), new MySqlParameter ("@ deptname", MySqlDbType. varChar)}; // updatePara [0]. sourceColumn = "id"; updatePara [0]. sourceColumn = "deptno"; updatePara [1]. sourceColumn = "deptname"; foreach (var p in updatePara) {updateCommand. parameters. add (p);} da. updateCommand = updateCommand; // add DataRow row = dataSet. tables [0]. newRow (); row ["deptno"] = "1001"; row ["deptname"] = "p1"; dataSet. tables [0]. rows. add (row); // del DataRow [] rowDel = dataSet. tables [0]. select ("deptno in (" + "'10'" + ")"); foreach (var dataRow in rowDel) {dataSet. tables [0]. rows. remove (dataRow);} // update DataRow [] rowUpdate = dataSet. tables [0]. select ("deptno in (" + "'20'" + ")"); foreach (var dataRow in rowUpdate) {dataRow. beginEdit (); dataRow ["deptname"] = "MM"; dataRow. endEdit ();} da. update (dataSet, "dept"); dataSet. acceptChanges (); Console. writeLine (); foreach (var dataRow in dataSet. tables [0]. select () {Console. writeLine (dataRow ["deptno"] + "-" + dataRow ["deptname"]) ;}} Console. readLine ();