关于从数据库读取xml然后输出

挨踢直男 2010-10-27 01:18:28

我在 sqlserver中读出来的数据生成了 xml
这个类型的

<markers>

  <community count="4" community_id="126" ID="126" community="高桥小区" Area_ID="1" Address="43-3-501" PinYin="gqxq" />

  <community count="1" community_id="127" ID="127" community="新惠明苑" Area_ID="1" Address="2-1-1002" PinYin="xhmy" />

  <community count="7" community_id="128" ID="128" community="育才东苑" Area_ID="1" Address="46-3-302" PinYin="ycdy" />

  <community count="2" community_id="129" ID="129" community="半岛花园" Area_ID="2" Address="26-202" PinYin="bdhy" />

  <community count="1" community_id="130" ID="130" community="半岛花园" Area_ID="2" Address="27-1-401" PinYin="bdhy" />

  <community count="1" community_id="131" ID="131" community="潘水南苑" Area_ID="1" Address="46-6-101" PinYin="psny" />

  <community count="2" community_id="132" ID="132" community="湖滨花园" Area_ID="2" Address="13-1-401" PinYin="hbhy" />

  <community count="2" community_id="133" ID="133" community="旺角城" Area_ID="2" Address="1-2-504" PinYin="wjc" />

  <community count="1" community_id="134" ID="134" community="旺角城" Area_ID="2" Address="2-1502" PinYin="wjc" />

  <community count="6" community_id="135" ID="135" community="绅园" Area_ID="2" Address="1-701" PinYin="sy" />

  <community count="2" community_id="136" ID="136" community="崇化小区" Area_ID="1" Address="崇化小区" PinYin="chxq" />

  <community count="1" community_id="137" ID="137" community="银通大厦" Area_ID="2" Address="金城路" PinYin="ytdx" />

  <community count="1" community_id="138" ID="138" community="建材厂" Area_ID="1" Address="萧西路" PinYin="jcc" />

  <community count="3" community_id="139" ID="139" community="泰富广场" Area_ID="1" Address="萧绍路" PinYin="tfgc" />

  <community count="1" community_id="141" ID="141" community="知稼苑" Area_ID="2" Address="金城路" PinYin="zjy" />

  <community count="2" community_id="142" ID="142" community="明辉花园" Area_ID="2" Address="通惠北路" PinYin="mhhy" />

  <community count="6" community_id="143" ID="143" community="育才西苑" Area_ID="1" Address="育才西苑" PinYin="ycxy" />

  <community count="1" community_id="144" ID="144" community="育才西苑" Area_ID="1" Address="育才西苑" PinYin="ycxy" />

  <community count="1" community_id="145" ID="145" community="发展公寓" Area_ID="1" Address="发展公寓" PinYin="fzgy" />

  <community count="1" community_id="147" ID="147" community="泰富广场" Area_ID="1" Address="泰富广场" PinYin="tfgc" />

  <community count="2" community_id="149" ID="149" community="洄澜北苑" Area_ID="1" Address="洄澜北苑" PinYin="hlby" />

  <community count="1" community_id="150" ID="150" community="北干一苑" Area_ID="1" Address="北干一苑" PinYin="bgy" />

  <community count="1" community_id="151" ID="151" community="白马公寓" Area_ID="2" Address="白马公寓" PinYin="bmgy" />

  <community count="2" community_id="152" ID="152" community="文源广场" Area_ID="1" Address="文源广场" PinYin="wygc" />

  <community count="1" community_id="153" ID="153" community="奥兰多小镇" Area_ID="2" Address="风情大道" PinYin="aldxz" />

  <community count="1" community_id="154" ID="154" community="文源广场" Area_ID="1" Address="文源广场" PinYin="wygc" />

  <community count="3" community_id="155" ID="155" community="洄澜南苑" Area_ID="1" Address="洄澜路北" PinYin="hlny" />

  <community count="1" community_id="156" ID="156" community="绿都玫瑰苑" Area_ID="1" Address="绿都玫瑰苑" PinYin="ldmgy" />

  <community count="4" community_id="157" ID="157" community="湖滨花园" Area_ID="2" Address="湖滨花园" PinYin="hbhy" />

  <community count="2" community_id="159" ID="159" community="湖畔宽邸" Area_ID="1" Address="杭州乐园里面" PinYin="hpkd" />

  <community count="1" community_id="160" ID="160" community="东阳桥" Area_ID="1" Address="文化路与育才路交错口" PinYin="dyq" />

  <community count="3" community_id="161" ID="161" community="同和公寓" Area_ID="1" Address="西山脚下" PinYin="thgy" />

  <community count="1" community_id="162" ID="162" community="里横河" Area_ID="1" Address="里横河" PinYin="lhh" />

  <community count="1" community_id="163" ID="163" community="合丰商务楼" Area_ID="1" Address="合丰商务楼" PinYin="hfswl" />

  <community count="1" community_id="164" ID="164" community="花园井" Area_ID="1" Address="花园井" PinYin="hyj" />

  <community count="1" community_id="165" ID="165" community="众安国泰" Area_ID="2" Address="众安国泰" PinYin="zagt" />

  <community count="1" community_id="166" ID="166" community="崇化小区   " Area_ID="1" Address="崇化小区  " PinYin="chxq" />

  <community count="1" community_id="167" ID="167" community="金城花园" Area_ID="1" Address="金城花园" PinYin="jchy" />

  <community count="1" community_id="168" ID="168" community="潘水小区" Area_ID="1" Address="潘水小区" PinYin="psxq" />

  <community count="1" community_id="169" ID="169" community="金马公寓" Area_ID="1" Address="金马公寓" PinYin="jmgy" />

  <community count="1" community_id="170" ID="170" community="金茂大厦" Area_ID="2" Address="金茂大厦" PinYin="jmdx" />

  <community count="1" community_id="171" ID="171" community="北干二苑" Area_ID="2" Address="北干二苑" PinYin="bgey" />

  <community count="2" community_id="172" ID="172" community="星河景庭" Area_ID="2" Address="星河景庭" PinYin="xhjt" />

  <community count="1" community_id="173" ID="173" community="明江苑" Area_ID="2" Address="明江苑" PinYin="mjy" />

  <community count="1" community_id="174" ID="174" community="众安服务楼" Area_ID="1" Address="众安服务楼" PinYin="zafwl" />

  <community count="2" community_id="175" ID="175" community="广德小区" Area_ID="2" Address="广德小区" PinYin="gdxq" />

  <community count="1" community_id="176" ID="176" community="万都经典" Area_ID="1" Address="万都经典" PinYin="wdjd" />

  <community count="1" community_id="177" ID="177" community="南市花园" Area_ID="1" Address="23-2-3-202" PinYin="nshy" />

  <community count="1" community_id="179" ID="179" community="洄谰南苑" Area_ID="1" Address="洄谰南苑" PinYin="hlny" />

  <community count="1" community_id="180" ID="180" community="泰和花园" Area_ID="1" Address="泰和花园" PinYin="thhy" />

  <community count="1" community_id="181" ID="181" community="名城大厦" Area_ID="2" Address="名城大厦" PinYin="mcdx" />

  <community count="1" community_id="182" ID="182" community="名城大厦" Area_ID="2" Address="名城大厦" PinYin="mcdx" />

  <community count="1" community_id="183" ID="183" community="明江花园" Area_ID="6" Address="明江花园" PinYin="mjhy" />

  <community count="1" community_id="184" ID="184" community="汇宇花园" Area_ID="1" Address="汇宇花园" PinYin="hyhy" />

  <community count="1" community_id="185" ID="185" community="汇宇花园" Area_ID="1" Address="汇宇花园" PinYin="hyhy" />

  <community count="1" community_id="186" ID="186" community="东方一品" Area_ID="2" Address="东方一品" PinYin="dfp" />

  <community count="1" community_id="187" ID="187" community="杭二棉厂西" Area_ID="1" Address="106-1-501" PinYin="hemcx" />

  <community count="1" community_id="188" ID="188" community="国泰大厦" Area_ID="2" Address="901" PinYin="gtdx" />

  <community count="1" community_id="190" ID="190" community="回澜南苑" Area_ID="1" Address="回澜路" PinYin="hlny" />

  <community count="1" community_id="191" ID="191" community="广和小区" Area_ID="1" Address="广和小区" PinYin="ghxq" />

  <community count="1" community_id="193" ID="193" community="嘉富广场" Area_ID="1" Address="嘉富广场" PinYin="jfgc" />

  <community count="1" community_id="194" ID="194" community="中譽万豪广场" Area_ID="1" Address="中譽万豪广场" PinYin="zywhgc" />

  <community count="1" community_id="195" ID="195" community="星云地带" Area_ID="2" Address="星云地带" PinYin="xydd" />

  <community count="1" community_id="196" ID="196" community="机电市场" Area_ID="1" Address="商业城附近" PinYin="jdsc" />

  <community count="1" community_id="197" ID="197" community="金域三江" Area_ID="12" Address="金域三江" PinYin="jysj" />

  <community count="1" community_id="198" ID="198" community="万都晶典" Area_ID="1" Address="万都晶典" PinYin="wdjd" />

  <community count="1" community_id="199" ID="199" community="景苑公寓" Area_ID="1" Address="景苑公寓" PinYin="jygy" />

  <community count="1" community_id="200" ID="200" community="东信来茵苑" Area_ID="2" Address="东信来茵苑" PinYin="dxlyy" />

  <community count="2" community_id="202" ID="202" community="汽配城" Area_ID="3" Address="通惠路" PinYin="qpc" />

  <community count="1" community_id="203" ID="203" community="得力新和人家" Area_ID="3" Address="新街" PinYin="dlxhrj" />

  <community count="1" community_id="204" ID="204" community="天辰国际" Area_ID="2" Address="建设1路" PinYin="tcgj" />

  <community count="1" community_id="205" ID="205" community="中誉现代城" Area_ID="1" Address="通惠中路" PinYin="zyxdc" />

  <community count="1" community_id="206" ID="206" community="绿都四季花城" Area_ID="1" Address="南环路" PinYin="ldsjhc" />

  <community count="1" community_id="207" ID="207" community="永通国贸广场" Area_ID="12" Address="钱清轻纺原料市场" PinYin="ytgmgc" />

  <community count="1" community_id="208" ID="208" community="新白马公寓" Area_ID="2" Address="新白马公寓" PinYin="xbmgy" />

  <community count="1" community_id="209" ID="209" community="金马名仕园" Area_ID="1" Address="金马名仕园" PinYin="jmmsy" />

  <community count="1" community_id="210" ID="210" community="高桥小区" Area_ID="1" Address="141-202" PinYin="gqxq" />

  <community count="1" community_id="211" ID="211" community="柠檬公寓" Area_ID="1" Address="柠檬公寓" PinYin="nmgy" />

  <community count="1" community_id="213" ID="213" community="滨湖世纪城" Area_ID="1" Address="合经区紫云路" PinYin="bhsjc" />

