Modify XML data set : XML DataSet « XML « ASP.Net

Modify XML data set

<%@ 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

    ' show it in a grid    
    dgEmployees1.DataSource = objDataSet.Tables(0).DefaultView

    ' modify a row
    objDataSet.Tables("employee").Rows(0).Item("firstName") = "Bob"
    objDataSet.Tables("employee").Rows(0).Item("lastName") = "Dylan"

    ' add a new row to the table
    Dim objTable  As DataTable
    Dim objNewRow As DataRow
    objTable = objDataSet.Tables("employee")
    objNewRow = objTable.NewRow()
    objNewRow.Item("firstName") = "Norman"
    objNewRow.Item("lastName") = "Blake"

    ' save it to a new file
    ' read in the new file
    Dim objDataSet2    As New DataSet()

    ' show it in another grid
    dgEmployees2.DataSource = objDataSet2.Tables(0).DefaultView

  End Sub


    <td valign="top"><asp:DataGrid id="dgEmployees1" runat="server" /></td>
    <td valign="top"><asp:DataGrid id="dgEmployees2" runat="server" /></td>

<?xml version='1.0'?>
  <employee id="1">    
  <employee id="2">    


Related examples in the same category

1.Display column information: dataset from xml file
2.Load xml data to DataSet
3.Load XML data into DataSet