高效的C#中DataTable插入MySql数据库的方法

 public int uploadpostcurarrangeitems(DataTable dt)
    {
        int updaterow = 1;
        string strSql = "select * from manpower_postcurarrange order by CurrentArrangeID desc limit 1";
        MySqlConnection Conn = new MySqlConnection(Get_connstring());
        Conn.Open();
        MySqlDataAdapter objAdapt = new MySqlDataAdapter(strSql, Conn);
        DataSet ds = new DataSet();
        objAdapt.Fill(ds);
        MySqlCommandBuilder cust = new MySqlCommandBuilder(objAdapt);
        objAdapt.InsertCommand = cust.GetInsertCommand();
        objAdapt.UpdateCommand = cust.GetUpdateCommand();
        objAdapt.DeleteCommand = cust.GetDeleteCommand();
        try
        {
            int i = 0;
            foreach (DataRow dr in dt.Rows)
            {
                DataRow drNew = ds.Tables[0].NewRow();
                drNew["PostID"] = dr["PostID"];
                drNew["BadgeID"] = dr["BadgeID"];
                drNew["CheckUser"] = dr["CheckUser"];
                drNew["UpdateTime"] = dr["UpdateTime"];
                ds.Tables[0].Rows.Add(drNew);
                i++;
            }
            objAdapt.Update(ds);
            ds.AcceptChanges();
        }
        catch
        {
            updaterow = 0;
        }
        finally
        {
            Conn.Close();
        }
        return updaterow;
    }