I have a windows form that represents master records in a
database. One of the fields has lookup values displayed
in a listbox.
What is the best way to fill the listbox from the lookup
1. Use the listbox's add method in the middle of a
datareader (while dr.read listbox.add )
2. bind it to a lookup dataset like this:
lstBox.DataSource = ds.Tables(0)
lstBox.DisplayMember = "LicsCode"
3. something else
Now I need to set the listbox's initial value and save any
changes after editing to the recordset for the master
table. What's the best way to do that? Is there someway
to bind the listbox to the recordset that represents the
row being edited in the master table so that the inital
value and any changes are reflected in the master table
p.s. no wizard solutions please, they don't do error
p.s. Is there a book or documentation or references that
describe techniques like this.