How to get Sort Expression of datatable

Question

0.00/5 (No votes)

See more:

Hi All,

I have a datatable How can I can I get SortExpression of Datatable
Exmple Like

C#

DataTable data = objAllDetail.Search();

How can I get SortExpression of data please help

Thanks

Posted 29-Oct-12 0:29am

Sahil sharma

Updated 29-Oct-12 0:35am

Nelek

v2

Add a Solution

Comments

vivektiwari97701 29-Oct-12 7:10am

ur qstn is not clear ...can u explain more
i.e.
what type of object objAllDetail is??

2 solutions

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)

MT_ · Answer 1 · 2012-10-29T02:22:00

Solution 1

Use following expression

C#

Datatable.DefaultView.Sort = "ColumnToSortOn ASC";

Hope that helps.
-Milind

Posted 29-Oct-12 2:22am

MT_

Bitla Phanindra · Answer 2 · 2012-10-29T02:22:00

Try something like this,

C#

void Sort_Grid(Object sender, DataGridSortCommandEventArgs e)
      {
         // Retrieve the data source from session state.
         DataTable dt = (DataTable)Session["Source"];

         // Create a DataView from the DataTable.
         DataView dv = new DataView(dt);

         // The DataView provides an easy way to sort. Simply set the 
         // Sort property with the name of the field to sort by.
         dv.Sort = e.SortExpression;

         // Re-bind the data source and specify that it should be sorted
         // by the field specified in the SortExpression property.
         ItemsGrid.DataSource = dv;
         ItemsGrid.DataBind();
      }

Source [^]