Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Populating a Drop Down List with Items from Dataset and then adding more items...

Posted on 2003-12-05
2
Medium Priority
?
864 Views
Last Modified: 2010-04-16
okay... a question for you...
 
I have a DropDownList called ddl_title_id
 
I populate this DropDownList with the following method...
 
private void populate_ddl_title_id()
{
 da_titles.Fill(ds_titles);
 ddl_title_id.DataSource = ds_titles;
 ddl_title_id.DataMember = "titles_select";
 ddl_title_id.DataValueField = "title_id";
 ddl_title_id.DataTextField = "title";
 ddl_title_id.DataBind();

 ddl_title_id.Items.Add(new ListItem("", "0"));
 ddl_title_id.SelectedValue = "0";
}
 
obviously:
  da_titles is a dataadapter
  ds_titles is a dataset
  titles_select is a stored procedure within the dataadapter
________________________________________________________
now here's my question...
 
as you can see from my code above once i've got all the values from my dataset then i add a blank item also with a value of 0 and text of "".
how can i re-order the DropDownList items so that the final item I add is at the top of the list?

before you reply consider this... i know how to loop around a recordset and populate like that, but i'd like to use a dataset to populate my DropDownList.

willing to consider any neat solution, but please don't suggest any of the following unless you have a very strong argument for doing so....
- i don't want to make changes to my stored procedure
- i don't want to add a blank record to my titles table
- don't suggest adding my blank item before i populate with my dataset as it wipes any current items.

so... what's the solution someone.... please :)

cheers, sho.
0
Comment
Question by:sho_1978
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
testn earned 200 total points
ID: 9882103
change it to

ddl_title_id.Items.Insert(0,new ListItem("", "0"));
ddl_title_id.SelectedIndex = 0;
0
 

Author Comment

by:sho_1978
ID: 9882130
you little beuty !!! :)

points are yours, many many thanks testn (guess you never got around to changing your name) :)

sho
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question