dataset数据集排序

Question

dataset数据集排序 按照A字段排序datarow[] drs=dataset.select("1=1","a")我现在想先按照A字段排序,再按照B字段排序,A是第一关键字,B是第二关键字,请问怎么做啊

Answer 1

datarow[] drs=dataset.select("1=1","a","b")

Answer 2

没有看明白
SQL语句的话就是  ORDER BY A DESC,B DESC

Answer 3

不是sql 我是想在数据集里面直接排序不想再数据库中排序

Answer 4

DataTale.Select("1=1","A DESC,B DESC")

Answer 5

var res=from DataRow dr in dataset.Tables[0].Rows orderby (dr["字段A"].ToString()) ascending,(dr["字段B"].ToString())descending select dr ;

Answer 6

你不用怀疑了，你SQL语句怎么写，就怎么样的

Answer 7

datatable.select("1=1","a DESC,b DESC");

Answer 8

DataTable dt = new DataTable();
            dt.Columns.Add("one");
            dt.Columns.Add("two");            DataRow row1 = dt.NewRow();
            row1["one"] = "a";
            DataRow row2 = dt.NewRow();
            row2["one"] = "b";
            DataRow row3 = dt.NewRow();
            row3["one"] = "c";
            DataRow row4 = dt.NewRow();
            row4["two"] = "2";
            DataRow row5 = dt.NewRow();
            row5["two"] = "4";
            DataRow row6 = dt.NewRow();
            row6["two"] = "1";            dt.Rows.Add(row1);
            dt.Rows.Add(row2);
            dt.Rows.Add(row3);
            dt.Rows.Add(row4);
            dt.Rows.Add(row5);
            dt.Rows.Add(row6);
            //DataView dv = new DataView(dt,null, "one desc,two asc", DataViewRowState.CurrentRows);
            DataView dv = new DataView(dt);
            dv.Sort = "one desc,two asc";            Repeater1.DataSource = dv.ToTable();
            Repeater1.DataBind();

Answer 9

dataset.DefaultView.Sort = "a,b"
DataSocre = dataset.DefaultView

Answer 10

http://msdn.microsoft.com/zh-cn/library/system.data.dataview(v=VS.90).aspx
dataview