</markers>

现在我想用 ado.net 读取这些xml然后输出在页面上该如何做啊? 最好是用 dataset

...全文

379 16 打赏收藏转发到动态举报

写回复

用AI写文章

16 条回复

切换为时间正序

请发表友善的回复…

发表回复

孟子E章 2010-10-27

打赏
举报

说了半天你还没明白怎么做吗？下面是一个完整的例子，直接拷贝就能执行的

<%@ Page Language="C#" %>



<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<%@ Import Namespace="System.Xml" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<script runat="server">



  protected void Page_Load(object sender, EventArgs e)

  {

    SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=ArticleDev;User Id=sa;Password=sa;");

    cn.Open();

    SqlCommand cmd = new SqlCommand("SELECT * FROM Article FOR xml raw", cn);

    SqlDataReader dr = cmd.ExecuteReader();

    String strXml = "";

    if (dr.Read())

    {

      strXml = "<markers>"; //注意这里是不是要加根节点，看的返回的数据本身是否带根节点

      strXml += dr[0].ToString();

      strXml += "</markers>";

    }

    cn.Dispose();

    if (strXml != "")

    {

      XmlDataSource x = new XmlDataSource();

      x.ID = "xx";

      x.Data = strXml;

      this.form1.Controls.Add(x);

      GridView1.DataSourceID = "xx";

      GridView1.DataBind();

    }



  }

