Databound dropdown ASP.net

BostonB

I'm new to VB.net/ASP. I'm using a Databound dropdown in ASP.net (VB). The dropdown list is order in no sequence that I can fathom. How can I order it and and set the default. or better set the default as nothing so the user has to select something.

Seth Brundle

You are basing it on a query so presumably your query is something like

SELECT DISTINCT [field1], [field2],field3] FROM [table]

to sort it change it to:

SELECT DISTINCT [field1], [field2],field3] FROM [table] ORDER BY [field2] ASC

To had a blank default value and assuming there are no blanks in your table:

SELECT DISTINCT [field1], [field2],field3] FROM [table] 
UNION
SELECT DISTINCT "","","" FROM [table] ORDER BY ORDER BY [field2] ASC

BostonB

I'll try that 2morrow ta.

Kai

You can also add a default like this

DropDownList ddl = new DropDownList();
DataView dv = GetSomeData();
ddl.DataSource = dv;
ddl.DataTextField = "field1";
ddl.DataValueField = "field2";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("Please select an option", "0"));  

which may be an easier or more difficult option depending on how your doing it.

BostonB

Its actually not my code, just something that got passed to me. Found an error in the SQL and its sorted now. Cheers.