ASP.Net/XML/DataGrid Edit

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

asp:DataGrid for XML data edit

<%@ 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>
  <table>
   <tr>
    <td valign="top"><asp:DataGrid id="dgEmployees1" runat="server" /></td>
    <td valign="top"><asp:DataGrid id="dgEmployees2" runat="server" /></td>
   </tr>
  </table>
 </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>
--%>