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(); }