How to sort datataable accordding alphabatic order

Question

hi freiends , i want to know How to sort datataable accordding alphabatic order ? Thanks

Amit Choudhary · Answer

Hi sagar, Try this DataView dataView = new DataView (dTable); dataView.Sort = "Name DESC" ; dTable=dataaView.ToTable(); Hope this helped you. Thanks.

sagar Bhosale · Answer

Thanks all of friends for your valuable help

Priya Linge · Answer

You can sort the datatable like, DataTable dt=new DataTable(); dt.DefaultView.Sort="FisrtName Desc"; Suppose you have dataset then, DataSet ds=new DataSet(); ds.Tables[0].DefaultView.Sort="FirstName Desc"; Thanks.

Manish Dwivedi · Answer

Hi Sagar, You can also sort datatable by using DefaultView sort method Datatable.DefaultView.Sort = sortExpression + " " + sortOrder;

Satish Bhat · Answer

There are two ways you can do this. Using DataView See the code below. I have created a DataView object by passing my DataTable as parameter, so my DataView will have all the data of the DataTable. Now, simply call the Sort method of the DataView and pass the sort expression. Your DataView object have sorted records now, You can either directly specify the Source of the Data controls object like GridView, DataList to bind the data or if you need to loop through its data you can use ForEach loop as below. // Sorting DataTable DataView dataView = new DataView (dTable); dataView.Sort = " AutoID DESC, Name DESC" ; foreach ( DataRowView view in dataView) { Response.Write(view[ "Address" ].ToString()); } Using DataTable.Select() method Yes, you can sort all the rows using Select method too provided you have not specified any filter expression. If you will specify the filter expression, ofcourse your rows will be sorted but filter will also be applied. A small drawback of this way of sorting is that it will return array of DataRows as descibed earlier so if you are planning to bind it to the Data controls like GridView or DataList you will have for form a DataTable by looping through because directly binding arrays of rows to the Data controls will not give desired results. DataRow [] rows = dTable.Select( "" , "AutoID DESC" ); Source: http://www.dotnetfunda.com/articles/article131.aspx

How to sort datataable accordding alphabatic order

Answers (5)