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