ASP.NET

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 />
}

if (CountGroup == 6)<br />
            {<br />
                Repeater getGroupRepeater = (Repeater)sender;<br />
                <br />
                foreach (RepeaterItem rptItem in getGroupRepeater.Controls)<br />
                {<br />
                    foreach (Control ctrl in rptItem.Controls)<br />
                    {<br />
                        if (ctrl is Panel)<br />
                        {<br />
                            Panel panelGlobalContainerBox = (Panel)ctrl;<br />
<br />
                            if (countItemdataBound)<br />
                            {<br />
                                panelGlobalContainerBox.CssClass = "content_left";<br />
                                //panelGlobalContainerBox.BackColor = System.Drawing.Color.Red;<br />
                                countItemdataBound = false;<br />
                            }<br />
                            else<br />
                            {<br />
                                panelGlobalContainerBox.CssClass = "content_right";<br />
                                //panelGlobalContainerBox.BackColor = System.Drawing.Color.Green;<br />
                                countItemdataBound = true;<br />
                            }<br />
                        }<br />
                    }<br />
                }<br />
            }<br />