Sort Datagrdview programmatically

Hello,
How to sort the dgv columns programmatically.
Need to duplicate functionality as access for sorting.
Columns are of type integers/Text.

The code below does not quite work correctly for numbers.
Any suggestions

 Private Sub SortDgColumn(ByVal sender As Object, ByVal intColindex As Integer, ByVal DoSorting As Boolean)
        'Dosorting is flag to allow descending sorting on the grid columns this is used for Resetting or Selecting all fields as the datagridview should not sort if the selection column is not sorted.
        Dim int As Integer
        int = intColindex
        Me.Cursor = Cursors.WaitCursor
        Dim newColumn As DataGridViewColumn =
               sender.Columns(int)
        Dim oldColumn As DataGridViewColumn = sender.SortedColumn
        Dim direction As ListSortDirection
        'todo
        ' If oldColumn is null, then the DataGridView is not currently sorted. 
        If Not oldColumn Is Nothing Then
            ' Sort the same column again, reversing the SortOrder. 
            If oldColumn Is newColumn AndAlso sender.SortOrder =
                SortOrder.Ascending Then
                If DoSorting = True Then direction = ListSortDirection.Descending
            Else
                ' Sort a new column and remove the old SortGlyph. 
                direction = ListSortDirection.Ascending
                oldColumn.HeaderCell.SortGlyphDirection = SortOrder.None
            End If
        Else
            direction = ListSortDirection.Ascending
        End If
        ' Sort the selected column.
        Me.Cursor = Cursors.Default
        If IsNothing(sender.CurrentRow) Then Exit Sub
        sender.Sort(newColumn, direction)
        If TypeOf CType(sender, DataGridView).DataSource Is DataTable Then
            If direction = ListSortDirection.Ascending Then
                sender.datasource.DefaultView.Sort = newColumn.Name & "  ASC"
            Else
                If DoSorting = True Then sender.datasource.DefaultView.Sort = newColumn.Name & "  DESC"
            End If
        ElseIf TypeOf CType(sender, DataGridView).DataSource Is DataView Then
            Dim dv As New DataView
            Dim SortDataTable As New DataTable
            dv = sender.datasource
            sender.datasource = dv
            dv.Sort = newColumn.Name & "  ASC"
            If direction = ListSortDirection.Ascending Then
                dv.Sort = newColumn.Name & "  ASC"
            Else
                If DoSorting = True Then dv.Sort = newColumn.Name & "  DESC"
            End If
            SortDataTable = dv.ToTable
            sender.datasource = SortDataTable
        End If
    End Sub

Open in new window

RIASAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
The easiest way would be to cast your values in your select query. That way, you wouldn't have to write any code:
select field1, field2, cast(field3 as int) as field3 from yourtable ...

Open in new window

0
 
Éric MoreauSenior .Net ConsultantCommented:
is it possible that even if you see numbers in that column that the datatype of the column is really string (or varchar)?
0
 
RIASAuthor Commented:
Yes, Eric thats the problem it is a varchar field with numbers and suffix as letter
Example:
11a
11b
12a

But,access can sort it perfectly so ,is there any way vb.net dgv does it
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Éric MoreauSenior .Net ConsultantCommented:
they are 2 very different beast!
0
 
RIASAuthor Commented:
I know,but,need a way out
0
 
Éric MoreauSenior .Net ConsultantCommented:
can you pad your value with 0 on the left so it get sorted correctly?

0011a
0011b
0012a
0123a
1234a
0
 
RIASAuthor Commented:
Can't do that Eric
0
 
Éric MoreauSenior .Net ConsultantCommented:
can you at least have that value in a hidden column at least to sort on it? You will need to add code so that when the user click on your initial column, to sort on the hidden column.
0
 
RIASAuthor Commented:
Eric, Is there no way we can have sort on Alphanumeric

Found this :

https://www.experts-exchange.com/questions/21932003/DataGridView-Sorting.html#a17194545

But,still not alphanumeric
0
 
Éric MoreauSenior .Net ConsultantCommented:
that method relies on Double.Parse which will not work in your scenario because 11a does not have a double representation
0
 
RIASAuthor Commented:
Eric,I am trying to find a solution
0
 
RIASAuthor Commented:
Eric,
Again Dates is an issue for sorting
0
 
Éric MoreauSenior .Net ConsultantCommented:
>>Again Dates is an issue for sorting

I thought it was for alphanumeric!
0
 
RIASAuthor Commented:
There is another column for dates
0
 
Éric MoreauSenior .Net ConsultantCommented:
is the date column also a text column or really a date column? if it is text, the link you have provided could help solving the issue (by replacing everything related to Double by DateTime).
0
 
RIASAuthor Commented:
Its a txt column
0
 
RIASAuthor Commented:
Ok
0
 
RIASAuthor Commented:
Eric,
Now the column has all numbers but,it is declared as nvarchar in database.
Can you help me
0
 
RIASAuthor Commented:
Worked like Charm ! Cheers!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.