Grouping data in a datatable based on data in a column

Question

I have a datatable as below

**Name**      **Department**
  abc             dept 1
  def             dept 2
  ghi             dept 1
  jkl             dept 1
  mno             dept 2
  pqr             dept 1

I need to group the data in the datatable such that all names having Department as dept1 comes togather and then all names having Department dept2 comes next (as shown below) and save it in another datatable.

**Name**      **Department**
  abc             dept 1
  ghi             dept 1
  jkl             dept 1
  pqr             dept 1
  def             dept 2
  mno             dept 2

@Daniel I have retrieved the data from the database and saved it in the datatable. I need to manipulate the data in the datatable so that the output will be as above. — user673453
– user673453, Commented Apr 6, 2011 at 9:22

Simen S · Accepted Answer · 2011-04-06 09:48:01Z

3

You can fetch the data in the ordered way that you want by using the statement below:

 SELECT * FROM YourTable 
 ORDER BY Department ASC, Name ASC

This will sort the results with Department as the primary sorting key, and Name as the secondary. Both columns are sorted in ASC = ascending order (which is also the default sort order). If you have added indexes to these two columns, the sorted results will be retrieved as quickly as any other query on the table. I don't understand why you would want to save this sorted result in another table..

EDIT If you already have the data unsorted in a DataTable you can still retrieve a sorted version without duplication by using the following code

 yourDataTable.DefaultView.Sort = "Department ASC, Name ASC";

edited Apr 6, 2011 at 9:48

answered Apr 6, 2011 at 9:17

Simen S

3,20520 silver badges24 bronze badges

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

4 Comments

user673453 Over a year ago

I have retrieved the data from the database and saved it in the datatable. I need to manipulate the data in the datatable so that the output will be as above.

Simen S Over a year ago

Have you retrieved it with the query that I specified above? If so, then it will be correctly ordered. The only difference that I can observe between your two lists of rows is that the second one is sorted according to Department and Name.

user673453 Over a year ago

I have to use a simple select statement to retrieve the data from the database. Also the datasource that I use to retrieve the data can be an xml file in which case sql query cannot be used. Is there any other way to manipulate the data in the datatable so that I get the second list as the output.

user673453 Over a year ago

Thanks for your help. Its working. It doesn't seem to work with the datatable but it worked when dataview was used.

SwissGuy · Accepted Answer · 2011-04-06 09:23:46Z

0

For binding this Data sorted, you dont need a new Table. Just use the Select statement from your Datatable.

Datatable Select method

answered Apr 6, 2011 at 9:23

SwissGuy

5651 gold badge6 silver badges18 bronze badges

Collectives™ on Stack Overflow

Grouping data in a datatable based on data in a column

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related