DaniWeb IT Discussion Community - View Single Post

Re: Updating a databound combobox

Nov 10th, 2006

I solved it myself using the dataview class.

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
Dim dbView As DataView
dbView = new DataView(DataSet1.Tables("<tablename>"))
dbView.Sort = "id DESC"
 
cmbRegID.DisplayMember = "column2"
cmbRegID.DataSource = dbView
cmbRegID.SelectedIndex = 0
Dim dbView As DataView
dbView = new DataView(DataSet1.Tables("<tablename>"))
dbView.Sort = "id DESC"
 
cmbRegID.DisplayMember = "column2"
cmbRegID.DataSource = dbView
cmbRegID.SelectedIndex = 0

Now everytime I add (or delete) items from the datatable it shows in the combox right away (and selects the latest added item).