Mega Code Archive

 

Categories / ASP.Net Tutorial / XML

 

Changing DataSets using the DOM APIs from XmlDataDocument (C#)

<%@ 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());         }     } }