how to put a particular value on top of dropdownlist connected to a sql table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bart - 01 Feb 2008 23:14 GMT

Hi,

i have a dropdownlist connected to a sqldatasource like this:

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="Name">
</asp:DropDownList>

What i want is to put a particular value on the top of the dd. I can't use
ORDER BY.

e.g. the table which feeds the dd contains this:
R
D
A

how to put value D on top of the dd?
Thanks
Bart

Reply to this Message

bruce barker - 01 Feb 2008 23:44 GMT

i'd use an order by clause.

select name
from mytable
order by case
when name = 'D' then ''
else name
end case

-- bruce (sqlwork.com)

> Hi,
>
[quoted text clipped - 15 lines]
> Thanks
> Bart

Reply to this Message

Bart - 02 Feb 2008 10:49 GMT

Thanks, but i get an error when executing it in Studio Management:
Incorrect syntax near the keyword 'case'.

> i'd use an order by clause.
>
[quoted text clipped - 28 lines]
>> Thanks
>> Bart

Reply to this Message

bruce barker - 03 Feb 2008 05:23 GMT

simple typo (its just case ... end), you should read the docs:

select name
from mytable
order by case
when name = 'D' then ''
else name
end

> Thanks, but i get an error when executing it in Studio Management:
> Incorrect syntax near the keyword 'case'.
[quoted text clipped - 31 lines]
>>> Thanks
>>> Bart

Reply to this Message

Bart - 03 Feb 2008 11:30 GMT

Thanks, it works now

> simple typo (its just case ... end), you should read the docs:
>
[quoted text clipped - 40 lines]
>>>> Thanks
>>>> Bart

Reply to this Message

how to put a particular value on top of dropdownlist connected to a sql table?

Free Magazines