public static bool UpdateError(int id, int UserID, string Desc)
{
bool bRet = false;
string sSQL = "";
sSQL = "UPDATE dbo.ErrorTable SET Corrected = 1 WHERE ErrorID=@ID;";
using (Data DC = new Data("conn", "Errors", "UpdateError"))
{
try
{
//make an independent connection to the error database
DC.AddCommand(CommandType.Text, sSQL);
DC.AttachParameterByValue("@UserID", UserID);
DC.AttachParameterByValue("Desc", Desc);
DC.AttachParameterByValue("ID", id);
int iRet = DC.ExecuteCommand();
if (iRet > 0)
{
bRet = true;
}
}
catch
{
bRet = false;
}
finally
{
if (DC != null)
{
DC.Dispose();
}
}
}
return(bRet);
}