Dropdownlist adding data after databind

K

Kimberly Walker

Im farily new to the .Net so please bear with me. I have several
dropdownlist that is bound to a sql string.
For example
dim sqlstring as string="Select books from SuborgT where books=New"
I then bind this and it gives me the "new" in the dropdownlist.
What I need is just like in a combobox in Ms Access is to not only
give you the source but you can also create the record source in it.
I need for the dropdownlist to include "Old", and "FY". Of course I
can do an items.add just for the books but I have several dropdownlist
that have several items in it.
I tried using the add item... For example
dropdownlist.items.add("Select books from SubOrgT where books not=" &
"'" & dropdownlist.seletecteditem.value & "'")
but this doesn't work it just adds another item to the dropdownlist
that says Select book.....
can anyone tell me why basically I can't add two sources to the
dropdownlist and is there another way to do this.
**please bare with me I don't have the code in front of me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,579
Members
45,053
Latest member
BrodieSola

Latest Threads

Top