bound drop down in Templatefield at edit time

Question

0.00/5 (No votes)

See more:

I have gridview with Edit,cancel, delete

there is col of leave type in gridview it shows leave type (eg)
1)sick
2)causal
3)Annual etc)

It shows 1 either of them.
when user click on "Edit" button I want to show the drop down which
should be bound with db(sqlserver)
How to do that ???

as we usually bound drop down in asp.net same thing need to be done
My Code

XML

<asp:TemplateField HeaderText="LeaveType">
                     <EditItemTemplate>
                        <asp:DropDownList ID="gvddlleavestype" runat="server" Width="150px"></asp:DropDownList>
                     </EditItemTemplate>
                     <ItemTemplate>
                         <asp:Label ID="Label5" runat="server" Text='<%# Bind("LeaveType") %>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>

waiting

Posted 3-Apr-10 0:15am

qasimidl

Add a Solution

3 solutions

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)

Ankur^\m/ · Accepted Answer · 2010-04-03T01:48:00

Solution 3

Lalit Kumar wrote:
Bind dropdownlist at row_bound method of gridview

I thought you said:

qasimidl wrote:
when user click on "Edit" button I want to show the drop down

You can do this programmatically as well.
You need to handle RowEditing event of the GridView to bind the DropDownList.

Posted 3-Apr-10 1:48am

Ankur^\m/

Ankur^\m/ · Accepted Answer · 2010-04-03T00:35:00

Solution 1

<asp:DropDownList id="gvddlleavestype" runat="server" width="150px" selectedvalue='<%# Bind("LeaveType") >' ></asp:DropDownList>

Posted 3-Apr-10 0:35am

Ankur^\m/

Updated 5-Apr-10 3:20am

v6

Lalit Kumar 5733 · Accepted Answer · 2010-04-03T01:19:00

Solution 2

Bind dropdownlist at row_bound method of gridview.

check this URL. it have your solution
Editable GridView in ASP.NET 2.0[^]

Posted 3-Apr-10 1:19am

Lalit Kumar 5733

Updated 3-Apr-10 1:24am

v2