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