public void power_search_doctor_pageloaddata()
 {
     Code cd = new Code();
     DataSet ds = cd.power_search_doctor_pageloaddata();
     if (ds != null && ds.Tables[0].Rows.Count > 0)
     {
         // Health center Names
         DropDownList1.DataTextField = ds.Tables[0].Columns["Name"].ToString();
         DropDownList1.DataValueField = ds.Tables[0].Columns["ID"].ToString();
         DropDownList1.DataSource = ds.Tables[0];
         DropDownList1.DataBind();
         DropDownList1.Items.Insert(0, "Any");
         // Studied at - Country table
         DropDownList7.DataTextField = ds.Tables[1].Columns["Name"].ToString();
         DropDownList7.DataValueField = ds.Tables[1].Columns["ID"].ToString();
         DropDownList7.DataSource = ds.Tables[1];
         DropDownList7.DataBind();
         DropDownList7.Items.Insert(0, "Any");
         // Worked at - Country table
         DropDownList2.DataTextField = ds.Tables[1].Columns["Name"].ToString();
         DropDownList2.DataValueField = ds.Tables[1].Columns["ID"].ToString();
         DropDownList2.DataSource = ds.Tables[1];
         DropDownList2.DataBind();
         DropDownList2.Items.Insert(0, "Any");
         // Specialist - Specifications table
         DropDownList4.DataTextField = ds.Tables[2].Columns["Name"].ToString();
         DropDownList4.DataValueField = ds.Tables[2].Columns["ID"].ToString();
         DropDownList4.DataSource = ds.Tables[2];
         DropDownList4.DataBind();
         DropDownList4.Items.Insert(0, "Any");
     }
 }