private void BindGrid() { string filePath = ConfigurationManager.AppSettings["NHIS"]; string path = Server.MapPath(filePath); DataTable dt = new DataTable("Study"); if (path != null) { try { //Add Columns in datatable - Column names must match XML File nodes dt.Columns.Add("Id", typeof(System.String)); dt.Columns.Add("Name", typeof(System.String)); dt.Columns.Add("FileExists", typeof(System.String)); // Reading the XML file and display data in the gridview dt.ReadXml(path); } catch (Exception e) { throw e; } } //GridViewStudy.DataSource = dt; GridViewStudy.DataSource = dt; GridViewStudy.DataBind(); GridViewStudy.HeaderRow.TableSection = TableRowSection.TableHeader; }
void BindData() { PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); PS_PRO_LICENSE PLicense = new PS_PRO_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PRO_LICENSE("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); PS_TRAINING Training = new PS_TRAINING(); DataTable dt3 = Training.SELECT_PS_TRAINING("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); PS_PUNISHMENT Punishment = new PS_PUNISHMENT(); DataTable dt4 = Punishment.SELECT_PS_PUNISHMENT("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", ""); GridViewPunish.DataSource = dt4; GridViewPunish.DataBind(); SetViewState(dt4); PS_POSI_AND_SALARY PosiSalary = new PS_POSI_AND_SALARY(); DataTable dt5 = PosiSalary.SELECT_PS_POSI_AND_SALARY("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", "", "", "", "", ""); GridViewPosiSalary.DataSource = dt5; GridViewPosiSalary.DataBind(); SetViewState(dt5); }
protected void myGridViewStudy_PageIndexChanging1(object sender, GridViewPageEventArgs e) { GridViewStudy.PageIndex = e.NewPageIndex; GridViewStudy.DataSource = GetViewState(); GridViewStudy.DataBind(); }