protected void btnsrh_Click(object sender, EventArgs e)
{
string Doctor = DDlDoctor.Text;
MySqlConnection con = new MySqlConnection(cs);
con.Open();
MySqlCommand cmd = new MySqlCommand();
string query = "SELECT * FROM hospitaldb.appointment WHERE Doctor='" + @Doctor + "' ";
cmd.CommandText = query;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Doctor", Doctor);
DataTable dl = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dl);
con.Close();
GVCheckAppoinment.DataSource = dl;
GVCheckAppoinment.DataBind();
}
void GVbind()
{
DataTable dtbl = new DataTable();
MySqlConnection con = new MySqlConnection(cs);
con.Open();
MySqlDataAdapter sqlDa = new MySqlDataAdapter("SELECT * FROM hospitaldb.appointment", con);
sqlDa.Fill(dtbl);
GVCheckAppoinment.DataSource = dtbl;
GVCheckAppoinment.DataBind();
}
