从dropdownlist的xml绑定过滤数据时出错 [英] error in filtering data from xml binding of dropdownlist

问题描述

<stat>
  <state>
    <stateid>102</stateid>
    <statename>ajmer</statename>
  </state>
  <state>
    <stateid>102</stateid>
    <statename>kota</statename>
  </state>
  <state>
    <stateid>103</stateid>
    <statename>sikar</statename>
  </state>
  <state>
    <stateid>103</stateid>
    <statename>Bikaner</statename>
  </state>
</stat>

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
  {
      string st = (DropDownList1.SelectedItem.Value).ToString();

      XDocument main = XDocument.Load(Server.MapPath(@"~\XMLFile.xml"));


      var query = from user in main.Descendants("state")
                  where st == user.Element("stateid").Value
                  select user;

      DropDownList2.DataSource = query;
      DropDownList2.DataTextField = "statename";
      DropDownList2.DataBind();
  }

我的结果在下拉列表就像这样简单而不过滤

my result is coming like this in dropdown as simple its not filtering

<state><stateid>102</stateid><statename>ajmer</statename></state>

<state><stateid>102</stateid><statename>kota</statename></state>

我要展示简单的ajmer和kota in dropdown

and i want to show simple ajmer and kota in dropdown

推荐答案

请将你的LINQ查询转移到下面

Please chanege your LINQ query as below

var query = from user in main.Descendants("state")
                       where st == user.Element("stateid").Value
                       select user.Element("statename").Value;

它将起作用

it will work

这篇关于从dropdownlist的xml绑定过滤数据时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！