Member Avatar for gahhon 
            {
                conOOC.Open();
                SqlCommand cmdDisplay = new SqlCommand("SELECT * FROM [Course] WHERE ([CourseID] = @id)", conOOC);
                cmdDisplay.Parameters.AddWithValue("@id", ddlCourseList.SelectedValue);
                SqlDataReader dtrDisplay = cmdDisplay.ExecuteReader();

                while (dtrDisplay.Read())
                {
                    GridView1.DataSource = dtrDisplay;
                    GridView1.DataBind();
                }

this one is depends on user select which items on the dropdownlist, once they have selected should display the gridview, but the girdview doesn't show anything :/

  • 3 Contributors
  • 3 Replies
  • 83 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by k.d.m
Member Avatar for JorgeM

Are you reloading the page after the databind?

Member Avatar for gahhon

yes, the the dropdownlist is enable autopostback. i got put if postback.

Member Avatar for k.d.m

Try to use datatable or dataset. Since you are using datareader it is readonly and forward way of reading one roe of data at a time.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.