Dropdownlist in gridview

[bawalekar]

How can i add dropdownlist box in gridview.......such that after selecting perticular item from dropdownlist box it get updated in database......using edititemtemplate field......

[kenobewan]

Welcome to the site. Please provide more information and describe your problem clearly. Thanks.

[gomzi]

thats easy man!
just add the dropdown box in an itemtemplate inside a templatefield.

then in vb,
in gridview rowcommand,
get the value of the selected dropdown box by,
ctype(me.gridview.rows(the number of the selected row in gridview).findcontrol("yourdropdownbox"),dropdownl ist).selectedvalue

[bawalekar]

thats easy man!
just add the dropdown box in an itemtemplate inside a templatefield.

then in vb,
in gridview rowcommand,
get the value of the selected dropdown box by,
ctype(me.gridview.rows(the number of the selected row in gridview).findcontrol("yourdropdownbox"),dropdownl ist).selectedvalue

Thanks for helping me...But i still have an problem that, how i can get the number of selected row in gridview .....I tried using Gridview.editIndex property but it give me negative index ..........
Actually what i have to do is after clicking edit button in gridview i have to add record of dropdownlist and textbox which i used in <asp:template field> in database......After clicking update button the record of both field should get added in database according to their id, which was already in gridveiw.....

To Make clear.... I have follwing filleds.
ID DROPDOWN TEXTBOX edit
.
,
Id was generated using select comman of gridview ,,but dropdown list is added using templatefield.........therefor i have to update rec of dropdown and txtbox after clicking edit button..

[gomzi]

Thanks for helping me...But i still have an problem that, how i can get the number of selected row in gridview .....I tried using Gridview.editIndex property but it give me negative index ..........
Actually what i have to do is after clicking edit button in gridview i have to add record of dropdownlist and textbox which i used in <asp:template field> in database......After clicking update button the record of both field should get added in database according to their id, which was already in gridveiw.....

To Make clear.... I have follwing filleds.
ID DROPDOWN TEXTBOX edit
.
,
Id was generated using select comman of gridview ,,but dropdown list is added using templatefield.........therefor i have to update rec of dropdown and txtbox after clicking edit button..

Not able to get you 100%. but i guess that you are having problems in finding the row number.
I understand that you are retrieving an id column through your select command,
so in the edit button use the "commandname" property to specify the id and then retrieve the id in the gridview rowcommand through e.commandname

then after you retrieve the id, run a loop to get the row number.

[bawalekar]

Not able to get you 100%. but i guess that you are having problems in finding the row number.
I understand that you are retrieving an id column through your select command,
so in the edit button use the "commandname" property to specify the id and then retrieve the id in the gridview rowcommand through e.commandname

then after you retrieve the id, run a loop to get the row number.

Thanxs Gomzi,
i find the solution using ur previous post.....i added select cmd butoon in gridview(it is added using gridview enable selection property true), then onselectchanged method i retrieve the id, dropdownlist selected item and textbox text....... i have taken button which will save this 3 filds in database using store proc.... but the problem is i have to first select item from dropdown list box then i have to click select button then i have to click on save button .

What i have to do is after selecting select button i have to retrieve all 3 fields then after save btton click i have to save into database...

[gomzi]

Thanxs Gomzi,
i find the solution using ur previous post.....i added select cmd butoon in gridview(it is added using gridview enable selection property true), then onselectchanged method i retrieve the id, dropdownlist selected item and textbox text....... i have taken button which will save this 3 filds in database using store proc.... but the problem is i have to first select item from dropdown list box then i have to click select button then i have to click on save button .

What i have to do is after selecting select button i have to retrieve all 3 fields then after save btton click i have to save into database...

Looking at the functionality that you want to achieve, i think that there is no need for you to add a select command button.

just place the dropdownlist and textbox in the templatefields and use a linkbutton (placed in a templatefield) for saving.(<asp:linkbuton commandname='<%# DataBinder.Eval(Container.DataItem,"Id") %>' > ...place the other necessary attributes)

now, when this linkbutton is clicked,your rowcommand will be called, in which you can get the dropdownlist and textbox's value through the method that i specified two posts back.

[bawalekar]

Looking at the functionality that you want to achieve, i think that there is no need for you to add a select command button.

just place the dropdownlist and textbox in the templatefields and use a linkbutton (placed in a templatefield) for saving.(<asp:linkbuton commandname='<%# DataBinder.Eval(Container.DataItem,"Id") %>' > ...place the other necessary attributes)

now, when this linkbutton is clicked,your rowcommand will be called, in which you can get the dropdownlist and textbox's value through the method that i specified two posts back.

Can u please tell me how can I retrieve Id in gridview of rowcommand ...
I didn't get of your preivious post of geting id of row using e.commandname.....
Declration of code will helpul to me.

[gomzi]

Can u please tell me how can I retrieve Id in gridview of rowcommand ...
I didn't get of your preivious post of geting id of row using e.commandname.....
Declration of code will helpul to me.

hm..... this should clear your doubts....

(add the necessary attributes)

<gridview>
<columns>
<asp:templatefield>
<itemtemplate>
PLACE THE TEXTBOX AND DROPDOWN HERE OR SEPARATELY USING ANOTHER TEMPLATE FIELD
</itemtemplate>
</asp:templatefield>
<asp:templatefield>
<itemtemplate>
<asp:linkbutton id="submit" runat="server" commandname='<%# DataBinder.Eval(Container.DataItem("YOUR ID COLUMN NAME"))%>'>
</itemtemplate>
</asp:templatefield>
</columns>
</gridview>

now in the code behind,
in gridview_rowcommand,

retrieve the value of id using,

dim selectedid as integer = 0
selectedid = e.commandname

then use the selected id as the need may b.

[bawalekar]

Tankuuuu very much Gomzi..........it reallly help me lot.

[bawalekar]

Tankuuuu very much Gomzi..........it reallly help me lot.

I Still have an problem in getting number of selected row in row command.....
I m using ur previos code in my row command event....see below.

in gridview rowcommand,
get the value of the selected dropdown box by,
ctype(me.gridview.rows(the number of the selected row in gridview).findcontrol("yourdropdownbox"),dropdownlist).sel ectedvalue


In above how can i get the number of the selected row of grid view ..?