private void Loadstate() { DataTable dt = new DataTable(); API.Service web = new API.Service(); XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml("<XML>" + web.get_state(Session["Email"].ToString(), Session["P@ss"].ToString(), "").InnerXml + "</XML>"); XmlNodeList xResponse = xDoc.SelectNodes("XML/RESPONSE/STATE_NO "); dt.Columns.Add("STATE_CODE", typeof(string)); dt.Columns.Add("STATE_ID", typeof(string)); string sVar = ""; string sUS = ""; foreach (XmlNode node in xResponse) { DataRow dr = dt.NewRow(); if (node["COUNTRY_ID"].InnerText == "2") { sVar = "United States"; } if (node["COUNTRY_ID"].InnerText == "1") { sVar = "Canada"; } dr["STATE_CODE"] = node["STATE_NAME"].InnerText + " / " + sVar; dr["STATE_ID"] = node["STATE_ID"].InnerText; dt.Rows.Add(dr); } ddlprivince.DataSource = dt; ddlprivince.DataTextField = "STATE_CODE"; ddlprivince.DataValueField = "STATE_CODE"; ddlprivince.DataBind(); ddlprivince.Items.Insert(0, new ListItem("--Select one--", "0")); }