public void resolveIssue(OpenIssue openIssue)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
String qry = String.Empty;
qry = @"update issues set status = 'resolved', timestamp='{0}' where slNo={1} ";
qry = String.Format(qry, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), openIssue.RecordID);
SqlCommand cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
}
