VB.NET table.sort with multiple columns

Question

I have the following but need to add more columns to filter by. I am getting errors with the syntax I am trying.

Dim ldv1 As System.Data.DataView
ldv1 = tbl1.DefaultView
ldv1.Sort = (tbl1.Columns(0).ColumnName) & " Asc" <-- I want to add to this

I am trying to do something like this but failing:

ldv1.Sort = (tbl1.Columns(0).ColumnName) & " Asc",(tbl1.Columns(1).ColumnName) & " Asc"

OR

ldv1.Sort = (tbl1.Columns(0).ColumnName), (tbl1.Columns(1).ColumnName) & " Asc"

Neither seems to be the correct way. How do I sort by more columns?

Magnus · Accepted Answer · 2015-08-28 07:40:05Z

3

Add a , inside the string after the first Asc.

ldv1.Sort = tbl1.Columns(0).ColumnName + " Asc, " + tbl1.Columns(1).ColumnName + " Asc"

answered Aug 28, 2015 at 7:34

Magnus

47.3k8 gold badges88 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1