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 |
Explain the difference between an ado.net dataset and an ado recordset?
Define atomicity?
How to store data in memory?
Why do we use sqldataadapter?
What are the different row versions available?
What are the data providers used in ado.net
Does sqlclient and oledb class share the same functionality?
What is the default view of Data Grid?
What is ODP.NET?
What is the use of command objects?
What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?
Call a stored procedure from ado.net and pass parameter to it ?
7 Answers Keane India Ltd, TCS,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)