how to put select at the top and other at the last in c# combobox

Question

0.00/5 (No votes)

See more:

i have a combo box where i want to put other at the last while retrieving it through database and select at the top of combo box and all other entries in between them in ascending order of alphabet pls tell me how to do this

Posted 20-Feb-14 20:14pm

ank170989

Add a Solution

Comments

BillWoodruff 21-Feb-14 2:20am

Is this Windows Forms ? Do you have binding working where you are able to display database items in the ComboBox now ?

ank170989 21-Feb-14 2:30am

yes this a window form with binding from database

Tom Marvolo Riddle 21-Feb-14 2:33am

answer updated try it and let me know

2 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)

Neeraj Pandya · Answer 1 · 2014-02-20T20:23:00

Solution 1

use this it may help you.

comboBox1.Items.Insert(0, "Select");
comboBox1.SelectedIndex = 0;

Posted 20-Feb-14 20:23pm

Neeraj Pandya

Updated 20-Feb-14 20:41pm

v2

Tom Marvolo Riddle · Answer 2 · 2014-02-20T20:32:00

Solution 2

Get count from database and assign it to integer

Try this after binding:

C#

SqlCommand cmd = new SqlCommand("select count(*) from table", con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
    count = int.Parse(dr[0].ToString());
    dr.Close();
}
comboBox1.Items.Insert(00, "select");
comboBox1.Items.Insert(count+1, "other");
comboBox1.SelectedIndex = 0;

Posted 20-Feb-14 20:32pm

Tom Marvolo Riddle

Updated 20-Feb-14 20:44pm

v2

Comments

ank170989 21-Feb-14 5:05am

i am getting following error
InvalidArgument=Value of '5' is not valid for 'index'.
Parameter name: index

Tom Marvolo Riddle 21-Feb-14 5:08am

post your code here.I'll check it and let you know