Hide all ASP.Net GridView rows on Edit except Edited Row while paging using C# and VB.Net

Hi landomarossi,

Please refer below sample.

Note: For this sample i have used temporary DataTable. For more details refer How to create Temporary Table in ASP.Net using C# and VB.Net.

HTML

<asp:GridView ID="gvCountries" runat="server" AutoGenerateColumns="false" AllowPaging="true" PageSize="2"
    OnPageIndexChanging="PageIndexChanging" OnRowEditing="gvCountries_RowEditing"
    OnDataBound="gvCountries_DataBound" OnRowCommand="gvCountries_RowCommand">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="true" />
        <asp:TemplateField HeaderText="Country">
            <ItemTemplate>
                <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtCountry" runat="server" TextMode="SingleLine"
                    Text='<%# Eval("Country") %>'></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="lnkEdit" Text="Edit" runat="server" CommandName="Edit"
                    CommandArgument='<%# Container.DataItemIndex %>' />
            </ItemTemplate>
            <EditItemTemplate>
                <asp:LinkButton Text="Update" runat="server" OnClick="OnUpdate" />
                <asp:LinkButton Text="Cancel" runat="server" OnClick="OnCancel" />
            </EditItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespace

C#

using System.Data;

VB.Net

Imports System.Data

Code

C#

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

private void BindGrid()
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Id"), new DataColumn("Country") });
    dt.Rows.Add(1, "India");
    dt.Rows.Add(2, "United States");
    dt.Rows.Add(3, "France");
    dt.Rows.Add(4, "Russia");

    this.gvCountries.DataSource = dt;
    this.gvCountries.DataBind();
}

protected void OnUpdate(object sender, EventArgs e)
{
    gvCountries.EditIndex = -1;
    this.BindGrid();
}

protected void OnCancel(object sender, EventArgs e)
{
    gvCountries.EditIndex = -1;
    this.BindGrid();
}

protected void gvCountries_RowEditing(object sender, GridViewEditEventArgs e)
{
    gvCountries.EditIndex = e.NewEditIndex;

    this.BindGrid();
}

private bool IsEditRow = false;
private int CurrentEditRowindex = -1;

protected void gvCountries_DataBound(object sender, EventArgs e)
{
    if (IsEditRow && CurrentEditRowindex > -1)
    {
        for (int i = 0; i < gvCountries.Rows.Count; i++)
        {
            if (i != CurrentEditRowindex)
            {
                this.gvCountries.Rows[i].Visible = false;
            }
        }
    }
}

protected void gvCountries_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "Edit")
    {
        IsEditRow = true;
        CurrentEditRowindex = Convert.ToInt32(e.CommandArgument) % gvCountries.PageSize;

    }
    else
    {
        IsEditRow = false;
        CurrentEditRowindex = -1;
    }
}

protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    gvCountries.PageIndex = e.NewPageIndex;
    this.BindGrid();
}

VB.Net

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

Private Sub BindGrid()
    Dim dt As DataTable = New DataTable()
    dt.Columns.AddRange(New DataColumn(1) {New DataColumn("Id"), New DataColumn("Country")})
    dt.Rows.Add(1, "India")
    dt.Rows.Add(2, "United States")
    dt.Rows.Add(3, "France")
    dt.Rows.Add(4, "Russia")
    Me.gvCountries.DataSource = dt
    Me.gvCountries.DataBind()
End Sub

Protected Sub OnUpdate(ByVal sender As Object, ByVal e As EventArgs)
    gvCountries.EditIndex = -1
    Me.BindGrid()
End Sub

Protected Sub OnCancel(ByVal sender As Object, ByVal e As EventArgs)
    gvCountries.EditIndex = -1
    Me.BindGrid()
End Sub

Protected Sub gvCountries_RowEditing(ByVal sender As Object, ByVal e As GridViewEditEventArgs)
    gvCountries.EditIndex = e.NewEditIndex
    Me.BindGrid()
End Sub

Private IsEditRow As Boolean = False
Private CurrentEditRowindex As Integer = -1

Protected Sub gvCountries_DataBound(ByVal sender As Object, ByVal e As EventArgs)
    If IsEditRow AndAlso CurrentEditRowindex > -1 Then

        For i As Integer = 0 To gvCountries.Rows.Count - 1

            If i <> CurrentEditRowindex Then
                Me.gvCountries.Rows(i).Visible = False
            End If
        Next
    End If
End Sub

Protected Sub gvCountries_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
    If e.CommandName = "Edit" Then
        IsEditRow = True
        CurrentEditRowindex = Convert.ToInt32(e.CommandArgument) Mod gvCountries.PageSize
    Else
        IsEditRow = False
        CurrentEditRowindex = -1
    End If
End Sub

Protected Sub PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
    gvCountries.PageIndex = e.NewPageIndex
    Me.BindGrid()
End Sub

Screenshot