How to insert one value hard coded, while remaining values will come from database in drop down list of ASP.NET?

Question

1.00/5 (2 votes)

See more:

I want to use drop down list in my code (Asp.net). I want to make first value as hard coded ("Select City" in my case) while remaining values will come from database. How i can do that. Mean first values will be hard coded, while remaining will be dynamic .

What I have tried:

<asp:DropDownList ID="ddlGender" runat="server" Width="200px">
<asp:ListItem Text="Select City" >

Posted 19-Mar-17 7:17am

Hassaan_Malik

Updated 19-Mar-17 8:01am

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)

Karthik_Mahalingam · Accepted Answer · 2017-03-19T08:01:00

Solution 1

try like this

var itemsFromDb = getData();
for (int i = 0; i < itemsFromDb.Length; i++)
    ddlGender.Items.Add(itemsFromDb[i]);

Posted 19-Mar-17 8:01am

Karthik_Mahalingam

Comments

Hassaan_Malik 19-Mar-17 14:05pm

Then where would be my hard coded value , like "Select Country" because in you solution my whole values will come from database. isn't it??

Karthik_Mahalingam 19-Mar-17 14:09pm

yes, along with "Select country", all the values from db also will be appended to the list.

mark up be like

<asp:DropDownList ID="ddlGender" runat="server" Width="200px">
<asp:ListItem Text="Select City" >

Hassaan_Malik 19-Mar-17 14:10pm

Really extremely sorry. I am beginner to asp.net. Can you provide with sample code, if you have. I will be highly thankful to you?Because i am not getting the point.

Karthik_Mahalingam 19-Mar-17 14:15pm

     protected void Page_Load(object sender, EventArgs e)
            {
                if (!Page.IsPostBack) { 
                var itemsFromDb = getGenderData();
                ddlGender.Items.Add("Select Gender");
                for (int i = 0; i < itemsFromDb.Length; i++)
                    ddlGender.Items.Add(itemsFromDb[i]);}
         

            }

            public string[] getGenderData()
            {
                return new string[] { "Male", "Female", "Transgender" };
            }

 <asp:DropDownList ID="ddlGender" runat="server" Width="200px">             
        </asp:DropDownList>

Hassaan_Malik 19-Mar-17 14:18pm

Thanks a lot. Its really helpful. Thanks for your cooperation.

Karthik_Mahalingam 19-Mar-17 14:21pm

welcome :)