Datagridview not sorting data correctly

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • haqpal
    New Member
    • Feb 2016
    • 1

    Datagridview not sorting data correctly

    1042
    789
    908
    1049
    after sorting


    698
    1042
    789
    908
    1049
    i used this code

    Me.classDataGri dView.Columns(" Total").SortMod e = True


    Me.classDataGri dView.Sort(Me.c lassDataGridVie w.Columns("Tota l"), ListSortDirecti on.Descending)
  • Luk3r
    Contributor
    • Jan 2014
    • 300

    #2
    This is because your numbers are being entered as strings. You can always do something simple like this:

    Code:
    DataGridView1.Rows.Add(1042, 0)
    DataGridView1.Rows.Add(789, 0)
    DataGridView1.Rows.Add(908, 0)
    DataGridView1.Rows.Add(1049, 0)
    DataGridView1.Rows.Add(698, 0)
    DataGridView1.Sort(DataGridView1.Columns(0), System.ComponentModel.ListSortDirection.Descending)

    Comment

    Working...