以 SQLDataReader + DataView Filter 出 DataTable Column 上特定字串

 
以 DataView Filter 出 DataTable Column 上特定字串
 

   DataView.aspx
 
   using System.Data.SqlClient;
 
   private void GetRecord()
   {
 
      String connectionString = "<Connection String>";
      SqlConnection con1 = new SqlConnection(connectionString);
      con1.Open();
 
      String SqlString1 = "SELECT username, password FROM dbo.Users";
 
      SqlCommand cmd1 = new SqlCommand(SqlString1, con1);
 
      SqlDataReader dr = cmd1.ExecuteReader();
 
      DataTable InfoDataTable = new DataTable();
 
      InfoDataTable.Load(dr);
      InfoDataTable.Columns[0].ColumnName = "User Name";
      InfoDataTable.Columns[1].ColumnName = "User Password";
 
      DataView InfoDataView = new DataView(InfoDataTable);
 
      InfoDataView.RowFilter = "[User Password] = '123456'";
 
      this.GridView1.DataSource = InfoDataView;
      this.GridView1.DataBind();
 
      cmd1.Dispose();
      con1.Dispose();
 
   }