110,533
社区成员
发帖
与我相关
我的任务
分享
public static bool UpdateDataBase(byte[] bytDS, string[] tableName, string[] tempSql)
{
DataSet ds = new DataSet();
ds = serverbase.DecompressDS(bytDS);
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
for (int i = 0; i < tableName.Length; i++)
{
SqlCommand cmd = new SqlCommand(tempSql[i], conn);
cmd.Transaction = tran;
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommandBuilder bld = new SqlCommandBuilder(da);
da.Update(ds.Tables[tableName[i]]);
}
ds.AcceptChanges();
tran.Commit();
return true;
}
catch
{
tran.Rollback();
throw;
}
}
foreach (DataRow dr in ds.Tables["XHMX"].Rows)//處理默認日期不在數據庫合法日期之內的出錯處理(空值默認日期)
{
if (Convert.ToDateTime(dr["XHMX_GMRQ"]).Year < 1900 || dr["XHMX_GMRQ"].ToString()=="")
{
dr["XHMX_GMRQ"] = DBNull.Value;
}
}