How to I hide and show GridView rows in Javascript

The answer lies in the following:

1. Keep the list of IDs 
2. Pass the list of IDs into the method/controller/factory that makes the call to SQL Server. By passing the list of IDs to the data tier, you allow paging to occur without including the list of ids.
    

You can pass say a pipe delimited string containing the ids into a stored proc which converts the ids into a table via a function and thus filters out the data in the resultset SQL-side.

This will handle the paging issue.

What is needed is to remove the row without actually removing the underlying data. I suppose when a row is removed, a rebinding occurs because of pagination. If this is the case, then the solution to the paging issue also solves how rows are removed or added back to the GridView.

Below is a working example against the AdventureWorks database which comes as a sample with SQL Server 2005.

1. The function ufnGetTableFromIDList created inside the Adventure Works provides the filtering. 
2. The entity class provides a business-object centric approach 
3. The factory class allows for consumption by the ObjectDataSource control. If you use LINQ-to-SQL classes in .NET 3.5, your code becomes considerably less and easier to maintain. I have elected to use .NET 2.0-esque  code without resorting to any ORM Framework that might muddy the example. The SQL statement uses server-side paging, a fact that will not go unnoticed when your records number in the thousands or hundreds of thousands.
    
4. Notice the ContactObjectDataSource_Selecting  method which is where the filters are injected and bubbled all the way up to SQL Server. 

SQL Function To Handle Filters:

create function ufnGetTableFromIDList(@list varchar(max))
returns @table table
(
   Id int primary key not null
)
as
begin
   declare @data varchar(max), @index int;
   set @data = @list;
   while len(@data) > 0
   begin
       set @index = charindex('|',@data);
       if @index = 0
       begin
           insert @table
           select convert(int,@data)

           set @data = '';
       end
       else
       begin
           insert @table
           select convert(int,left(@data,@index - 1))

           set @data = substring(@data, @index + 1, len(@data) - @index)
       end


       

   end
   return;
end

Entity Class

using System;

namespace ExpertsExchange.Q23594780
{
   [Serializable]
   public class Contact
   {
       private int _id;

       public int Id
       {
           get { return _id; }
           set { _id = value; }
       }

       private string _firstName;

       public string FirstName
       {
           get { return _firstName; }
           set { _firstName = value; }
       }


       private string _lastName;

       public string LastName
       {
           get { return _lastName; }
           set { _lastName = value; }
       }

       private string _email;

       public string Email
       {
           get { return _email; }
           set { _email = value; }
       }
   }
}

Factory Class

using System;
using System.ComponentModel;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Diagnostics;

namespace ExpertsExchange.Q23594780
{
   [DataObject]
   public class ContactFactory
   {
       private const string SELECT_COMMAND = @"select * from
       (
           select
           row_number() over(order by a.LastName, a.FirstName) as RowNumber,
           a.ContactID,
           a.FirstName,
           a.LastName,
           a.EmailAddress
       from
           (
               select
                    *
                from
                    Person.Contact
                where
                    ContactID not in (select Id from dbo.ufnGetTableFromIDList(@filters))
           ) a
       ) b
       where
           b.RowNumber between @startRowIndex + 1 and (@startRowIndex + @maximumRows)";

       private const string COUNT_COMMAND = @"select count(*) from Person.Contact where ContactID not in (select Id from dbo.ufnGetTableFromIDList(@filters))";


       private SqlConnection GetConnection()
       {
           return new SqlConnection("Data Source=.;Initial Catalog=AdventureWorks;Trusted_Connection=Yes;");
       }

       public int GetContactsCount(string filters)
       {
           try
           {
               using (SqlConnection connection = GetConnection())
               {
                   try
                   {
                       connection.Open();
                       using (SqlCommand command = new SqlCommand(COUNT_COMMAND, connection))
                       {
                           command.Parameters.AddWithValue("@filters", filters);
                           int count = (int)command.ExecuteScalar();
                           return count;
                       }
                   }
                   catch
                   {
                       throw;
                   }
                   finally
                   {
                       connection.Close();
                   }


               }
           }
           catch (Exception ex)
           {
               Trace.WriteLine(ex.Message);
               return 0;
           }

       }

