how to display the list of users in alphabetical order in dropdown list

Question

0.00/5 (No votes)

See more:

Hi Every one,

I have the below stored proc:

SQL

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'Select'
END

Could any one please tell me how to display the "Username" values in alphabetical order by keeping the value 'Select'
always on top ?

Regards,

Posted 1-Mar-11 18:36pm

Raj.rcr

Updated 1-Mar-11 19:11pm

v3

Add a Solution

2 solutions

Solution 1

Try

SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNIONSELECT 0,'All' 
Order by 2

Posted 1-Mar-11 18:39pm

Abhinav S

Comments

Raj.rcr 2-Mar-11 0:55am

But, 'All' should always be on Top in the dropdown list. Thats not possible with this query.

Raj.rcr 2-Mar-11 1:44am

Thanx for the answer.

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)

pankajupadhyay29 · Accepted Answer · 2011-03-01T18:56:00

Solution 2

Try this it will work

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'All') alluser order by UserName
END

[Edit]
you can use this

SQL

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName, UserName as ForOrdering FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'All','~') alluser order by ForOrdering
END

[/Edit]
--Pankaj

Posted 1-Mar-11 18:56pm

pankajupadhyay29

Updated 1-Mar-11 19:04pm

v2

Comments

Raj.rcr 2-Mar-11 0:58am

This is same as the above one. 'All' should always be on Top in the dropdown list. Thats not possible with this query.

pankajupadhyay29 2-Mar-11 1:07am

i made change for your requirement.

Have you try this
SELECT 0 as Uid,'All' as UserName
Union
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2 order by UserName.

I am not sure about this but it should work.

Raj.rcr 2-Mar-11 1:07am

ya.. I tried this also.. Its not working.

pankajupadhyay29 2-Mar-11 1:09am

what about edited part that must work. have you checked??

Raj.rcr 2-Mar-11 1:12am

I really tried both.. Its not working.. Please take 'Select' instead of 'All' to avoid the confusion and
suggest me.

Raj.rcr 2-Mar-11 1:18am

The edited part is working as per my requirement but one more column called ForOrdering should not be displayed.

Raj.rcr 2-Mar-11 1:29am

Yeah got it... Its working as I needed. Extra column doesn't affect the drop downlist. Thank you soooooo much.