forum

Home / DeveloperSection / Forums / Binding Gridview Problem

Binding Gridview Problem

Anonymous User 1503 29-Sep-2014

I have a problem when when while loop repeats it iteration the already binded is replacing by new records but i want to bind all data by the iteration of while loop. 

I am a new I have no idea how it can be. 

while (i >= 0)
{
    if (i != 0)
    {
        group_idd = group_ids[--i];
    }                  
    SqlConnection connection3 = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection_String"].ConnectionString);
    using (connection3)
    {
        using (SqlCommand cmdd = new SqlCommand())
        {
            cmdd.CommandText = "SELECT [news_category],[id] FROM [news_profile] WHERE [user_id]='" + user_id + "' AND [group_id]='" + group_idd + "' AND [profile_id] IS NOT NULL";
            cmdd.Connection = connection3;
            connection3.Open();
            GridView1.DataSource = cmdd.ExecuteReader();
            GridView1.DataBind();
            connection3.Close();                           
        }
    }
    if (i == 0)
    {
    --i;
    }
}


Updated on 29-Sep-2014
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By