protected void Bind_GridViewPatient() { string term = TextboxSearch.Text.Trim().ToLower(); List <Classes.Entity.Patient> patients = therapistBLL.GetUnrequestedPatients(term); ViewState["GridViewPatient"] = patients; GridViewPatient.DataSource = patients; GridViewPatient.DataBind(); UpdatePanelAccounts.Update(); }
public void display() { DataTable dt = new DataTable(); String con; con = "User Id = sandeep; Password=admin; Data source = XE"; cn.ConnectionString = con; cn.Open(); //to display data from department table OracleCommand cmd = new OracleCommand("Select * from Patients_Details", cn); OracleDataAdapter adp = new OracleDataAdapter(cmd); adp.Fill(dt); cn.Close(); GridViewPatient.DataSource = dt; GridViewPatient.DataBind(); }
protected void Bind_GridViewPatientAndRecord() { string nric = string.Empty; if (ViewState["GridViewPatientSelectedPatientNRIC"] != null) { nric = Convert.ToString(ViewState["GridViewPatientSelectedPatientNRIC"]); } List <Record> records = new RecordBLL().GetRecords(nric); ViewState["GridViewRecords"] = records; GridViewRecords.DataSource = records; GridViewRecords.DataBind(); string term = TextboxSearch.Text.Trim().ToLower(); List <Classes.Entity.Patient> patients = therapistBLL.GetCurrentPatients(term); ViewState["GridViewPatient"] = patients; GridViewPatient.DataSource = patients; GridViewPatient.DataBind(); UpdatePanelNewMedicalNote.Update(); }
protected void GridViewPatient_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewPatient.PageIndex = e.NewPageIndex; GridViewPatient.DataSource = ViewState["GridViewPatient"]; GridViewPatient.DataBind(); }