http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FXML%2FDataSet
ASP.NET Tutorial/XML/DataSet - История изменений
2026-04-29T23:10:21Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/XML/DataSet&diff=2951&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.NET_Tutorial/XML/DataSet&diff=2952&oldid=prev
Admin: 1 версия
2010-05-26T11:57:33Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== DataSet to XML==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="DataSetToXml" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:Xml ID="XmlControl" runat="server"></asp:Xml><br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
using System.Xml;<br />
using System.Web.Configuration;<br />
public partial class DataSetToXml : System.Web.UI.Page<br />
{<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
string connectionString = WebConfigurationManager.ConnectionStrings["Pubs"].ConnectionString;<br />
string SQL = "SELECT * FROM authors WHERE city="Oakland"";<br />
SqlConnection con = new SqlConnection(connectionString);<br />
SqlCommand cmd = new SqlCommand(SQL, con);<br />
SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
DataSet ds = new DataSet("AuthorsDataSet");<br />
con.Open();<br />
adapter.Fill(ds, "AuthorsTable");<br />
con.Close();<br />
XmlDataDocument dataDoc = new XmlDataDocument(ds);<br />
XmlControl.Document = dataDoc;<br />
XmlControl.TransformSource = "authors.xslt";<br />
}<br />
}<br />
File: Web.config<br />
<?xml version="1.0"?><br />
<configuration xmlns="http://schemas.microsoft.ru/.NetConfiguration/v2.0"><br />
<appSettings/><br />
<connectionStrings><br />
<add name="Pubs" connectionString="Data Source=localhost;Initial Catalog=pubs;Integrated Security=SSPI"/><br />
</connectionStrings><br />
<system.web><br />
<compilation debug="true"/><br />
<authentication mode="Windows"/><br />
</system.web><br />
</configuration><br />
File: authors.xslt<br />
<?xml version="1.0" encoding="UTF-8" ?><br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
version="1.0"><br />
<xsl:template match="AuthorsDataSet"><br />
<h1>The Author List</h1><br />
<br />
<xsl:apply-templates select="AuthorsTable"/><br />
<br />
<i>Created through XML and XSLT</i><br />
</xsl:template><br />
<xsl:template match="AuthorsTable"><br />
<b>Name: </b><xsl:value-of select="au_lname"/>, <xsl:value-of select="au_fname"/><br />
<br/><br />
<b>Phone: </b> <xsl:value-of select="phone"/><br />
</xsl:template><br />
</xsl:stylesheet></source><br />
<br />
<br />
<br />
== Read XML file and feed into DataSet==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Import namespace="System.Data" %><br />
<html><br />
<head><br />
<title>Read XML file</title><br />
</head><br />
<body><br />
<H2>Read XML file</H2><br />
<asp:Label id="lblXMLFileName" runat="server" /><BR/><BR/><br />
<asp:DataGrid id="dgServers" runat="server" /><br />
</body><br />
</html><br />
<script language="VB" runat="server"><br />
Sub Page_Load(Source As Object, E As EventArgs)<br />
Dim strXMLFile As String = Server.MapPath("Data.xml")<br />
lblXMLFileName.Text = strXMLFile<br />
Dim objDataSet As New DataSet()<br />
objDataSet.ReadXml(strXMLFile)<br />
dgServers.DataSource = objDataSet.Tables(0).DefaultView<br />
dgServers.DataBind()<br />
End Sub<br />
</script><br />
File: ~\Data.xml<br />
<?xml version="1.0" standalone="yes"?><br />
<CarList><br />
<Car><br />
<ModelName>A</ModelName><br />
<Doors>2</Doors><br />
<ColorList><br />
<Color>A</Color><br />
<Color>B</Color><br />
<Color>C</Color><br />
</ColorList><br />
</Car><br />
<Car><br />
<ModelName>B</ModelName><br />
<Doors>3</Doors><br />
<ColorList><br />
<Color>D</Color><br />
<Color>E</Color><br />
<Color>F</Color><br />
</ColorList><br />
</Car><br />
</CarList></source></div>
Admin