DataSet批量更新数据库

 public void CopyData(DataSet ds, string conString, string sql, string tableName)
 {
  SqlConnection conn = new SqlConnection(conString);

  try
  {
  conn.Open();
  SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
  SqlCommandBuilder cb = new SqlCommandBuilder(ada);

  DataSet destDataSet = new DataSet();
  ada.Fill(destDataSet, tableName);

  //Delete Rows
  foreach (DataRow item in destDataSet.Tables["Pattern"].Rows)
  {
   item.Delete();
  }
  DataTable dt = null;

  dt = destDataSet.Tables["Pattern"].GetChanges();
  if (dt != null)
  {
   ada.Update(dt);
  }

  //Insert Rows
  foreach (DataRow item in ds.Tables["Pattern"].Rows)
  {
   item.SetAdded();
  }
  dt = ds.Tables["Pattern"].GetChanges();
  if (dt != null)
  {
   ada.Update(dt);
  }
  }
  catch (Exception ex)
  {
  throw ex;
  }
  finally
  {
  conn.Close();
  }
 }