How to sort data and get new coloum number for it

Question

1.00/5 (1 vote)

See more:

VB

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim table As DataTable = New DataTable("Players")
        ' Add 2 columns.
        table.Columns.Add(New DataColumn("Size", GetType(Integer)))
        table.Columns.Add(New DataColumn("Team", GetType(Char)))
        ' Add 5 rows.
        table.Rows.Add(100, "a"c)
        table.Rows.Add(235, "a"c)
        table.Rows.Add(250, "b"c)
        table.Rows.Add(310, "b"c)
        table.Rows.Add(150, "b"c)

        

         '' table.DefaultView.Sort = "Size ASC"
        Dim size1 As String = table.Rows(4).Item("Size")
        table.DefaultView.ToTable()
        MsgBox(size1)
''' am getting 150 insted of 310

    End Sub
End Class

What I have tried:

''' am getting 150 instead of 310
after sorting i must get 310 as 4th number if this begins from 0

Posted 26-Apr-24 1:45am

Member 10974007

Updated 26-Apr-24 4:17am

PIEBALDconsult

v3

Add a Solution

Comments

Richard MacCutchan 26-Apr-24 8:56am

Your table has not been sorted, as the sort command has been commented out.

Member 10974007 26-Apr-24 9:50am

even if your remove the comment it wont work...

PIEBALDconsult 26-Apr-24 10:19am

Use DefaultView in:
Dim size1 As String = table.Rows(4).Item("Size")

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2024-04-26T04:04:00

Solution 1

It is the view that gets sorted not the source table. So you need to capture the DataView object and display the row from there. See DataView.Sort Property (System.Data) | Microsoft Learn[^] for an example.

Posted 26-Apr-24 4:04am

Richard MacCutchan

Updated 26-Apr-24 5:26am

v2

Andre Oosthuizen · Answer 2 · 2024-04-26T04:42:00

You are accessing the row at index 4, which is the 5th row in the DataTable which is why you get the vale of '150. Datatable indexes start from 0 -

VB

Dim size1 As String = table.Rows(3).Item("Size")

If you want to sort the DataTable by the 'Size' column in ascending order before accessing the rows -

VB

table.DefaultView.Sort = "Size ASC"

Your code should then look like -

VB.NET

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim table As DataTable = New DataTable("Players")

        'Add 2 columns...
        table.Columns.Add(New DataColumn("Size", GetType(Integer)))
        table.Columns.Add(New DataColumn("Team", GetType(Char)))

        'Add 5 rows...
        table.Rows.Add(100, "a"c)
        table.Rows.Add(235, "a"c)
        table.Rows.Add(250, "b"c)
        table.Rows.Add(310, "b"c)
        table.Rows.Add(150, "b"c)

        'Sort your DataTable by the 'size' column in ascending order...
        table.DefaultView.Sort = "Size ASC"

        'Get the value from the 4th row (index 3)...
        Dim size1 As String = table.Rows(3).Item("Size")

        'Convert the DataView back to a DataTable...
        table = table.DefaultView.ToTable()

        MsgBox(size1) 'Output should now be 310...
    End Sub
End Class