Sorting Columns in DataTable C#

Question

0.00/5 (No votes)

See more:

__________________________________________________________
SDR_CLK0[1]| SDR_WE_N[1]| SDR_DQM1[1]| SDR_D8[1]|
__________________________________________________________
1.58307004 1.581856966 1.580593944 1.582041979
1.571203947 1.568992019 1.566966057 1.570862055
1.565935016 1.564203978 1.56219399 1.56514895
1.574257016 1.571560979 1.568174958 1.572227001
1.587502003 1.589027047 1.583907008 1.586900949
1.577990055 1.579285026 1.574648023 1.580180049
1.578268051 1.574828982 1.572911024 1.577414989
1.576817989 1.57546401 1.571624041 1.572636008
1.57000196 1.568976045 1.569291949 1.569571018
1.581068039 1.57931304 1.577916026 1.57843101
1.573557019 1.568127036 1.569232941 1.571727037
1.560495973 1.560119033 1.559612989 1.559713006
1.580675006 1.579769015 1.576385975 1.57770896
1.56875205 1.565245986 1.568423033 1.567438006
1.575602055 1.572589993 1.572198987 1.570927978
1.579988003 1.574985981 1.576442003 1.576588988
1.573945045 1.570400953 1.569372058 1.56942904
1.568055987 1.564877033 1.563992977 1.566707015
1.575961947 1.575402021 1.572743058 1.574262977
1.57842195 1.577636003 1.577057004 1.577728987

Posted 3-Mar-14 3:17am

FarhanShariff

Updated 3-Mar-14 23:59pm

v9

Add a Solution

4 solutions

Solution 2

You can use DataView.Sort[^] property.
Look at the example[^].

C#

// Create DataView
DataView view = new DataView(yourDataTable);

// Sort by Program column in ascending order
view.Sort = "Program ASC";

-KR

Posted 3-Mar-14 3:22am

Krunal Rohit

Comments

FarhanShariff 3-Mar-14 9:25am

Will this sort the data in Memory

Krunal Rohit 3-Mar-14 9:27am

Why would you want to sort it in the memory ? I mean of course it would, but only for the some time. Let's say if you're not posting back your page or refreshing.

-KR

Krunal Rohit 3-Mar-14 9:28am

But if you want to use it for the further use, you can create clone of it.

-KR

FarhanShariff 4-Mar-14 5:10am

http://www.codeproject.com/Questions/738436/Sorting-Columns-and-find-Standard-Deviation

Solution 1

Have you tried it ?
Try yourself then ask question if any problem you faced. ok.

Look the link for help:

http://stackoverflow.com/questions/9107916/sorting-rows-in-a-data-table[^]

Thanks!

Posted 3-Mar-14 3:21am

Member 10510822

Solution 4

For DataTable Try This

DataTable dt = cls.Getdata();
dt.DefaultView.Sort = "ColumnName ASC/DESC";

Posted 4-Mar-14 0:46am

GaneshKale22

Comments

FarhanShariff 4-Mar-14 9:05am

please be more general column names are not to be considered how to loop column one after the other

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amalraj Ramesh · Accepted Answer · 2014-03-03T04:54:00

Solution 3

Try this

DataView dataview = ft.DefaultView;
dataview.Sort = "ColumName";
DataTable dt = dataview .ToTable();

Posted 3-Mar-14 4:54am

Amalraj Ramesh

Comments

FarhanShariff 4-Mar-14 6:00am

how to use sort by not using column names.I mean there are 3000 column.column's names change

Amalraj Ramesh 4-Mar-14 6:05am

Use like this

DataView dataview = dtright.DefaultView;
dataview.Sort = dtright.Columns[0].ColumnName;
DataTable dt = dataview.ToTable();

FarhanShariff 4-Mar-14 7:07am

what does dtright.DefaultView stand for

Amalraj Ramesh 4-Mar-14 7:14am

DataView dataview = ft.DefaultView;
dataview.Sort = ft.Columns[0].ColumnName;
DataTable dt = dataview .ToTable();

Amalraj Ramesh 4-Mar-14 7:42am

dt.DefaultView.Sort = "ColumnName ASC/DESC";

FarhanShariff 4-Mar-14 8:00am

index out of range Exception

FarhanShariff 4-Mar-14 7:43am

how to loop ColumnsName one after the other

Amalraj Ramesh 4-Mar-14 8:25am

for (int loop = 0; loop < ft.Columns.Count; loop++)
{
DataView dataview = ft.DefaultView;
dataview.Sort = ft.Columns[loop].ColumnName;
DataTable dt = dataview .ToTable();
}

FarhanShariff 4-Mar-14 8:34am

I am comparing two tables and once the tables are compared I have to build a new table and then sort it and return the sorted table

Comparing table1 and table2 and I have succesfully built table3.
Now I have to sort table3

private static DataTable CompareTwoDataTable(DataTable table1, DataTable table2)
{
DataTable table3 = new DataTable();
DataRow dr = null;

for (int i = 0; i < table1.Rows.Count; i++)
{
string col = table1.Rows[i]["Par Name"].ToString();
if (table2.Columns.Contains(col))
{
if (!table3.Columns.Contains(col))
{
table3.Columns.Add(col, typeof(string));
}

for (int j = 0; j < table2.Rows.Count; j++)
{
if (table3.Rows.Count != table2.Rows.Count)
{
dr = table3.NewRow();
table3.Rows.Add(dr);
}
table3.Rows[j][col] = table2.Rows[j][col].ToString();
}
}
}

for (int loop = 0; loop < table3.Columns.Count; loop++)
{
DataView dataview = table3.DefaultView;
dataview.Sort = table3.Columns[loop].ColumnName;
DataTable dt = dataview.ToTable();

}

return dt;//Error Not in the current context how to return the sorted table in this case dt
}

Amalraj Ramesh 4-Mar-14 9:28am

replace this

private static DataTable CompareTwoDataTable(DataTable table1, DataTable table2)
{
DataTable table3 = new DataTable();
DataTable dt = new DataTable();
DataRow dr = null;

for (int i = 0; i < table1.Rows.Count; i++)
{
string col = table1.Rows[i]["Par Name"].ToString();
if (table2.Columns.Contains(col))
{
if (!table3.Columns.Contains(col))
{
table3.Columns.Add(col, typeof(string));
}

for (int j = 0; j < table2.Rows.Count; j++)
{
if (table3.Rows.Count != table2.Rows.Count)
{
dr = table3.NewRow();
table3.Rows.Add(dr);
}
table3.Rows[j][col] = table2.Rows[j][col].ToString();
}
}
}

for (int loop = 0; loop < table3.Columns.Count; loop++)
{
DataView dataview = table3.DefaultView;
dataview.Sort = table3.Columns[loop].ColumnName;
dt = dataview.ToTable();

}

return dt;//Error Not in the current context how to return the sorted table in this case dt
}

FarhanShariff 4-Mar-14 9:43am

dt not returned to main

stevefer 24-Dec-14 1:43am

I googled a lot of pages that came up with all sorts of answers. This one was the shortest and easiest. Thanks so much for the simplicity.