Sorting columns in a DataTable

Question

0.00/5 (No votes)

See more:

My question is:

Can a DataTable have sorting columns. I want to click on the column headers of my GridView that is being populated by a Fill DataTable code. Every time I try to look up Sorting columns they use a DataSet code.

If anyone knows of a tutorial or just an answer if this can be done I would really appreciate it.

Thanks.

Posted 15-Nov-13 4:50am

Commish13

Add a Solution

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-11-15T05:31:00

Solution 1

DataSet is just a collection of DataTables.

Unless you are using multiple DataTables, you can always use one DataTable to populate GridView.

Posted 15-Nov-13 5:31am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Commish13 15-Nov-13 12:06pm

I populated the GridView but now I'm trying to make the columns sort by clicking on the header. Do you know of any tutorials or have code that could help me make this possible?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-Nov-13 23:39pm

Have you searched in Google? There are many awesome articles. Do a search. If you can't find, let me know here.

Commish13 16-Nov-13 10:34am

Yes. But every time I try to find something the code is using a DataSet. My code is only displaying records using a DataTable in a GridView. Also I don't want to use a View State code because I'll be editing the records.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Nov-13 9:42am

Okay see the below examples.

1. Sorting a GridView bound to a DataTable[^]
2. How to Perform Sorting in Gridview in ASP.NET[^]
3. How to convert a GridView to DataTable and sort the DataTable?[^]
4. GridView.Sorting Event[^]

Commish13 17-Nov-13 18:22pm

I thank you for your reply but, These examples use a ViewState. I'm using a Filter/Search feature on my GridView so every time I filter then Sort the column it clears out my Filter results.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Nov-13 0:47am

Look, everything you want or need, exactly that will not be available on internet.
Sometimes you have to use your understanding to solve that. I can again search for you that.
It might be available. Please search on Google.

The concept is just replace DataSet with DataTable if you have only one Table. That's all.

Otherwise, please post the code where exactly you are not able to switch DataSet to DataTable.
I need to check that.

I can also see that have rejected this answer. No problem with that. You can anytime ask me the Queries and I will answer as far as I can.

Commish13 18-Nov-13 10:50am

I really wasn't trying to find the exact code I need but, I'm trying to find a Sort Code that does NOT use a ViewState. Reason being, I have a Gridview that has a Filter/Search feature so every time I try to Sort my Filter results the ViewState displays the non filter page then Sorts the column. I did post a code that I was trying to use, but I didn't get any response back of why the code wasn't working.This is the link to my post:

http://www.codeproject.com/Questions/683258/GridView-Sorting-without-DataSource