目的: DataTable 以欄位值排序
處理說明: 1>DataTable 的顯示內容: DataView dv1=new DataView();
dv1=dt1.DefaultView;
dv1=dt1.DefaultView;
dv1.Sort=" Date Asc ";
--> dv1=new DataView(dt1);
--> dv1=new DataView(dt1);
dv1.Sort=" Date Asc";
2>dt.DefaultView.Sort = " Date1 ASC ";
dt = dt.DefaultView.ToTable();
Exampl1:
DataTable _dt = new DataTable();
_dt.Columns.Add("Date", typeof(DateTime)); _dt.Columns.Add("Preferance", typeof(int)); _dt.Rows.Add("30/07/2011", 0); _dt.Rows.Add("02/03/2011", 1); _dt.Rows.Add("10/12/2011", 2); _dt.Rows.Add("01/12/2011", 3); DataView _dv = new DataView(_dt); _dv.Sort = "Date ASC"; for (int i = 0; i < _dv.Count; i++) { Console.WriteLine(Convert.ToDateTime(_dv[i]["Date"]).ToString("dd/MM/yyyy") + "\t" + _dv[i]["Preferance"]); }
dt.DefaultView.Sort = "Parameter_Name";
dt = dt.DefaultView.ToTable();
沒有留言:
張貼留言