在asp.net 4.0中的网格视图中按降序对记录进行排序 [英] Sorting of Record in descending order in grid view in asp.net 4.0

问题描述

亲爱的朋友，

我在asp.net 4.0的网格视图中显示排序记录时遇到问题.我已经在日期基础上在查询中放置了order by子句，之后又没有序列号，例如:-

"按[日期] desc，[序列号] desc从[表名]顺序中选择*".

但是我的问题是，它按日期对数据进行排序，但是当涉及到同一日期的记录排序时，序列号如37/1/1/ROR/20和37/1/1/ROR/9，它实际上将37/1/1/ROR/9放在37/1/1/ROR/20之前，因为sql server 2008在单个数字后填充零，因此使序列号成为
.
37/1/1/ROR/9到37/1/1/ROR/90 ，因此放在37/1/1/ROR/20之前.

最后排序的列表出错了.

有人可以帮我吗?

谢谢

Varun Sareen

Dear Friends,

I have an issue showing sorted record in grid view in asp.net 4.0. I have put order by clause in the query on date basis and after that on serial no basis like:-

"select * from [TableName] order by [Date] desc, [SerialNo] desc".

But my problem is that it sorts the data according to date but when it comes to sorting of record on the same date where serial no are like 37/1/1/ROR/20 and 37/1/1/ROR/9, It actually puts 37/1/1/ROR/9 before 37/1/1/ROR/20 as sql server 2008 pads a zero after a single digit hence making the serial no.

37/1/1/ROR/9 to 37/1/1/ROR/90 therefore putting it before 37/1/1/ROR/20.

And in the end the sorted list goes wrong.

Can anyone help me in this.?

Thanks

Varun Sareen

推荐答案

这将起作用

This will work

SELECT * FROM [TableName] ORDER BY [Date] DESC, CAST(REPLACE([SerialNo], '37/1/1/ROR/','') AS BIGINT) DESC

我的建议是，如果您通过拆分SerialNo列来创建其他列，那么将很容易处理这些事情，而不是上面的方法.

示例:

My suggestion is if you create additional columns by splitting the SerialNo column then it will be easy to handle these kind of things instead of above way.

Example:

SerialNo      - AC1 AC2 AC3 AC4 AC5
37/1/1/ROR/90 - 37  1   1   ROR 90

注意:交流-附加列

这篇关于在asp.net 4.0中的网格视图中按降序对记录进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！