How to sort the data in Datatable
Answers were Sorted based on User's Feedback
Answer / kamalakannan.a
I think the above answer is correct.Another one method is
DataTable dt=new DataTable();
DataRow[] dr=dt.Select("Filter Expression","Sort
expression");
Here Sort expression is , for eg.Address is one of the
field in dt.
Then DataRow[] dr=dt.Select("","Address ASC");
But in this method is have the Datarow array.So you can use
another one method,I explain below.
DataView dv=new DataView(Datatable,Filter Exp,Sort
Exp,Dataviewrowstate)
Eg is
DataView dv=new DataView(dt,"","Address
ASC,DataViewVowState.CurrentRows);
Here we can copy this Dataview to datatable or use this
same dataview instead of datatable.
Kamal....
Is This Answer Correct ? | 28 Yes | 3 No |
Answer / narayansahu
pass the datatable in dataview object and call the sort
method on dataview
dataview dv=new dataview(dt)
dv.sort
that's it
Is This Answer Correct ? | 17 Yes | 17 No |
How to add a javaScript function in a datagrid?
Command objects uses, purposes and their methods.
What is sqldatareader in ado.net?
How can you implement sub data grid in a master datagrid?
Explain the two fundamental objects in ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What is difference between ado and other data object?
can we execute trigger normally at the desired time?
Which parameter of ConnectionString is used to specify the name of the database?
What are the advantages and disadvantages of using datalist?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Which is better entity framework or ado.net?