private void LoadPatients()
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT OpdNo,PatientName,FathersName,Phone,Email,DateofBirth,Gender,District,State,pincode,AadharNo FROM Patients ORDER BY OpdNo DESC", conn);
DataTable dt = new DataTable();
da.Fill(dt);
UserrecordsGridView.DataSource = dt;
UserrecordsGridView.DataBind();
conn.Close();
BPSearch.Enabled = true;
BPRefresh.Enabled = false;
BPRefresh.BackColor = System.Drawing.Color.White;
BPRefresh.ForeColor = System.Drawing.Color.DarkGray;
BPSearch.BackColor = Color.FromName("#c23838");
BPSearch.ForeColor = Color.FromName("#fff");
}
protected void BPRefresh_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand query = new SqlCommand("SELECT OpdNo,PatientName,FathersName,Phone,Email,DateofBirth,Gender,District,State,pincode,AadharNo FROM Patients WHERE OpdNo like '%'+@OpdNo+'%' and PatientName like '%'+@Patientname+'%'", conn);
query.Parameters.AddWithValue("Opdno", "");
query.Parameters.AddWithValue("Patientname", "");
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(query);
sda.Fill(dt);
UserrecordsGridView.DataSource = dt;
UserrecordsGridView.DataBind();
BPRefresh.Enabled = false;
BPSearch.Enabled = true;
BPRefresh.BackColor = System.Drawing.Color.White;
BPRefresh.ForeColor = System.Drawing.Color.DarkGray;
BPSearch.BackColor = Color.FromName("#c23838");
BPSearch.ForeColor = Color.FromName("#fff");
TodayAppointPanel.Visible = false;
RecordsPanel.Visible = false;
PatientsPanel.Visible = true;
}
