ASP.NET

<asp:UpdatePanel ID="updatePanel" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:GridView ID="gvTasks" runat="server" OnRowCreated="gvTasks_RowCreated" DataSourceID="odsTaskList"
                GridLines="None" AutoGenerateColumns="false" CssClass="mGrid" PagerStyle-CssClass="pgr"
                AlternatingRowStyle-CssClass="alt" OnSelectedIndexChanged="GvTasks_SelectedIndexChanged"
                DataKeyNames="ID">
                <Columns>
                    <asp:TemplateField HeaderText="Content">
                    <ItemTemplate>
                         <asp:LinkButton ID="btnContent" runat="server" CommandName="Select" ><%# Eval("Content")%></asp:LinkButton>
                    </ItemTemplate>
                    </asp:TemplateField>
                   
                    <asp:TemplateField HeaderText="Enddate">
                    <ItemTemplate>
                         <asp:LinkButton ID="btnEnddate" runat="server" CommandName="Select" ><%# Eval("Enddate")%></asp:LinkButton>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:ImageButton ID="removeButton" runat="server" CommandArgument='<%# Eval( "id" ) %>'
                                OnCommand="removeButton_Click" ImageUrl="~/img/remove.gif" />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </ContentTemplate>
    </asp:UpdatePanel>

datatable.AsEnumerable().Where(datarow=>{ 
 // your logic 
});

if(condition)
    e.Row.Visible = false;

Kissy16 wrote:

If ((e.Row.Cells(2).Text = e.Row.Cells(2).Text) + 1) Then

// Create a dataset that represents the data you are retrieving from the database
DataSet myDataSet = new DataSet();
DataTable myDataTable = myDataTable.Tables.Add();
myDataTable.Columns.Add("ID", typeof(int));
myDataTable.Columns.Add("Foo", typeof(string));
myDataTable.Columns.Add("Bar", typeof(string));

// Execute your sql reader as normal
connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
    // instead of binding the reader, add the records you want to the dataset
    if (dr["myCriteria"].ToString() == "this")
    {
        myDataTable.Rows.Add(
            (int)dr["ID"],
             dr["Foo"].ToString(),
             dr["Bar"].ToString()
        );
    }
}
dr.Close();
connection.Close();

// Now bind the dataset you created to your GridView
myGridView.DataSource = myDataSet;
myGridView.BindData();

 ClientBasePlanData

ClientBasePlanList : List<ClientBasePlanData> 

create the object of ClientBasePlanData fill it and add it into  ClientBasePlanList 

and later bind it