我正在使用asp.net中的datareader重读月份的数量？ [英] I am retriving month's in number using datareader in asp.net?

问题描述

我正在使用asp.net中的datareader重读月份数量？



我希望以此形式订购 - > 1,2,3,4,5,6,7,8,9,10,11,12



但是通过重新搜索数据，它的形式为 - > 1,10,11,12,2,3,4,5,6,7,8,9







请帮帮我..............！

I am retriving month's in number using datareader in asp.net?

i want order in this form - > 1,2,3,4,5,6,7,8,9,10,11,12

But by retriving data it comes in the form of - > 1,10,11,12,2,3,4,5,6,7,8,9



help me out please ..............!

推荐答案

在你的sql语句或存储过程中确保您按照包含月份编号的列进行选择

In your sql statement or stored proc make sure you order you selection by the column that contains the month number

Select MonthNum from CalTable Order By MonthNum ASC

use ORDER BY Keyword in sql query.(ASC|DESC)

 for example customer id 1,3,7,4,9,17,9,46,,24

than write sql query like this- select * from tbl_Customer order by  customer id ASC


and than  query will  return-1,3,7,4,9,17,24,46

我知道这个首先代表您的申请它不起作用Dec / Asc这就是为什么我要问这个

I Know This Apply First On Your Behalf It Is Not Working Not Ever Dec/Asc That's Why I am asking About this

这篇关于我正在使用asp.net中的datareader重读月份的数量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！