protected void GetTemplateList() { //select * from VW_GetTemplateDetails HttpContext.Current.Session["ReportDS"] = dsCmnRpt; iPartRequestClient objService = new iPartRequestClient(); CustomProfile profile = CustomProfile.GetProfile(); GVRequest.DataSource = null; GVRequest.DataBind(); long DeptID = long.Parse(Session["DeptID"].ToString()); DataSet dsTemplate = new DataSet(); dsTemplate = objService.GetTemplateDetailsBind(profile.Personal.UserID, DeptID, profile.DBConnection._constr); // dsTemplate = objService.GetTemplateDetails(profile.Personal.UserID, profile.DBConnection._constr); GVRequest.DataSource = dsTemplate; GVRequest.DataBind(); }