I have one DropDownList which is binding to one database table's field in Ms Sql Server. The problem is that the number displayed in my DropDownList is not in sequence while it is the oppose in Ms Sql Server.

For example, in my DropDownList, the sequence is 3, 5, 1, 4, 2
in Ms Sql Server, it is 1, 2, 3, 4, 5

Can anyone tell me why?

You need an order by in your query; MS SQL returns data in no specific order, which is what I think you are experiencing. Let me know if otherwise.

Brian

Thank you bmains. You are right. I need to order it in my query.