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