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();
}
