Live Chat Icon For mobile
Live Chat Icon

ASP.NET FAQ

Find answers for the most frequently asked questions
Expand All Collapse All

products.xml


<?xml version='1.0' standalone='yes'?>
<NewDataSet>
  <Product>
    <ProductID  pcode='P2'>2</ProductID>
    <ProductName>Chang</ProductName>
    <SupplierID>1</SupplierID>
    <CategoryID>1</CategoryID>
    <QuantityPerUnit>24 - 12 oz bottles</QuantityPerUnit>
  </Product>
  <Product>
    <ProductID  pcode='P4'>3</ProductID>
    <ProductName>Aniseed Syrup</ProductName>
    <SupplierID>1</SupplierID>
    <CategoryID>2</CategoryID>
    <QuantityPerUnit>12 - 550 ml bottles</QuantityPerUnit>
  </Product>
</NewDataSet>

Use Namespace System.Xml
VB.NET


<asp:DataGrid id='DataGrid1' AutoGenerateColumns='False' runat='server'>
<Columns>
	<asp:TemplateColumn HeaderText='ProductCode'>
	<ItemTemplate>
		<%#CType(Container.DataItem, System.Xml.XmlNode).Attributes('pcode').value%>
	</ItemTemplate>
	</asp:TemplateColumn>
</Columns>
</asp:DataGrid>

dim xmldoc as XmlDocument = new XmlDocument()
xmldoc.Load(Server.MapPath('products.xml'))
dim xmlnodes  as XmlNodeList = xmldoc.SelectNodes('NewDataSet/Product/ProductID')
DataGrid1.DataSource = xmlnodes
DataGrid1.DataBind ()

C#


<asp:DataGrid id='DataGrid1' AutoGenerateColumns='False'  runat='server'>
<Columns>
	<asp:TemplateColumn HeaderText ='ProductCode'>
	<ItemTemplate>
		<%# ((System.Xml.XmlNode)Container.DataItem).Attributes['pcode'].Value %>
	</ItemTemplate>
	</asp:TemplateColumn>
</Columns>
</asp:DataGrid>

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(Server.MapPath('products.xml'));
XmlNodeList xmlnodes = xmldoc.SelectNodes('NewDataSet/Product/ProductID');
DataGrid1.DataSource = xmlnodes;
DataGrid1.DataBind ();
Permalink

VB.NET


Dim xmlText As String = 'Node1Node2'
Dim xmlDoc As New XmlDocument
xmlDoc.LoadXml(xmlText)
Dim writer As XmlTextWriter = New XmlTextWriter(Server.MapPath('data.xml'), Nothing)
writer.Formatting = Formatting.Indented
xmlDoc.Save(writer)

C#


string xmlText = 'Node1Node2';
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xmlText);
XmlTextWriter writer = new XmlTextWriter(Server.MapPath('data.xml'),null);
writer.Formatting = Formatting.Indented;
xmlDoc.Save(writer);
Permalink

Use namespace System.IO

VB.NET


dim ds as new DataSet()
dim fs as FileStream = new FileStream (Server.MapPath ('products.xml'),FileMode.Open , FileAccess.Read )
ds.ReadXml (fs)
DataGrid1.DataSource = ds
DataGrid1.DataBind ()

C#


DataSet ds= new DataSet ();
FileStream fs = new FileStream (Server.MapPath ('products.xml'),FileMode.Open , FileAccess.Read );
ds.ReadXml (fs);
DataGrid1.DataSource = ds;
DataGrid1.DataBind ();
Permalink

Share with

Share on twitter
Share on facebook
Share on linkedin

Couldn't find the FAQs you're looking for?

Please submit your question and answer.