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?