sort the datatable by LookupService.countryName

Question

0.00/5 (No votes)

See more:

I would like to sort the datatable by LookupService.countryName
any help would be great

C#

[WebMethod(Description = "Get a list of all the countries.")]
[ScriptMethod]
public CascadingDropDownNameValue[] GetCountries(string knownCategoryValues, string category)
{

    List<CascadingDropDownNameValue> l = new List<CascadingDropDownNameValue>();

    DataTable dt = new DataTable();
    dt.Columns.Add("CCode");
    dt.Columns.Add("CName");

    for (int i = 0; i < LookupService.countryCode.Count(); ++i)
    {
        // cCode is code string array
        // cName is name string array
        dt.Rows.Add(LookupService.countryCode[i], LookupService.countryName[i]);
        //l.Add(new CascadingDropDownNameValue(LookupService.countryName[i], LookupService.countryCode[i]));
    }

    return l.ToArray();
}

Posted 13-Feb-11 14:35pm

macupryk

Add a Solution

Comments

Sandeep Mewara 13-Feb-11 23:50pm

Looks like you used the answer suggested to you yesterday. Did you close that question? If an answer helps and it resolves your issue, you should upvote and mark the answer accepted. It helps you and others in future.

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)

Steve Wellens · Answer 1 · 2011-02-13T15:18:00

You can extract sorted data like this:

DataTable dt = new DataTable();

dt.Columns.Add("CCode");
dt.Columns.Add("CName");

dt.Rows.Add("AAA", "ZZZ");
dt.Rows.Add("BBB", "YYY");
dt.Rows.Add("CCC", "XXX");

DataRow[] Rows1 = dt.Select("", "CCode");
DataRow[] Rows2 = dt.Select("", "CName");

Sreejith Gopinathan · Answer 2 · 2011-02-13T17:45:00

Solution 2

You can sort data table through DataTable.DefaultView

Assuming dt is your data table.

DataView dv = dt.DefaultView;
dv.Sort = "CName ASC";

Posted 13-Feb-11 17:45pm

Sreejith Gopinathan

Updated 13-Feb-11 17:46pm

v2