Sort Datatable in vb.net with linq by Column index

Question

I need to sort a datatable. I do it with linq this an example

Dim query = From c In dt.AsEnumerable _
              Order By c.Field(Of DateTime?)("LastPurchaseDate"), _
                       c.Field(Of String)("LastName") Descending
            Dim dv As DataView = query.AsDataView

But my problem is that i need to sort the fields not by passing the name of the column but the index of that. Is there a way?

well I have trouble with the name, because I am using Greek names and it sort of blowing the code up. When i use english it works fine — themhz
– themhz, Commented Mar 23, 2012 at 15:28
I am doing this also, Dim query = From c In dt.AsEnumerable _ Order By c.Field(Of String)(10) Ascending Dim dv As DataView = query.AsDataView but it doesn't work it keeps the same sort, when I gather the dv.Table — themhz
– themhz, Commented Mar 23, 2012 at 15:36

purplesoft · Accepted Answer · 2021-06-19 20:46:13Z

5

Dim dt As New DataTable
Dim orderedby = From p As DataRow In dt.Rows Order By p.Item(0) Ascending, 
p.Item(1) Ascending 
Select p cast p as datarow

edited Jun 19, 2021 at 20:46

answered Mar 23, 2012 at 18:28

purplesoft

5262 silver badges10 bronze badges

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

Comments

themhz · Accepted Answer · 2012-03-23 16:38:23Z

2

Finally I managed to do this using clone method of a datatable.

    Dim DataTableNew As DataTable = New DataTable
    DataTableNew = dt.Clone
    Dim query = (From c In dt.AsEnumerable Order By c.Field(Of String)(12) Ascending)
    query.CopyToDataTable(DataTableNew, LoadOption.OverwriteChanges)

answered Mar 23, 2012 at 16:38

themhz

8,43622 gold badges86 silver badges109 bronze badges

Collectives™ on Stack Overflow

Sort Datatable in vb.net with linq by Column index

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related