Sorting gridview on asp .net

Question

Hay guys i have a datatable of employees that have 6 column the first one is EmployeID, on page load i bind the data to the gridview and the result is this.

The screenshot

as you see on the screenshot the employe id start with
AG0
AG1
AG10
AG11
AG2
AG3
...

and i wanna sort them like.

AG0
AG1
AG2
AG3
AG4
AG5
AG10
AG11
...

Sorry about my english, and thanks in advance

You need to remove AG from employeeid and convert it int and sort — Krishna
– Krishna, Commented Apr 16, 2017 at 4:27

Community · Accepted Answer · 2017-05-23 12:02:10Z

0

There are some similar questions on SO. Here's one possible option, and you can explore other solutions by yourself (start with: 1, 2, 3):

var list = new List<string>() { "AG1", "AG10", "AG2"};
var ordered = list.Select(s => new { Original = s, Trimmed = s.TrimStart("AG".ToCharArray())})
                  .OrderBy(x => int.Parse(x.Trimmed))
                  .Select(x => x.Original)
                  .ToList();

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Apr 16, 2017 at 9:52

OfirD

10.7k8 gold badges59 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Sorting gridview on asp .net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related