gridview with dropdownlist when autogenerate column property id true

Question

1.00/5 (1 vote)

See more:

sir, i have a gridview with the property of autogenerate column true. i want to bind each column with dropdownlist.

My code is like :-

VB

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles Gridview1.RowDataBound

 

     Dim dl As New DropDownList()
     cmd1.CommandText = "Select * from ClassRoom order by ClassRoom"
     Dim dr2 = cmd1.ExecuteReader
     dl.DataSource = dr2
     dl.AppendDataBoundItems = True
     dl.DataTextField = "ClassRoom"
     dl.DataValueField = "ClassRoom"
     dl.DataBind()
     dl.SelectedItem.Text = ""
     dr2.Close()


        
             For Each row As GridViewRow In Gridview1.Rows
                 row.Cells(2).Controls.Add(dl)
                 row.Cells(3).Controls.Add(dl)
             Next
        


 End Sub

this code add dropdownlist only cell(3) not in cell(2) how can i add dropdownlist in both cell.

Posted 11-Dec-14 21:23pm

TCS54321

Updated 12-Dec-14 20:13pm

v7

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-12-13T00:27:00

Shortly: you need to create new DropDownList for each column (cell). ;)

VB

For Each row As GridViewRow In Gridview1.Rows
    For i = 1 to 2
        Dim dl As New DropDownList()
        cmd1.CommandText = "Select * from ClassRoom order by ClassRoom"
        Dim dr2 = cmd1.ExecuteReader
        dl.DataSource = dr2
        dl.AppendDataBoundItems = True
        dl.DataTextField = "ClassRoom"
        dl.DataValueField = "ClassRoom"
        dl.DataBind()
        dl.SelectedItem.Text = ""
        dr2.Close()
        row.Cells(i).Controls.Add(dl)
    Next i
Next

See similar question: Re: GridView DropDownList programmatically add items on RowDataBound[^]

I really do recommend to create DropDownList and set its properties on design time: Walkthrough: Displaying a Drop-Down List While Editing in the GridView Web Server Control[^]