Arrange database Column entries by ascending order.

[jeshra279]

Hi All, I have a SQL database column "ID", in which I added one by one entries as 2,5,6,1,8... randomely. I want to arrange these entries in Ascending order so that in datagridview it get displayed in order 1,2,3,4... like this. Can someone help me on this? Thanks.

[dan sh]

Use order by in the query/stored procedure you are using to retrieve the data.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Lost User]

This is not the appropriate forum for your question. Choosing the correct forum helps you get more answers (and better answers).

[Vimalsoft Pty Ltd]

If you have a SQL Question Post here General Database http://www.codeproject.com/Forums/1725/General-Database.aspx[^] in the Query that you use to display the Grid with , add the Following line of SQl

Order by ID ASC

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/