how to insert value dropdownlist Item by function.

Question

0.00/5 (No votes)

See more:

Hi
I am shailendra singh. Can any one help me.

I want to add value on dropdownlist Item by function but I want show on top select key word in dropdownlist, by function.

My following Function.

C#

public void FillReportType()
    {
        con.Open();
        drpregtype.Items.Insert(0, new ListItem("--Select---", "----"));
        drpregtype.SelectedIndex = 0;
        da = new SqlDataAdapter("Select ResultType from tblresultType order by id ", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        drpregtype.DataSource = dt;
        drpregtype.DataValueField = "ResultType";
        //drpregtype.Items.Add.Add(new ListItem("--", "Select"));
        //drpregtype.Items.Insert(0, new ListItem("--Select---", "----"));
        //drpregtype.SelectedIndex = 0;
         drpregtype.DataBind();
        con.Close();
    }

Thanks for Advance.

Posted 10-Jan-12 20:46pm

shailendra from MP

Updated 10-Jan-12 20:47pm

RaisKazi

v2

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)

Manish.Insan · Answer 1 · 2012-01-10T21:15:00

Hello Shailendra,

just modifying your code :

C#

public void FillReportType()
    {
        con.Open();
       
        drpregtype.SelectedIndex = 0;
        da = new SqlDataAdapter("Select ResultType from tblresultType order by id ", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        drpregtype.DataSource = dt;
        drpregtype.DataValueField = "ResultType";
        //drpregtype.Items.Add.Add(new ListItem("--", "Select"));
        //drpregtype.Items.Insert(0, new ListItem("--Select---", "----"));
        //drpregtype.SelectedIndex = 0;
         drpregtype.DataBind();
        drpregtype.Items.Insert(0, new ListItem("--Select---", "0"));
        con.Close();
    }

Hope this will give you solution, that you want.
Don't forget to mark as answer if it helps. :)

michaelschmitt · Answer 2 · 2012-01-10T21:19:00

Hi,

you have two options:

1. Add the "Select" entry to your datasource (as first item) and then bind your dropdown to that datasource

or 2. Add your items manually to your dropdownlist without binding it to a datasource.

You cannot add an item and expect it to be shown und bind a datasource at the same time.

In addition to that you should get rid of the sql in your view.

Hope this helps

ManojDhobale · Answer 3 · 2012-01-10T22:39:00

i agree with above solutions

make listitem of name ---select---
and make it as selected

ListItem l1 = new ListItem("----Select----", "none");
ListItem l2 = new ListItem("abc", "abc");
ListItem l3 = new ListItem("xyz", "xyz");
DropDownList1.Items.Add(l1);
DropDownList1.Items.Add(l2);
DropDownList1.Items.Add(l3);
l1.Selected = true;

all the best

how to insert value dropdownlist Item by function.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0