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