ASP.NET DataTable / DataView ( Filtering / Sorting )

 
ASP.NET DataTable / DataView ( Filtering / Sorting )
 

   (必要部份)
 
   using System.Data;
   using System.Data.SqlClient;
 
   private void datatableuse()
   {
 
      DataTable DataTable1 = new DataTable();
      DataColumn DataColumn1;
      DataRow DataRow1;
 
      DataColumn1 = new DataColumn();
      DataColumn1.DataType = System.Type.GetType("System.String");
      DataColumn1.ColumnName = "Player";
      DataTable1.Columns.Add(DataColumn1);
 
      DataColumn1 = new DataColumn();
      DataColumn1.DataType = System.Type.GetType("System.String");
      DataColumn1.ColumnName = "Team";
      DataTable1.Columns.Add(DataColumn1);
 
      DataColumn1 = new DataColumn();
      DataColumn1.DataType = System.Type.GetType("System.String");
      DataColumn1.ColumnName = "League";
      DataTable1.Columns.Add(DataColumn1);
 
      String connectionString1 = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
      SqlConnection con1 = new SqlConnection(connectionString1);
      con1.Open();
 
      String SqlString1 = "SELECT Player AS 'Player', Team AS 'Team', League AS 'League' FROM dbo.View_1";
      SqlCommand cmd1 = new SqlCommand(SqlString1, con1);
      SqlDataReader dr = cmd1.ExecuteReader();
 
      if(dr.HasRows){
         while (dr.Read()){
            DataRow1 = DataTable1.NewRow();
            DataRow1[0] = dr[0].ToString().Trim();
            DataRow1[1] = dr[1].ToString().Trim();
            DataRow1[2] = dr[2].ToString().Trim();
            DataTable1.Rows.Add(DataRow1);
         }
      }
 
      dr.Close();
      con1.Close();
      con1.Dispose();
 
      DataView DataView1 = new DataView(DataTable1);
      DataView1.RowFilter = "Team = 'Chelsea'";
      DataView1.Sort = "Player";
 
      GridView1.DataSource = DataTable1;
      GridView1.DataBind();
 
      GridView2.DataSource = DataView1;
      GridView2.DataBind();
 
   }