private void Loadjoblocation() { DataTable dt = new DataTable(); API.Service web = new API.Service(); XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml("<XML>" + web.get_job_location("", Session["ClientID"].ToString(), "", "", "", "", "", "", Session["Email"].ToString(), Session["P@ss"].ToString()).InnerXml + "</XML>"); XmlNodeList xResponse = xDoc.SelectNodes("XML/RESPONSE/JOB_LOCATIONS"); dt.Columns.Add("ADDRESS1", typeof(string)); dt.Columns.Add("JOB_LOCATION_ID", typeof(string)); foreach (XmlNode node in xResponse) { DataRow dr = dt.NewRow(); dr["ADDRESS1"] = node["ADDRESS1"].InnerText; dr["JOB_LOCATION_ID"] = node["JOB_LOCATION_ID"].InnerText; dt.Rows.Add(dr); } ddllocation.DataSource = dt; ddllocation.DataTextField = "ADDRESS1"; ddllocation.DataValueField = "JOB_LOCATION_ID"; ddllocation.DataBind(); }