Insert Delete record in ASP.Net ListView using XML File in C# and VB.Net

Hi nauna,

Refer below sample.

HTML

<asp:ListView ID="ListView1" runat="server" OnItemCommand="ListView1_ItemCommand">
    <ItemTemplate>
        <div class="pickup">
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <br />
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            <br />
            <asp:LinkButton ID="LinkButton2" runat="server" CommandName="Remove">Remove</asp:LinkButton><br />
        </div>
    </ItemTemplate>
</asp:ListView>
<asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick="ButtonAdd_Click" />
<asp:Button ID="Button1" Text="Save" runat="server" OnClick="Button1_Click" />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true">
</asp:GridView>

XML

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <Customer>
    <Column1>1</Column1>
    <Column2>2</Column2>
  </Customer>
</NewDataSet>

Namespaces

C#

using System.Data;

VB.Net

Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        SetInitialRow();
    }
}

private void SetInitialRow()
{
    DataSet ds = new DataSet();
    ds.ReadXml(Server.MapPath("XMLFile.xml"));
    DataTable dt = ds.Tables[0];
    ViewState["CurrentTable"] = dt;
    ListView1.DataSource = dt;
    ListView1.DataBind();
}

protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e)
{
    int rowID;
    if (e.Item.DataItemIndex == ListView1.Items.Count - 1)
    {
        rowID = ListView1.Items[e.Item.DataItemIndex].DataItemIndex;
    }
    else
    {
        rowID = ListView1.Items[e.Item.DataItemIndex + 1].DataItemIndex;
    }
    if (ViewState["CurrentTable"] != null)
    {
        DataTable dt = (DataTable)ViewState["CurrentTable"];
        if (dt.Rows.Count > 1)
        {
            if (ListView1.SelectedIndex < dt.Rows.Count - 1)
            {
                dt.Rows.Remove(dt.Rows[rowID]);
            }
        }
        ViewState["CurrentTable"] = dt;
        ListView1.DataSource = dt;
        ListView1.DataBind();
        DataSet ds = new DataSet();
        ds.Tables.Add(dt);
        ds.WriteXml(Server.MapPath("XMLFile.xml"));
    }

    SetPreviousData();
}

private void AddNewRow()
{
    int rowIndex = 0;
    if (ViewState["CurrentTable"] != null)
    {
        DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
        DataRow drCurrentRow = null;
        if (dtCurrentTable.Rows.Count > 0)
        {
            for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
            {
                TextBox box1 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox1");
                TextBox box2 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox2");
                drCurrentRow = dtCurrentTable.NewRow();
                drCurrentRow["Column1"] = box1.Text;
                drCurrentRow["Column2"] = box2.Text;
                rowIndex++;
            }
            dtCurrentTable.Rows.Add(drCurrentRow);
            ViewState["CurrentTable"] = dtCurrentTable;

            ListView1.DataSource = dtCurrentTable;
            ListView1.DataBind();
            DataSet ds = new DataSet();
            ds.Tables.Add(dtCurrentTable);
            ds.WriteXml(Server.MapPath("XMLFile.xml"));

        }
    }
    else
    {
        Response.Write("ViewState is null");
    }
    SetPreviousData();
}

