ASP.NET

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

  protected virtual void RepeaterGroup_ItemdataBound(object sender, RepeaterItemEventArgs e)<br />
        {<br />
            MuMSkillGroup group = (MuMSkillGroup)e.Item.DataItem;<br />
            SkillGroupControl currentGoup = (SkillGroupControl)e.Item.FindControl("Skillgroup");<br />
            currentGoup.CurrentGroupName = group.SkillGroupName;<br />
            currentGoup.IsMatrix = false;<br />
            currentGoup.BindAsMyskillpage = true;<br />
}