protected void Page_Load(object sender, EventArgs e) { DBClient dbc = new DBClient(); if (!txb_name.Text.Equals("") || !txb_hos.Text.Equals("") || !ddl_spec.SelectedValue.Equals("") || !ddl_gender.SelectedValue.Equals("")) { String name = txb_name.Text; String hospital = txb_hos.Text; String spec = ddl_spec.SelectedValue; String gender = ddl_gender.SelectedValue; String isAvailable = ddl_avl.SelectedValue; DataTable dt_doc = dbc.findDoctor(name, gender, spec, hospital, isAvailable); dt_doc.Columns.Add("link"); foreach (DataRow dr in dt_doc.Rows) { dr.SetField("link", "docProfile.aspx?docId=" + dr["f_id"]); } gv_doctor.DataSource = dt_doc; gv_doctor.DataBind(); } DataTable dt_spec = dbc.getDoctorType(); ddl_spec.DataSource = dt_spec; ddl_spec.DataTextField = "f_spec_name"; ddl_spec.DataValueField = "f_spec_id"; ddl_spec.DataBind(); DataTable dt_gender = new DataTable(); dt_gender.Columns.Add("text"); dt_gender.Rows.Add("male"); dt_gender.Rows.Add("female"); ddl_gender.DataSource = dt_gender; ddl_gender.DataTextField = "text"; ddl_gender.DataValueField = "text"; ddl_gender.DataBind(); DataTable dt_avl = new DataTable(); dt_avl.Columns.Add("text"); dt_avl.Rows.Add("true"); dt_avl.Rows.Add("false"); ddl_avl.DataSource = dt_avl; ddl_avl.DataTextField = "text"; ddl_avl.DataValueField = "text"; ddl_avl.DataBind(); }
public DataTable findDoctor(String name, String gender, String specialty, String hos_id, String isAvailable) { DBClient dbc = new DBClient(); return dbc.findDoctor(name, gender, specialty, hos_id, isAvailable); }