Any1 know how to sort a data table?

On the internet just show how to sort before bind to gridview and etc

but I wan to sort the table to put the no for each row,anyone can help?

Then if got the column got same value,then how? For example:

Table
Column1 column2
a 7
b 3
c 3
d 5

need to sort by the column2

google search "order by"

For example
http://www.w3schools.com/sql/sql_orderby.asp

you miss undestood alr,cos I am try to sort is datatable ,not sql component.

Perhaps you should specify what application you are using then, because it makes a difference. If you are using a web application then you sort the SQL/MySQL when creating the data grid. If you are using Access, Access has a built in sort function. I'm sorry I missunderstood what you wanted to know but it's because you weren't clear enough with your question.

The SQL if I understood you correctly

For Ascending

For Descending

Where `field` is a primary key. (Not sure if it's necessary that field be a primary key. Doesn't work for me if it isn't).

I don't think he's using SQL.

By "...not sql component." I think he means the "order by". He wants to change the order of the DATABASE and that SQL does just that. All you have to do is go on SQL in the table in phpMyAdmin.

just fill the data in datatable...

then use
datatble.defaultview.sort = "column name";

else you may try to use javascript, doing sorting in DOM.