private void Loaddepartment() { DataTable dt = new DataTable(); //string sTable = "<tbody>"; API.Service web = new API.Service(); XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml("<XML>" + web.get_department(Session["Email"].ToString(), Session["P@ss"].ToString(), "", Session["ClientID"].ToString()).InnerXml + "</XML>"); XmlNodeList iResponse = xDoc.SelectNodes("XML/RESPONSE/DEPARTMENT_ID"); dt.Columns.Add("DEPARTMENT_NAME", typeof(string)); dt.Columns.Add("DEPARTMENT_ID", typeof(string)); foreach (XmlNode node in iResponse) { DataRow dr = dt.NewRow(); dr["DEPARTMENT_NAME"] = node["DEPARTMENT_NAME"].InnerText; dr["DEPARTMENT_ID"] = node["DEPARTMENT_ID"].InnerText; dt.Rows.Add(dr); } ddldepartment.DataSource = dt; ddldepartment.DataTextField = "DEPARTMENT_NAME"; ddldepartment.DataValueField = "DEPARTMENT_ID"; ddldepartment.DataBind(); }