将过滤器应用于数据集时，不在gridview中显示数据 [英] Not displaying data in gridview when applying filter to a dataset

问题描述

过滤时我的gridview不显示数据

My gridview is not displaying data when filter

protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection conn=new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Dynacs.accdb");
        OleDbDataAdapter da = new OleDbDataAdapter("select empname,pass,status from employees", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "emp");
        GridView1.DataSource = ds.Tables["emp"].Select("status='in'");
        GridView1.DataBind();
    }

推荐答案

OleDbDataAdapter da = new OleDbDataAdapter("select empname,pass,status from employees", conn);
        DataSet ds1=new DataSet();
        da.Fill(ds1,"emp");
            var datasource = from r in ds1.Tables["emp"].AsEnumerable()
                             where r.Field<string>("status")=="out"
                             select new{empname=r.Field<String>("empname"),status=r.Field<string>("status")};
            GridView1.DataSource = datasource;
            GridView1.DataBind();

这篇关于将过滤器应用于数据集时，不在gridview中显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！