Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to sort the data in Datatable

Answers were Sorted based on User's Feedback



How to sort the data in Datatable..

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

How to sort the data in Datatable..

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

Post New Answer

More ADO.NET Interview Questions

What is serialization and de-serialization in .net?

0 Answers  


What is the use of SqlCommand object?

0 Answers  


What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  


what is ado.net

6 Answers   Karrox, SunGard,


How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?

2 Answers  


How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,


What is openquery?

0 Answers  


If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,


What are the steps to connect to a database?

0 Answers  


What are the benefits of using ado.net?

0 Answers  


Describe datareader object of ado.net with example.

0 Answers  


what is type dataset?

3 Answers  


Categories