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