       [DataObjectMethod(DataObjectMethodType.Select,true)]
       public List<Contact> GetContacts(string filters, int startRowIndex, int maximumRows)
       {  
            try
           {
               using (SqlConnection connection = GetConnection())
               {
                   try
                   {
                       connection.Open();
                       using (SqlCommand command = new SqlCommand(SELECT_COMMAND,connection))
                       {
                           List<Contact> list = new List<Contact>();

                           command.Parameters.AddWithValue("@startRowIndex", startRowIndex);
                           command.Parameters.AddWithValue("@maximumRows", maximumRows);
                           command.Parameters.AddWithValue("@filters", filters);
                           using (SqlDataReader reader = command.ExecuteReader())
                           {
                               while (reader.Read())
                               {
                                   Contact item = new Contact();
                                   item.Id = (int)reader["ContactID"];
                                   item.FirstName = (string)reader["FirstName"];
                                   item.LastName = (string)reader["LastName"];
                                   item.Email = (string)reader["EmailAddress"];
                                   list.Add(item);

                               }
                               reader.Close();
                           }
                           return list;

                       }
                   }
                   catch
                   {
                       throw;
                   }
                   finally
                   {
                       connection.Close();
                   }

               }

           }
           catch (Exception ex)
           {
               Trace.WriteLine(ex.Message);
               return new List<Contact>();
           }
       }
       
   }
}

ASPX File

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ExpertsExchange.Q23594780.Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
   <title>Q23594780</title>
</head>
<body>
   <form id="form1" runat="server">
   <div>
       <asp:GridView ID="ContactGridView" runat="server"
            DataSourceID="ContactObjectDataSource" AllowPaging="True" DataKeyNames="Id,FirstName,LastName,Email"
           AutoGenerateColumns="False">
           <Columns>
               <asp:TemplateField>
               <ItemTemplate>
               <asp:Button ID="RemoveButton" runat="server" OnClick="RemoveButton_Click" Text="Remove"/>
               </ItemTemplate>
               </asp:TemplateField>
               <asp:BoundField DataField="FirstName" HeaderText="First Name" />
               <asp:BoundField DataField="LastName" HeaderText="Last Name" />
               <asp:TemplateField HeaderText="Email">
               <ItemTemplate>
               <a href='<%# Eval("Email","mailto:{0}") %>'><%# Eval("Email") %></a>
               </ItemTemplate>
               </asp:TemplateField>
           </Columns>
       </asp:GridView>
   </div>
   <div>
   <asp:ListBox ID="SelectedFiltersListBox" runat="server" Width="500px">
   
   </asp:ListBox>
   <asp:Button ID="RemoveFilterItemButton" runat="server" Text="Remove Filter" OnClick="RemoveFilterItemButton_Click" />
   </div>
   <asp:ObjectDataSource ID="ContactObjectDataSource" runat="server"
        TypeName="ExpertsExchange.Q23594780.ContactFactory"
        OldValuesParameterFormatString="{0}" SelectMethod="GetContacts"
        EnablePaging="True" SelectCountMethod="GetContactsCount"
        onselecting="ContactObjectDataSource_Selecting">
       <SelectParameters>
           <asp:Parameter Name="filters" Type="String" />
       </SelectParameters>
   </asp:ObjectDataSource>
   </form>
</body>
</html>

Code-Behind

using System;
using System.Collections;
using System.Collections.Generic;
using System.Web.UI.WebControls;

namespace ExpertsExchange.Q23594780
{
   public partial class Default : System.Web.UI.Page
   {
       protected void Page_Load(object sender, EventArgs e)
       {

       }

       protected void RemoveButton_Click(object sender, EventArgs e)
       {
           GridViewRow row = (GridViewRow)((Button)sender).NamingContainer;
           DataKey key = ContactGridView.DataKeys[row.RowIndex];
           string text = string.Format("{0}, {1} ({2})", key["LastName"], key["FirstName"], key["Email"]);
           string value = key["Id"].ToString();
           this.SelectedFiltersListBox.Items.Add(new ListItem(text,value));
           this.ContactGridView.DataBind();
       }

       protected void ContactObjectDataSource_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
       {
           List<string> list = new List<string>();
           foreach (ListItem item in this.SelectedFiltersListBox.Items)
           {
               list.Add(item.Value);
           }
           string filters = string.Join("|", list.ToArray());
           e.InputParameters[0] = filters;

       }

       protected void RemoveFilterItemButton_Click(object sender, EventArgs e)
       {
           if (this.SelectedFiltersListBox.SelectedIndex != -1)
           {
               this.SelectedFiltersListBox.Items.RemoveAt(this.SelectedFiltersListBox.SelectedIndex);
               this.ContactGridView.DataBind();
           }
       }
   }
}