How to display a value in drop down list from database using repeater?

Question

0.00/5 (No votes)

See more:

Hi guys,

I am new to this field so please help me out.

I want to display value from database table to asp.net controls lik textbox etc.... Using repeater i am displaying all values in controls .Now i want to display a value as selected value in dropdownlist . What to do?

Please help me guys......

Posted 22-Mar-11 17:08pm

sajna m nair

Add a Solution

2 solutions

Solution 1

1) Handle the DataBinding event

2) Dropdown list's Items collection has methods like FindByValue,FindByText methods. Using that you can get the ListItem from the dropdownlist.

3) Set the ListItem's Selected property to True

Posted 22-Mar-11 17:18pm

Albin Abel

Comments

sajna m nair 24-Mar-11 1:40am

Thankx for your reply.I understood wht you said but,can you please show me this with an example code.

sajna m nair 24-Mar-11 1:44am

Actually this is a code for updating. so i want to display the existing value in the database and along with that the other option for changing data also

Albin Abel 24-Mar-11 2:34am

Usually we won't provide coding, you need to try. May be I can give you a simple example coding. I am busy right now, will give you that by the end of the day

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)

Mahendra.p25 · Accepted Answer · 2011-03-22T19:01:00

Hi,

try this

XML

<asp:Repeater ID="Rep" runat="server" OnItemDataBound="rep_ItemDataBound">
                               <ItemTemplate>
                                   <table width="100%">
                                       <tr>
                                           <td valign="top" width="13%" align="left">
                                               <asp:DropDownList ID="Dropdown1" runat="server" Width="80px">
                                               </asp:DropDownList>
                                       </tr>
                               </ItemTemplate>
                               <FooterTemplate>
                                   </table>
                               </FooterTemplate>
                           </asp:Repeater>


//in the code behind section

in the repDataBound Event find that drop down and bind it
               
                    DropDownList myDD = (DropDownList)e.Item.FindControl("Dropdown1");
                    myDD.DataTextField = "Name";
                    myDD.DataValueField = "Id";
                    myDD.DataBind();