public void power_search_clinic_pageloaddata() { Code cd=new Code(); DataSet ds=cd.power_search_clinic_pageloaddata(); if(ds!=null && ds.Tables[0].Rows.Count>0) { // Health center type name - Speciality table 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"); // Specialists - Specifications table DropDownList6.DataTextField = ds.Tables[2].Columns["Name"].ToString(); DropDownList6.DataValueField = ds.Tables[2].Columns["ID"].ToString(); DropDownList6.DataSource = ds.Tables[2]; DropDownList6.DataBind(); DropDownList6.Items.Insert(0, "Any"); // Service - Service 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"); // Clinic Name DropDownList2.DataTextField = ds.Tables[3].Columns["Name"].ToString(); DropDownList2.DataValueField = ds.Tables[3].Columns["ID"].ToString(); DropDownList2.DataSource = ds.Tables[3]; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "Any"); // city DropDownList4.DataTextField = ds.Tables[4].Columns["Name"].ToString(); DropDownList4.DataValueField = ds.Tables[4].Columns["ID"].ToString(); DropDownList4.DataSource = ds.Tables[4]; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, "Any"); } }