Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 0.99 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Not displaying data in gridview when applying filter to a dataset
  2. protected void Page_Load(object sender, EventArgs e)
  3.     {
  4.         OleDbConnection conn=new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Dynacs.accdb");
  5.         OleDbDataAdapter da = new OleDbDataAdapter("select empname,pass,status from employees", conn);
  6.         DataSet ds = new DataSet();
  7.         da.Fill(ds, "emp");
  8.         GridView1.DataSource = ds.Tables["emp"].Select("status='in'");
  9.         GridView1.DataBind();
  10.     }
  11.        
  12. OleDbDataAdapter da = new OleDbDataAdapter("select empname,pass,status from employees", conn);
  13.         DataSet ds1=new DataSet();
  14.         da.Fill(ds1,"emp");
  15.             var datasource = from r in ds1.Tables["emp"].AsEnumerable()
  16.                              where r.Field<string>("status")=="out"
  17.                              select new{empname=r.Field<String>("empname"),status=r.Field<string>("status")};
  18.             GridView1.DataSource = datasource;
  19.             GridView1.DataBind();