Sorting data table by multiple columns using C#

Question

I have a Datatable with columns named foldername,documentname. Data as below:

FolderName  DocumentName
Folder1     HR[D] Document
Folder1     ___----'
Folder1     Asp_example.pdf
Folder2     SD
Folder3     Heavy_weight
Folder3     Accesorial Services

How to alphabetically sort DocumentName based on FolderName in .Net Framework 2.0.

Solution we tried is below but takes too many time as it contains more than 1200000 records.

int counter=0;

while (counter < searchDT.Rows.Count){
   string FolderName = Convert.ToString(searchDT.Rows[counter]["Folder Name"]);

   string exp = "[Folder Name] like '" + FolderName + "'";

   if (FolderName.Contains("%") || FolderName.Contains("_") || FolderName.Contains("[]") ||      FolderName.Contains("'"))

      exp = "[Folder Name] like '" + EscapeLikeValue(FolderName) + "'";

   string sortExpression = "[Document Name] ASC";

   DataRow[] drfoldername = searchDT.Select(exp, sortExpression);

   foreach (DataRow row in drfoldername)
     drfoldernameDT.ImportRow(row);

   counter += drfoldername.Length;

 }

You mention this information is obtained from the Database so why dont you do the ORDER BY clause in the SQL Query? Otherwise have you tried using a DataView rather than a DataTable? — Jeremy Thompson
– Jeremy Thompson, Commented Dec 27, 2012 at 9:25

Sebastian Brosch · Accepted Answer · 2019-08-12 09:50:56Z

42

DataTable dt = new DataTable();

DataView dv = new DataView(dt);
dv.Sort = "FolderName, DocumentName ASC";

Try that out. It will sort first for FolderName, then DocumentName.

If you need to send that to a component on the screen, you can do the same as you're doing with a DataTable.

edited Aug 12, 2019 at 9:50

Sebastian Brosch

43.8k15 gold badges78 silver badges89 bronze badges

answered Dec 27, 2012 at 9:29

André Silva

1,1699 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user1931665 Over a year ago

Thanks a lot, it worked. For a simple line of coding, i wrote a hell of stupid code

André Silva Over a year ago

Don't forget to upvote and mark as correct answer. That estimulates us to help more and more.

Neel Over a year ago

stange this ans is useful for OP bt still havnt marked as asnwer

André Silva Over a year ago

Yeah. I get a bit sad when this happens, but at least I know that it helped OP.

user6102644 Over a year ago

@AndréSilva your solution is sorting only those columns which are of string type, suppose i have a column say colA which is having string values like 1.23, 11.34, and 2.34. Then it will sort it as 1.23, 11.34, 2.34 which is wrong.

|

Scooter · Accepted Answer · 2016-10-06 15:45:28Z

3

Here was my solution to this problem:

Datatable FI = new Datatable();
DataView viewFI = new DataView(FI);
viewFI.Sort = "ServiceDate, ServiceRoute";
DataTable OFI= viewFI.ToTable();

answered Oct 6, 2016 at 15:45

Scooter

3744 silver badges8 bronze badges

1 Comment

Greg Trevellick Over a year ago

Thanks - this is the only answer that worked for me. The key was having DataTable OFI= viewFI.ToTable(); which most other answers omitted.

Ibrahim ULUDAG · Accepted Answer · 2012-12-27 09:28:50Z

2

Have you tried DataView.Sort?

dt.DefaultView.RowFilter = "FolderName , DocumentName ASC";
dt = dt.DefaultView.ToTable();

answered Dec 27, 2012 at 9:28

Ibrahim ULUDAG

4804 silver badges10 bronze badges

Comments

Syed Fahad Ali · Accepted Answer · 2012-12-27 11:21:00Z

0

If you are binding the dgv using a datatable, you can use do something like :

DataTable dtable = (DataTable) dgv.DataSource; dtable.DefaultView.Sort =

Alternatively check this :

http://www.codeproject.com/csharp/datagridsort.asp

thanks

answered Dec 27, 2012 at 11:21

Syed Fahad Ali

591 silver badge4 bronze badges

Comments

FelixSFD · Accepted Answer · 2017-01-25 12:42:58Z

0

You can use

oDataSet.Tables[0].DefaultView.Sort = "Column1 ASC ";

edited Jan 25, 2017 at 12:42

FelixSFD

6,10110 gold badges46 silver badges134 bronze badges

answered Jan 25, 2017 at 12:41

Amit Kumar Verma

3671 gold badge3 silver badges17 bronze badges

Collectives™ on Stack Overflow

Sorting data table by multiple columns using C#

5 Answers 5

6 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related