C# .NET - C# - Sort a DataGridView by two columns

Hi guys,

my dataGridView has the following columns:

column 1   column2      column3

1                    group A        red

2                    group B        blue

3                    group A        blue

4                    group A        blue

5                    group B        red

6                    group B        blue

7                    group B        red

8                    group A        red

I need to sort by column2 and then by column3

In order to get:

column1    column2    column3

3                  groupA       blue

4                  groupA       blue

1                  groupA       red

8                  groupA       red

2                  groupB       blue

6                  groupB       blue

5                  groupB       red

7                  groupB       red

How can I do that?

Thanks,

Aldo.

Hi,

try the below code to sort using mutplie columns...

Dataset ds = (Dataset) DataGridView1.DataSource;

DataView x = ds.Tables[0].DefaultView;

x.Sort = "Column2, Colmun3 asc";

DataGridView1.DataSource = ds;

and the sort proprty of dataview.

By using SORT you can achive this like;

DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "col2,col3 asc"; // for ascending
dv.Sort = "col2,col3  desc"; // for descending
GridView1.DataSource = dv;
GridView1.Databind();

See these links to know more abt sort of dataview;

http://www.developerfusion.co.uk/show/4686/

http://davidhayden.com/blog/dave/archive/2006/02/11/2798.aspx

http://www.dotnetjohn.com/articles.aspx?articleid=77

http://www.asp101.com/articles/jayram/multicolumnsort/default.asp

Best Luck!!!!!!!!!!!!
Sujit.

You can make use of DataView and sort property for this..

Try the below code

DataView myData = ds.Tables[0].DefaultView;
myData.Sort = "column2,column3 asc";
GridView1.DataSource = myData;
GridView1.Databind();

Guys,

I am using

void SortDGVby2Col(DataGridView dgvToSort, string col1, string col2, string order)

DataSet ds = (DataSet)dgvToSort.DataSource;

DataView dv = ds.Tables[0].DefaultView;

dv.Sort = col1 + ", " + col2 + order;

//dgvToSort.Databind();