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;
}
05-25
630