Loading

How to use Sort command in c #.

tirumalai srinivasaraghav

sir,

I have got a Database in SQLServer with SlNo, Part #, Description, Qty. I want to use sort command in C # for the Database. Can you please let me know the code for the same.

With Regards

(T.E. SRINIVASARAGHAVAN).

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger10y ago
Hi,

you could with the help of LINQ. If you are know about the entity framework you are using LINQ or you do LINQ TO SQL.
Afzaal Ahmad Zeeshan10y ago
In SQL, you can use ORDER BY command to order the data. For example,
```
SELECT * FROM table ORDER BY SINo
```
This would sort the elements by SiNo. You can use other commands, like, "DESC" and others. There are other functions in SQL too, which you would like to know. Read the MSDN document for that: https://msdn.microsoft.com/en-us/library/ms188385.aspx