Q:

Datatable Sorting From A Custom Number Sequence

My datatable has a field that has values like so..
0000006685-001
0000006685-002
0000006713-001
0000006714-002
0000006713-002
0000006697-002

I want the datatable to be re-ordered by this field so the numbers on the left of the hyphen go in order, followed by the corresponding sequence in order. So the above example data would be ordered like..
0000006685-001
0000006685-002
0000006697-002
0000006713-001
0000006713-002
0000006714-002

A:

   Dim dv As New DataView(parsedDataset.Tables("Detail"))
        dv.Sort = "the field"
 Dim dt As DataTable = dv.ToTable

