读取XML文件

最新推荐文章于 2024-07-25 22:13:14 发布

l1981z

最新推荐文章于 2024-07-25 22:13:14 发布

阅读量340

点赞数

文章标签： xml dataset server microsoft datagrid generator

本文链接：https://blog.csdn.net/l1981z/article/details/3739421

版权

ReadXMLbyDOM.aspx
<%@ Page language="c#" Codebehind="ReadXMLbyDOM.aspx.cs" AutoEventWireup="false" Inherits="XMLexample._4.ReadXMLbyDOM" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
  <title>ReadXMLbyDOM</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <meta name="CODE_LANGUAGE" Content="C#">
  <meta name="vs_defaultClientScript" content="JavaScript">
  <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
  <form id="Form1" method="post" runat="server">
   <FONT face="宋体">
    <asp:ListBox id="XMLNodeListBox" style="Z-INDEX: 101; LEFT: 56px; POSITION: absolute; TOP: 80px"
     runat="server" Width="136px" Height="144px"></asp:ListBox>
    <asp:datagrid id="dgGeRen" style="Z-INDEX: 104; LEFT: 240px; POSITION: absolute; TOP: 48px" runat="server"></asp:datagrid>
    <asp:Button id="LoadXMLButton" style="Z-INDEX: 102; LEFT: 64px; POSITION: absolute; TOP: 232px"
     runat="server" Text="显示节点内容"></asp:Button>
    <asp:Label id="Label1" style="Z-INDEX: 103; LEFT: 48px; POSITION: absolute; TOP: 48px" runat="server">使用DOM访问XML文档</asp:Label>
    <asp:Label id="Label2" style="Z-INDEX: 105; LEFT: 280px; POSITION: absolute; TOP: 256px" runat="server">Label</asp:Label></FONT>
  </form>
</body>
</HTML>

ReadXMLbyDOM.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml;
using System.Data.SqlClient;
namespace XMLexample._4
{
/// <summary>
/// ReadXMLbyDOM 的摘要说明。
/// </summary>
public class ReadXMLbyDOM : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.ListBox XMLNodeListBox;
  protected System.Web.UI.WebControls.Label Label1;
  protected System.Web.UI.WebControls.DataGrid dgGeRen;
  protected System.Web.UI.WebControls.Label Label2;
  protected System.Web.UI.WebControls.Button LoadXMLButton;

  private void Page_Load(object sender, System.EventArgs e)
  {
   XmlDocument doc = new XmlDocument();
   doc.Load( Server.MapPath("people.xml") );
   XmlNode root = doc.DocumentElement;

   SqlConnection con = new SqlConnection(root.ChildNodes[0].FirstChild.Value);
   con.Open();
   string sql="select * from users";
   SqlDataAdapter ada = new SqlDataAdapter(sql,con);
   DataSet ds = new DataSet();
   ada.Fill(ds,"users");
   dgGeRen.DataSource=ds.Tables["users"].DefaultView;
   dgGeRen.DataBind();
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }

  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.LoadXMLButton.Click += new System.EventHandler(this.LoadXMLButton_Click);
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion

  private void LoadXMLButton_Click(object sender, System.EventArgs e)
  {
   // 创建XmlDocument类的实例
   XmlDocument doc = new XmlDocument();
   ArrayList NodeValues = new ArrayList();
   // 把people.xml文件读入内存，形成一个DOM结构
   doc.Load( Server.MapPath("people.xml") );
   XmlNode root = doc.DocumentElement;
   foreach( XmlNode personElement in root.ChildNodes )
    NodeValues.Add(personElement.FirstChild.Value);

   XMLNodeListBox.DataSource = NodeValues;
   XMLNodeListBox.DataBind();

Label2.Text = root.ChildNodes[0].FirstChild.Value;

}
}
}

l1981z

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
读取XML文件

ReadXMLbyDOM.aspx ReadXMLbyDOM http://schemas.microsoft.com/intellisense/ie5"> runat="server" Width="136px" Height="144px"> runat="server" Text="显示节点内容"> 使用DOM访问
复制链接

扫一扫