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