loading a sequence into a listbox

[angela1979]

How would I put a sequence value into a listbox?
I know you access a sequence from a database using

Select seq_id.nextval from dual

I just would like to figure out how to put the value into a listbox.

 

[vis781]

you can do this a couple of ways...

Use a datareader and read the values into the listbox

or..

Fill a datatable with the information from the database and set the datasource property of the listbox to the datatable. Then Set the displaymember property of the listbox to the field you want it to display.

The first method will be faster but it would depend on what you are planning to do with the data as to which method would be most appropriate