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