troubleshooting Question

Refreshing drop down list items from datasets

Avatar of PantoffelSlippers
PantoffelSlippersFlag for South Africa asked on
Visual Basic.NET
5 Comments1 Solution905 ViewsLast Modified:
Hi Experts

I've read tons of questions but can't find what I'm looking for, hope you can help!

I'm writing a VB.Net interface for SQL Server 2005 Express database.

My problem is simple: the interface uses a lot of drop-down lists - some of them contain huge numbers of list items.
While users are using the drop-down lists to capture data, other users are editing the available items for these lists (All list items are stored in a table).  I need to keep the lists being used showing the most recent available items. I hope I'm being clear.

Currently I have a dataset.Table("ListName") for each drop down list. I set the datasource and dataMemeber for each combo box.  It;s like binding the items collection right?  (I'm new to this)

If another user(admin) changes the available list items after the dataset have been opened, how do I keep the dataset I'm working off up to date so that it includes new items as well?  

Question 1: Is there a dataset.Table("Name").Refresh or something? I can't really consider to fill each dataset again and again because there are too many lists and they contain too many items! I need some sort of update or refresh option.

Question 2: Is the method I'm using (getting drop-down items from a dataset) the most effective way of doing it?



Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros