ASP.NET Tutorial/XML/XmlDataDocument — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 18:30, 26 мая 2010
Changing DataSets using the DOM APIs from XmlDataDocument (C#)
<source lang="csharp">
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> File: Default.aspx.cs using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Xml; public partial class _Default : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { string connStr = "database=Northwind;Data Source=.\\SQLEXPRESS;User id=Tom;pwd=password"; using (SqlConnection conn = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand("select * from customers", conn); conn.Open(); DataSet ds = new DataSet(); ds.DataSetName = "Customers"; ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "Customer"); XmlDataDocument doc = new XmlDataDocument(ds); doc.DataSet.EnforceConstraints = false; XmlNode node = doc.SelectSingleNode(@"//Customer[CustomerID = "ANATR"]/ContactTitle"); node.InnerText = "Boss"; doc.DataSet.EnforceConstraints = true; DataRow dr = doc.GetRowFromElement((XmlElement)node.ParentNode); Response.Write(dr["ContactName"].ToString() + " is the "); Response.Write(dr["ContactTitle"].ToString()); } }
}</source>
Changing DataSets using the DOM APIs from XmlDataDocument (VB)
<source lang="csharp">
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> File: Default.aspx.vb Imports System.Data Imports System.Data.SqlClient Imports System.Xml Partial Class _Default
Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) _ Handles Me.Load Dim connStr As String = "database=Northwind;Data Source=.\SQLEXPRESS; " _ & "User id=Tom;pwd=password" Using conn As New SqlConnection(connStr) Dim command As New SqlCommand("select * from customers", conn) conn.Open() Dim ds As New DataSet() ds.DataSetName = "Customers" ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "Customer") Dim doc As New XmlDataDocument(ds) doc.DataSet.EnforceConstraints = False Dim node As XmlNode = _ doc.SelectSingleNode("//Customer[CustomerID = "ANATR"]/ContactTitle") node.InnerText = "Boss" doc.DataSet.EnforceConstraints = True Dim dr As DataRow = doc.GetRowFromElement(CType(node.ParentNode, XmlElement)) Response.Write(dr("ContactName").ToString() & " is the ") Response.Write(dr("ContactTitle").ToString()) End Using End Sub
End Class</source>