</script>



<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

  <title></title>.

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server">

  </asp:GridView>

  </form>

</body>

</html>

wuyq11 2010-10-27

打赏
举报

sql 直接查询XML
或
SqlCommand cmd=new SqlCommand(sql,conn);
conn.Open();
XmlTextReader objXmlReader = (XmlTextReader)cmd.ExecuteXmlReader();
DataSet ds = new DataSet();
ds.DataSetName = "XML";
ds.ReadXml(objXmlReader,XmlReadMode.Fragment);
ds.WriteXml(Server.MapPath("XML.xml"));
conn.Close();
LINQ TO XML 查询

dayou123123 2010-10-27

打赏
举报

你的 dataset



 

string aa  = dataset.GetXmlSchema();

this.TextBox1.Text = aa;

这样可以输出..

xq1981 2010-10-27

打赏
举报

用JS解析即可啊，不用浪费服务器资源

lchy110 2010-10-27

打赏
举报

你那不能叫XML类型应该是说比如有点像



public Ilist<实体类> getInfor()

{

    IList<实体类> list = new List<实体类>();

    //......查询数据库

     while(rd.read())

    {

       实体类 r = new 实体类();

       r.属性1=rd.GetInt32(0);

       r.属性2=rd.GetString(1);

       //....

       list.Add(r);

    }

    return list;

}

