private void Loadvendor() { DataTable dt = new DataTable(); XmlDocument xDoc = new XmlDocument(); API.Service web = new API.Service(); xDoc.LoadXml("<XML>" + web.get_vendor(Session["ClientID"].ToString(), Session["Email"].ToString(), Session["P@ss"].ToString()).InnerXml + "</XML>"); XmlNodeList iResponse = xDoc.SelectNodes("XML/RESPONSE/VENDOR_ID"); dt.Columns.Add("VENDOR_NAME", typeof(string)); dt.Columns.Add("VENDOR_ID", typeof(string)); foreach (XmlNode node in iResponse) { DataRow dr = dt.NewRow(); dr["VENDOR_NAME"] = node["VENDOR_NAME"].InnerText; dr["VENDOR_ID"] = node["VENDOR_ID"].InnerText; dt.Rows.Add(dr); } ddlvendor.DataSource = dt; ddlvendor.DataTextField = "vendor_name"; ddlvendor.DataValueField = "VENDOR_ID"; ddlvendor.DataBind(); // ddlvendor.Items.Insert(0, new ListItem("ALL VENDORS", "0")); //ddlvendor.Items.Insert(0, new ListItem("-- Select --", "0")); ddlvendor.Items.Insert(0, new ListItem("ALL VENDORS", "4")); }