string commandtext = string.Empty;
try
{
DB.Connect();
DB.CreateDbCommand(UserSchema + "." + "UpdateWorkOrder", true);
DB.AddTableParameter(dt, "@TableVar");
//DB.AddParameter("@TableVar", SqlDbType.Structured, null, dt);
DB.ExecuteNonQuery();
DB.EndCommand();
}
catch (Exception ex)
{
DB.Close();
throw ex;
}
try
{
DB.Connect();
DB.CreateDbCommand(UserSchema + "." + "UpdateWorkOrder", true);
DB.AddTableParameter(dt, "@TableVar");
//DB.AddParameter("@TableVar", SqlDbType.Structured, null, dt);
DB.ExecuteNonQuery();
DB.EndCommand();
}
catch (Exception ex)
{
DB.Close();
throw ex;
}
No comments:
Post a Comment