按LookupService.countryName对数据表进行排序 [英] sort the datatable by LookupService.countryName

问题描述

我想通过LookupService.countryName对数据表进行排序
任何帮助都很好

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

[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();
}

推荐答案

您可以像这样提取排序后的数据:

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");

您可以通过DataTable.DefaultView
对数据表进行排序
假设dt是您的数据表.

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

You can sort data table through DataTable.DefaultView

Assuming dt is your data table.

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

这篇关于按LookupService.countryName对数据表进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！