ASP.NET Tutorial/XML/XmlDataDocument

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>