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