ASP.Net/XML/DataGrid Edit

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

asp:DataGrid for XML data edit

   <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()
   " read in the XML file
   objDataSet.ReadXml(Server.MapPath("Employees.xml"))
   " show it in a grid    
   dgEmployees1.DataSource = objDataSet.Tables(0).DefaultView
   dgEmployees1.DataBind()
   " modify a row
   objDataSet.Tables("Employees").Rows(0).Item("FirstName") = "B"
   objDataSet.Tables("Employees").Rows(0).Item("LastName") = "D"
   " add a new row to the table
   Dim objTable  As DataTable
   Dim objNewRow As DataRow
 
   objTable = objDataSet.Tables("Employees")
   objNewRow = objTable.NewRow()
   objNewRow.Item("FirstName") = "A"
   objNewRow.Item("LastName") = "B"
   objTable.Rows.Add(objNewRow)
   " save it to a new file
   objDataSet.WriteXml(Server.MapPath("Employees2.xml"))
   
   " read in the new file
   Dim objDataSet2    As New DataSet()
   objDataSet2.ReadXml(Server.MapPath("Employees2.xml"))
   " show it in another grid
   dgEmployees2.DataSource = objDataSet2.Tables(0).DefaultView
   dgEmployees2.DataBind()
       
 End Sub

</script> <html> 

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

</html>

<%-- Employees.xml <?xml version="1.0" standalone="yes"?> <NewDataSet> 

 <Employees>
   <FirstName>Z</FirstName>
   <LastName>X</LastName>
 </Employees>
 <Employees>
   <FirstName>W</FirstName>
   <LastName>R</LastName>
 </Employees>

</NewDataSet> --%> 

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