sorting a combobox

[Guest]

Hello
I use the following code to populate a combobox

Me.cbxPeerReview.DropDownStyle = ComboBoxStyle.DropDownLis
With cbxPeerRevie
.DataSource = dtEm
.DisplayMember = "STR_NAME_F
.ValueMember = "ID_USER
End Wit
Me.cbxPeerReview.DroppedDown = Tru
Me.cbxPeerReview.SelectedIndex = -

I want to sort to combobox by the "STR_NAME_F", but if I add the .sorted = true line, I get the following error

An unhandled exception of type 'System.ArgumentException' occurred in system.windows.forms.dl
Additional information: Cannot sort a ComboBox that has a DataSource set. Sort the data using the underlying data model

How do I sort the data using the underlying data model?

Thanks
Amber

 

[Guest]

I guess dtEmp is a DataTable...all you have to do is sort the dataTable before you set it as the datasource

 

[William Ryan eMVP]

Create a DataView based on the table...

Dim myView as DataView = dtEmp.DefaultView
Then you can sort on any field you want. From there, just substitute
..DataSource = dtEmp with .DataSource = myView

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com

Hello,
I use the following code to populate a combobox:

Me.cbxPeerReview.DropDownStyle = ComboBoxStyle.DropDownList
With cbxPeerReview
.DataSource = dtEmp
.DisplayMember = "STR_NAME_F"
.ValueMember = "ID_USER"
End With
Me.cbxPeerReview.DroppedDown = True
Me.cbxPeerReview.SelectedIndex = -1

I want to sort to combobox by the "STR_NAME_F", but if I add the .sorted =

true line, I get the following error:

An unhandled exception of type 'System.ArgumentException' occurred in system.windows.forms.dll
Additional information: Cannot sort a ComboBox that has a DataSource set.

Sort the data using the underlying data model.