Posted on 2010-09-15
I am a VB 6.0 programmer just getting my feet wet in a .NET app that I inherited, so have alot of questions that you will probably seeing this next week!
There is a form that has a ComboBox, and I found the code that is loading the DropDown, but I need the items sorted by another Field named "SortValue"
Here is the code the other person had in there. I tried to put a ORDER BY behind the line that sets the foundRows = .
That didn't work, and not sure where to place it:
Sub PopulateDropDown(ByVal parmTypeCodeGroupName As String, ByVal parmControl As ComboBox)
Dim foundRows() As Data.DataRow
Dim typeCodeItem As DataRow
Dim i As Integer
parmControl.Text = ""
'foundRows = _7thwaveDataSet.Tables("TypeCodeGroupName").Select("TypeCodeGroupName Like '" + parmTypeCodeGroupName + "'")
foundRows = _7thwaveDataSet.Tables("TypeCodeGroupName").Select("TypeCodeGroupName Like '" + parmTypeCodeGroupName + "'") 'group id = 25
For i = 0 To foundRows.Length - 1
typeCodeItem = foundRows(i)
Catch ex As Exception