private void Save() { // Save to database DB.Open(); DB.BeginTransaction(); try { int newCompanyLevelIdForInsert = 0; // Save companyLevels CompanyLevelsAddNew companyLevelsAddNew = new CompanyLevelsAddNew(companyLevelsAddTDS); newCompanyLevelIdForInsert = companyLevelsAddNew.Save(); // Save companyLevels managers int companyId = Int32.Parse(hdfCompanyId.Value); CompanyLevelsAddManagers companyLevelsAddManagers = new CompanyLevelsAddManagers(companyLevelsAddTDS); companyLevelsAddManagers.Save(newCompanyLevelIdForInsert, companyId); // Store datasets companyLevelsAddTDS.AcceptChanges(); Session["companyLevelsAddTDS"] = companyLevelsAddTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }