ASP.Net/XML/XML DataGrid — различия между версиями

Материал из .Net Framework эксперт
Перейти к: навигация, поиск
м (1 версия)
 
(нет различий)

Версия 18:30, 26 мая 2010

Bind data in XML to asp:DataGrid

   <source lang="csharp">

<%@ Page language="c#" %> <%@ Import namespace="System.Data" %> <%@ Import namespace="System.Xml" %> <script language="c#" runat="server"> 

 void Page_Load()
 {

// string xmlFilename = @"C:\artists.xml"; 

   string xmlFilename = MapPath("AdRotatorBasic.xml");
   DataSet newDataSet = new DataSet(); 
   newDataSet.ReadXml(xmlFilename);
   DataGrid1.DataSource = newDataSet;
   DataGrid1.DataBind();
 }

</script> <html> 

 <head>
   <title>Data Grid Control example</title>
 </head>
 <body>
   <asp:DataGrid id="DataGrid1" runat="server"  />
 </body>

</html> 

      </source>


Bind XML file to DataSet and bind to asp datagrid

   <source lang="csharp">

<%@ Import namespace="System.Data" %> <html> 

 <head>
   <title>Read XML file</title>
 </head>
 <body>

Read XML file

     <asp:Label id="lblXMLFileName" runat="server" />


     <asp:DataGrid id="dgServers" runat="server" />
 </body>

</html> <script language="VB" runat="server"> Sub Page_Load(Source As Object, E As EventArgs) 

 Dim strXMLFile As String = MapPath("Multiple_levels.XML")
 lblXMLFileName.Text = strXMLFile
 Dim objDataSet As New DataSet()
 objDataSet.ReadXml(strXMLFile)
 dgServers.DataSource = objDataSet.Tables(0).DefaultView
 dgServers.DataBind()

End Sub </script> <%-- <?xml version="1.0" standalone="yes"?> <CarList> 

 <Car>
   <ModelName>A</ModelName>
   <Doors>2</Doors>
   <ColorList>
     <Color>Color 2</Color>
     <Color>Color 3</Color>
     <Color>Color 4</Color>
   </ColorList>
 </Car>
 <Car>
   <ModelName>Model 2</ModelName>
   <Doors>3</Doors>
   <ColorList>
     <Color>Red</Color>
     <Color>Yellow</Color>
     <Color>Blue</Color>
   </ColorList>
 </Car>

</CarList> --%> 

      </source>


DataSet read XML data and bind to asp datagrid

   <source lang="csharp">

<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script language="VB" runat="server"> 

 Sub Page_Load(Sender As Object, E As EventArgs)
   Dim objDataSet    As New DataSet()
   objDataSet.ReadXml(Server.MapPath("NewEmployees.xml"))
   
   dgEmployees.DataSource = objDataSet.Tables(0).DefaultView
   dgEmployees.DataBind()
   
 End Sub

</script> <html> 

 <body>
 <asp:DataGrid id="dgEmployees" runat="server" />
 </body>

</html>

<%--NewEmployees.xml <?xml version="1.0"?> <employees> 

 <employee id="1">    
     <firstName>Nancy</firstName>
     <lastName>Lee</lastName> 
   <city>Seattle</city>
   <state>WA</state>
   <zipCode>98122</zipCode>   
 </employee>
 <employee id="2">    
     <firstName>Jason</firstName>
     <lastName>Wang</lastName>
   <city>Vancouver</city>
   <state>WA</state>
   <zipCode>98123</zipCode>   
 </employee>

</employees> --%> 


      </source>


Load XML to asp:DataGrid

   <source lang="csharp">

<%@ Page language="VB" runat="server" %> <%@ Import namespace="System.Data" %> <%@ Import namespace="System.XML" %> <script language="vb" runat="server"> 

 Sub Page_Load()
   Dim xmlFilename As String 
   xmlFilename= "artists.xml"
   Dim newDataSet As New DataSet
   newDataSet.ReadXML(xmlFilename)
   DataGrid1.DataSource = newDataSet
   DataGrid1.DataBind()
 End Sub

</script> <html> 

 <head>
   <title>Data Grid Control example</title>
 </head>
 <body>
   <asp:DataGrid id="DataGrid1" runat="server"  />
 </body>

</html>

<%-- <?xml version="1.0"?> <artist> 

 <item>
   <name>Vincent Van Gogh</name>
   <nationality>Dutch</nationality>
   <movement>Post Impressionism </movement>
   <birthdate>30th March 1853</birthdate>
 </item>
 <item>
   <name>Paul Klee </name>
   <nationality>Swiss </nationality>
   <movement>Abstract Expressionism </movement>
   <birthdate>18th December 1879</birthdate>
 </item>
 <item>
   <name>Max Ernst </name>
   <nationality>German </nationality>
   <movement>Surrealism </movement>
   <birthdate>2nd April 1891</birthdate>
 </item>

</artist>

--%> 

      </source>


Read xml data and bind to datagrid in C#

   <source lang="csharp">

<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script Language="c#" runat="server"> 

 void Page_Load(object sender, EventArgs e)
 {
   DataSet objDataSet = new DataSet();
   objDataSet.ReadXml(Server.MapPath("NewEmployees.xml"));
   dgEmployees.DataSource = objDataSet.Tables[0].DefaultView;
   dgEmployees.DataBind();
 }

</script> <html> 

 <body>
 <asp:DataGrid id="dgEmployees" runat="server" />
 </body>

</html> <%--NewEmployees.xml <?xml version="1.0"?> <employees> 

 <employee id="1">    
     <firstName>Nancy</firstName>
     <lastName>Lee</lastName> 
   <city>Seattle</city>
   <state>WA</state>
   <zipCode>98122</zipCode>   
 </employee>
 <employee id="2">    
     <firstName>Jason</firstName>
     <lastName>Wang</lastName>
   <city>Vancouver</city>
   <state>WA</state>
   <zipCode>98123</zipCode>   
 </employee>

</employees> --%> 

      </source>
Источник — «http://nfex.ru/index.php?title=ASP.Net/XML/XML_DataGrid&oldid=1858»