c# dropdown binding default value

Question

0.00/5 (No votes)

See more:

how can i add default value "select one" at zero index position when dropdownlist is having datatext field and datavalue field which is obtained from database througt dataset.

Posted 6-Jun-12 22:40pm

subin joseph

Add a Solution

Comments

csharpbd 7-Jun-12 15:28pm

both solution are good...
but i think solution 1 is the best 4 u......

2 solutions

Solution 1

>One way to do this is to use UNION clause on the query you use to populate your dropdown with.

For e.g.

select 0, "select one"
UNION
select colA, colB from tableA

Posted 6-Jun-12 22:45pm

Abhinav S

v2

Comments

subin joseph 8-Jun-12 1:14am

i am still getting an error message like this " Invalid column name 'select' ".
my stored procedure query is
select 0,"select" UNION select ste_stateid,ste_statename from bqs_state where ste_countryid=@countryid

subin joseph 8-Jun-12 3:01am

i have just got the output .i put ' ' instead of " ".thanks

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)

Mits Machhi · Accepted Answer · 2012-06-06T23:23:00

you can add by using the query : you can add on pageload event of page.
but add in !ispostback event.

like.....

C#

protected void Page_Load(object sender, EventArgs e)
 {
    

     if (!IsPostBack)
     {
         //  you must set the connection first.
        // e.g c.setcon(); // here this is method for setting a connection
         DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("Select field1  FROM Table", connection object);
        myda.Fill(ds);
        DropDown1.DataSource = ds;
        DropDown1.DataValueField = "field1";
        DropDown1.DataBind();
        DropDown1.Items.Insert(0, new ListItem("Select One", "0"));
         
     }
    
 }

hope this will help you, if not then dear please post it.