How to Bind DropDownList in GridView in asp.NET

Question

Hi all How to Bind DropDownList in GridView in asp.NET ?

Shalini Juneja · Answer

Thanks Rohatash

Rohatash Kumar · Answer

Eddie This code Can be helpful. create table info ( username varchar ( 50 ) Email varchar ( 40 ) ) go insert into info values ( 'andrew'  'andrew.@gmail.com' ) go insert into info values ( 'Rahul'  'rahul10.@gmail.com' ) go insert into info values ( 'Rohatash'  'rohatash.mca@gmail.com' ) go insert into info values ( 'yardi'  'yardi@gmail.com' ) go select * from info ; ASPX code div > asp : GridView ID =GridView1 runat =server CellPadding =4 ForeColor =#333333 GridLines =None> AlternatingRowStyle BackColor =White /> EditRowStyle BackColor =#2461BF /> FooterStyle BackColor =#507CD1 Font-Bold =True ForeColor =White /> HeaderStyle BackColor =#507CD1 Font-Bold =True ForeColor =White /> PagerStyle BackColor =#2461BF ForeColor =White HorizontalAlign =Center /> RowStyle BackColor =#EFF3FB /> SelectedRowStyle BackColor =#D1DDF1 Font-Bold =True ForeColor =#333333 /> SortedAscendingCellStyle BackColor =#F5F7FB /> SortedAscendingHeaderStyle BackColor =#6D95E1 /> SortedDescendingCellStyle BackColor =#E9EBEF /> SortedDescendingHeaderStyle BackColor =#4870BE /> asp : GridView > br /> br /> asp : DropDownList ID =DropDownList1 runat =server> asp : ListItem > rohatash asp : ListItem > asp : ListItem > andrew asp : ListItem > asp : ListItem > yardi asp : ListItem > asp : ListItem > Rahul asp : ListItem > asp : ListItem > monu asp : ListItem > asp : DropDownList >     asp : Label ID =Label1 runat =server Text =Label> asp : Label >      br /> br /> br /> asp : Button ID =Button1 runat =server onclick =Button1_Click Text =ShowRecord Height =37px /> div > Now double click on the Button Control and add the following code. Protected Sub Button1_Click( ByVal sender As Object  ByVal e As EventArgs ) Handles Button1.Click Dim str As String = Data Source=.;uid=sa;pwd=Password$2;database=dropdowndatabase Dim con As New SqlConnection (str) con.Open() Dim cmd As New SqlCommand ( select * from info where username = ' + DropDownList1.SelectedItem.Text + '  con) 'Dim cmd As New SqlCommand(select * from info) Dim Adpt As New SqlDataAdapter (cmd) Dim ds As DataSet = New DataSet () If (Adpt.Fill(ds info )) Then GridView1.DataSource = ds.Tables(0) GridView1.DataBind() Label1.Text = Found GridView1.Visible = True Else Label1.Text = Not found GridView1.Visible = False End If End Sub