public void LoadPatientIE(string date, int LId) { try { // int totalcount; DataSet dt = new DataSet(); //dt = db.selectData(query); dt = db.PatientSP(date, LId); DataRow dr = null; if (dt.Tables[0].Rows.Count > 0) { if (dt.Tables[0].Rows.Count > 0) { rpview.DataSource = dt; rpview.DataBind(); } } else { rpview.DataSource = null; rpview.DataBind(); } //PopulatePager(totalcount, pageindex); //lblcount.Text = totalcount.ToString(); // BindRepeater(); } catch (Exception ex) { } }