private void Save() { // save to database DB.Open(); DB.BeginTransaction(); try { SupportTicketCategoryAddNew supportTicketCategoryAddNew = new SupportTicketCategoryAddNew(supportTicketCategoriesAddTDS); supportTicketCategoryAddNew.Save(); // Store datasets supportTicketCategoriesAddTDS.AcceptChanges(); Session["supportTicketCategoriesAddTDS"] = supportTicketCategoriesAddTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }