private ProjectCostingSheetsNavigatorTDS SubmitSearch()
        {
            ProjectCostingSheetsNavigatorTDS projectCostingSheetsNavigatorTDS = new ProjectCostingSheetsNavigatorTDS();
            // ... Load data
            ProjectCostingSheetsNavigator projectCostingSheetsNavigator = new ProjectCostingSheetsNavigator(projectCostingSheetsNavigatorTDS);
            projectCostingSheetsNavigator.LoadByProjectId(Int32.Parse(hdfProjectId.Value.ToString()), Int32.Parse(hdfCompanyId.Value.ToString()));

            ProjectCombinedCostingSheetsNavigator projectCombinedCostingSheetsNavigator = new ProjectCombinedCostingSheetsNavigator(projectCostingSheetsNavigatorTDS);
            projectCombinedCostingSheetsNavigator.LoadByClientId(Int32.Parse(hdfClientId.Value.ToString()), Int32.Parse(hdfCompanyId.Value.ToString()));

            return (ProjectCostingSheetsNavigatorTDS)projectCostingSheetsNavigatorTDS;
        }
        private void PostPageChangesCombinedCostingSheets()
        {
            ProjectCombinedCostingSheetsNavigator projectCombinedCostingSheetsNavigator = new ProjectCombinedCostingSheetsNavigator(projectCostingSheetsNavigatorTDS);

            // Update grid rows
            foreach (GridViewRow row in grdCombinedCostingSheetsNavigator.Rows)
            {
                int costingSheetId = int.Parse(((Label)row.FindControl("lblCostingSheetID")).Text);
                bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;

                projectCombinedCostingSheetsNavigator.Update(costingSheetId, selected);
            }

            projectCombinedCostingSheetsNavigator.Data.AcceptChanges();

            // Store datasets
            Session["projectCostingSheetsNavigatorTDS"] = projectCostingSheetsNavigatorTDS;
        }