mcs/class/System.Web/Test/standalone/datagrid/datagrid-sorting.aspx

   1 <!-- bug 51424 -->
   2
   3 <%@ Page language="c#" %>
   4 <%@ Import Namespace="System.Data" %>
   5 <html>
   6         <body>
   7                 <form runat="server">
   8                         <asp:DataGrid id="DataGrid1" runat="server" />
   9                 </form>
  10         </body>
  11         <script language="c#" runat="server">
  12                 void Page_Load(object sender, System.EventArgs e)
  13                 {
  14                                 DataGrid1.AllowSorting = true;
  15                                 if (!IsPostBack)
  16                                 {
  17                                         DataGrid1.DataSource = createDataTable();
  18                                         DataGrid1.DataBind();
  19                                 }
  20                                 this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
  21                 }
  22                 void DataGrid1_SortCommand(object sender, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
  23                 {
  24                         DataView dv = new DataView();
  25                         dv.Table = createDataTable();
  26                         dv.Sort = e.SortExpression;
  27                         DataGrid1.DataSource = dv;
  28                         DataGrid1.DataBind();
  29                 }
  30                 System.Data.DataTable createDataTable()
  31                 {
  32                         System.Data.DataTable dt = new System.Data.DataTable("Customers");
  33                         System.Data.DataColumn dc = dt.Columns.Add("ID",typeof(int));
  34                         dc.AllowDBNull = false;
  35                         dc.AutoIncrement = true;
  36                         dc.AutoIncrementSeed = 1;
  37                         dc.AutoIncrementStep = 1;
  38                         dc.Unique = true;
  39
  40                         dt.PrimaryKey = new System.Data.DataColumn[] {dc};
  41
  42                         dc = dt.Columns.Add("Name", typeof(String));
  43                         dc.MaxLength = 14;
  44                         dc.DefaultValue = "nobody";
  45                         dc = dt.Columns.Add("Company", typeof(String));
  46                         dc.MaxLength = 14;
  47                         dc.DefaultValue = "nonexistent";
  48
  49                         ArrayList arr = createArrayList();
  50                         IEnumerator items = arr.GetEnumerator();
  51                         items.Reset();
  52                         while(items.MoveNext())
  53                         {
  54                                 DataRow dr = dt.NewRow();
  55                                 dr["Name"] = "n_" + "_" + items.Current;
  56                                 dr["Company"] = "c_" + "_" + items.Current;
  57                                 dt.Rows.Add(dr);
  58                         }
  59                         return dt;
  60                 }
  61
  62                 ArrayList createArrayList()
  63                 {
  64                         ArrayList arr = new ArrayList();
  65                         arr.Add("One");
  66                         arr.Add("Two");
  67                         arr.Add("Three");
  68                         arr.Add("Four");
  69                         arr.Add("Five");
  70                         return arr;
  71                 }
  72         </script>
  73 </html>