这数据取出来不就雷同你的类节点：然后都是类属性作为分支节点么

挨踢直男 2010-10-27

打赏
举报

也不用怎么样显示就直接输出就行了
跟输出一个字符串一样急急急急急啊

挨踢直男 2010-10-27

打赏
举报

我不想存成xml 就想直接在程序中输出

rart2008 2010-10-27

打赏
举报

帮顶！
这个问题我也想知道！！！

挨踢直男 2010-10-27

打赏
举报

[Quote=引用 7 楼 net_lover 的回复:]

我在 sqlserver中读出来的数据生成了 xml

你是已经读取出来了是吗？还是存成了xml文件？
[/Quote]

就是这样的 select * from tb for xml raw 执行查询的

生成的是一个xml 只是我不知道如何在程序中显示

孟子E章 2010-10-27

打赏
举报

我在 sqlserver中读出来的数据生成了 xml

你是已经读取出来了是吗？还是存成了xml文件？

挨踢直男 2010-10-27

打赏
举报

我只是想从直接在页面上输出 xml字符串难到查询时直接 for xml这样还不如直接查询数据通过程序构造 xml字符串了

没有方便的方法吗? 请高手们指教

lchy110 2010-10-27

打赏
举报

[Quote=引用 4 楼 claymore1114 的回复:]
C# code

XDocument doc = XDocument.Load("../../xml.xml");
foreach (var item in doc.Descendants("community"))
{
var count = item.Attribute("count").Value;
……
[/Quote]

就这个
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("../../xml.xml");
然后foreach 节点

claymore1114 2010-10-27

打赏
举报



 XDocument doc = XDocument.Load("../../xml.xml");

            foreach (var item in doc.Descendants("community"))

            {

                var count = item.Attribute("count").Value;

                var id = item.Attribute("ID").Value;

            }