Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all,
Vanilla are planning an update to the site on April 24th (next Wednesday). It is a major PHP8 update which is expected to boost performance across the site. The site will be down from 7pm and it is expected to take about an hour to complete. We appreciate your patience during the update.
Thanks all.

Databound dropdown ASP.net

  • 08-08-2007 12:02am
    #1
    BostonB
    Closed Accounts Posts: 18,056 ✭✭✭✭


    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.


Comments

  • #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 38,752 Mod ✭✭✭✭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


  • #3
    BostonB
    Closed Accounts Posts: 18,056 ✭✭✭✭BostonB


    I'll try that 2morrow ta.


  • #4
    Kai
    Registered Users Posts: 604 ✭✭✭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.


  • #5
    BostonB
    Closed Accounts Posts: 18,056 ✭✭✭✭BostonB


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


Advertisement