How to sort 3 columns of datagridview in vb.net

Below I want to sort for the columns "ProductCode", "ColorCode" and "Size". Please Guide.

Sort information in the Size column :

Private Sub Form3_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    Dim table1 As New DataTable("Players")
    table1.Columns.Add(New DataColumn("ProductCode", GetType(String)))
    table1.Columns.Add(New DataColumn("Remark", GetType(String)))
    table1.Columns.Add(New DataColumn("ColorCode", GetType(String)))
    table1.Columns.Add(New DataColumn("Size", GetType(String)))
    table1.Columns.Add(New DataColumn("Qty", GetType(Integer)))
    table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "5L", 25)
    table1.Rows.Add("TEST 2000", "TEST", "BHTF15", "S", 55)
    table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "M", 65)
    table1.Rows.Add("TEST 1000", "TEST", "BHTF25", "6L", 10)
    table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "S", 12)
    DataGridView1.DataSource = table1
End Sub

Desired Result

To sort three columns of a DataGridView in VB.NET, you can use the Sort method of the DataGridView control. The Sort method allows you to specify the column to sort and the sort direction. Here's a step-by-step guide on how to do it:

Assuming you have a DataGridView named dataGridView1 with three columns named Column1, Column2, and Column3, here's how you can sort them:

Private Sub SortDataGridView()
    ' Sort the first column in ascending order
    dataGridView1.Sort(dataGridView1.Columns("Column1"), ListSortDirection.Ascending)

    ' Sort the second column in ascending order
    dataGridView1.Sort(dataGridView1.Columns("Column2"), ListSortDirection.Ascending)

    ' Sort the third column in descending order
    dataGridView1.Sort(dataGridView1.Columns("Column3"), ListSortDirection.Descending)
End Sub

So being as you've got a specific order for the size, without knowing completely how you've can derive that I'm assuming that it's stored in a table somewhere. For simplicity's sake to facilitate the ordering you can add that to table, then hide the column in the DataGridView

I've changed the code for building the table slightly here.

Dim table1 As New DataTable("Players")
table1.Columns.Add(New DataColumn("ProductCode", GetType(String)))
table1.Columns.Add(New DataColumn("Remark", GetType(String)))
table1.Columns.Add(New DataColumn("ColorCode", GetType(String)))
table1.Columns.Add(New DataColumn("Size", GetType(String)))
table1.Columns.Add(New DataColumn("Qty", GetType(Integer)))
table1.Columns.Add(New DataColumn("SizePriority", GetType(Integer)))
table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "5L", 25, 10)
table1.Rows.Add("TEST 2000", "TEST", "BHTF15", "S", 55, 2)
table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "M", 65, 3)
table1.Rows.Add("TEST 1000", "TEST", "BHTF25", "6L", 10, 11)
table1.Rows.Add("TEST 3000", "TEST", "BHTF10", "S", 12, 2)

You will notice the SizePriority column I've added and set the value to the ordering attributes for the sizes you specified at the top of your question.

Next thing to do is apply the ordering. Using a BindingSource as was recommended by jmcilhinney in his comments would 100% be the ideal way to do this but since you seem resistant to taking his advice, I'm using a DataView (I would describe a DataView as the Visual Layer that sits over top of DataTables). Using this you would apply the sort property using the same syntax as an Sql Order by clause. Notice in your desired output, you had the Product code ordered descending, so added the Desc keyword to the sort.

Dim table1View As New DataView(table1)
table1View.Sort = "ProductCode Desc, ColorCode, SizePriority"
For Each row As DataRowView In table1View
    Console.WriteLine($"{row(0)}, {row(1)}, {row(2)}, {row(3)}, {row(4)}")
Next

Which gives me the following output