private void SetPreviousData()
{
    int rowIndex = 0;
    if (ViewState["CurrentTable"] != null)
    {
        DataTable dt = (DataTable)ViewState["CurrentTable"];
        if (dt.Rows.Count > 0)
        {
            for (int i = 1; i < dt.Rows.Count; i++)
            {
                TextBox box1 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox1");
                TextBox box2 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox2");
                box1.Text = dt.Rows[i]["Column1"].ToString();
                box2.Text = dt.Rows[i]["Column2"].ToString();
                rowIndex++;
            }
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

protected void ButtonAdd_Click(object sender, EventArgs e)
{
    AddNewRow();
}
protected void Button1_Click(object sender, EventArgs e)
{
    string message = "";
    int rowIndex = 0;
    if (ViewState["CurrentTable"] != null)
    {
        DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
        if (dtCurrentTable.Rows.Count > 0)
        {
            for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
            {
                TextBox box1 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox1");
                TextBox box2 = (TextBox)ListView1.Items[rowIndex].FindControl("TextBox2");
                rowIndex++;
                message += box1.Text + "," + box2.Text + "\\n\\r";
            }
            Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('" + message + "');", true);
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Page.IsPostBack Then
        SetInitialRow()
    End If
End Sub

Private Sub SetInitialRow()
    Dim ds As DataSet = New DataSet()
    ds.ReadXml(Server.MapPath("XMLFile.xml"))
    Dim dt As DataTable = ds.Tables(0)
    ViewState("CurrentTable") = dt
    ListView1.DataSource = dt
    ListView1.DataBind()
End Sub

Protected Sub ListView1_ItemCommand(ByVal sender As Object, ByVal e As ListViewCommandEventArgs)
    Dim rowID As Integer

    If e.Item.DataItemIndex = ListView1.Items.Count - 1 Then
        rowID = ListView1.Items(e.Item.DataItemIndex).DataItemIndex
    Else
        rowID = ListView1.Items(e.Item.DataItemIndex + 1).DataItemIndex
    End If

    If ViewState("CurrentTable") IsNot Nothing Then
        Dim dt As DataTable = CType(ViewState("CurrentTable"), DataTable)
        If dt.Rows.Count > 1 Then
            If ListView1.SelectedIndex < dt.Rows.Count - 1 Then
                dt.Rows.Remove(dt.Rows(rowID))
            End If
        End If
        ViewState("CurrentTable") = dt
        ListView1.DataSource = dt
        ListView1.DataBind()
        Dim ds As DataSet = New DataSet()
        ds.Tables.Add(dt)
        ds.WriteXml(Server.MapPath("XMLFile.xml"))
    End If

    SetPreviousData()
End Sub

Private Sub AddNewRow()
    Dim rowIndex As Integer = 0

    If ViewState("CurrentTable") IsNot Nothing Then
        Dim dtCurrentTable As DataTable = CType(ViewState("CurrentTable"), DataTable)
        Dim drCurrentRow As DataRow = Nothing
        If dtCurrentTable.Rows.Count > 0 Then
            For i As Integer = 1 To dtCurrentTable.Rows.Count
                Dim box1 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox1"), TextBox)
                Dim box2 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox2"), TextBox)
                drCurrentRow = dtCurrentTable.NewRow()
                drCurrentRow("Column1") = box1.Text
                drCurrentRow("Column2") = box2.Text
                rowIndex += 1
            Next
            dtCurrentTable.Rows.Add(drCurrentRow)
            ViewState("CurrentTable") = dtCurrentTable
            ListView1.DataSource = dtCurrentTable
            ListView1.DataBind()
            Dim ds As DataSet = New DataSet()
            ds.Tables.Add(dtCurrentTable)
            ds.WriteXml(Server.MapPath("XMLFile.xml"))
        End If
    Else
        Response.Write("ViewState is null")
    End If

    SetPreviousData()
End Sub

Private Sub SetPreviousData()
    Dim rowIndex As Integer = 0
    If ViewState("CurrentTable") IsNot Nothing Then
        Dim dt As DataTable = CType(ViewState("CurrentTable"), DataTable)
        If dt.Rows.Count > 0 Then
            For i As Integer = 1 To dt.Rows.Count - 1
                Dim box1 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox1"), TextBox)
                Dim box2 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox2"), TextBox)
                box1.Text = dt.Rows(i)("Column1").ToString()
                box2.Text = dt.Rows(i)("Column2").ToString()
                rowIndex += 1
            Next
        End If

        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub

Protected Sub ButtonAdd_Click(ByVal sender As Object, ByVal e As EventArgs)
    AddNewRow()
End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim message As String = ""
    Dim rowIndex As Integer = 0

    If ViewState("CurrentTable") IsNot Nothing Then
        Dim dtCurrentTable As DataTable = CType(ViewState("CurrentTable"), DataTable)
        If dtCurrentTable.Rows.Count > 0 Then
            For i As Integer = 1 To dtCurrentTable.Rows.Count
                Dim box1 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox1"), TextBox)
                Dim box2 As TextBox = CType(ListView1.Items(rowIndex).FindControl("TextBox2"), TextBox)
                rowIndex += 1
                message += box1.Text & "," + box2.Text & "\n\r"
            Next

            Page.ClientScript.RegisterClientScriptBlock(GetType(Page), "Script", "alert('" & message & "');", True)
        End If
    End If
End Sub

Screenshot