C#

private void Form2_Load(object sender, System.EventArgs e)
{
      try
      {			
	   myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\sample_as400.mdb";
 	   myCon.Open();
	   string sqlQuery = "Select * from table_as400";
           myAdp = new OleDbDataAdapter(sqlQuery, myCon);

	   OleDbCommandBuilder myBldr = new OleDbCommandBuilder(myAdp);
	   myAdp.Fill(myTable);					
      }
      catch (OleDbException exceptionObject)
      {
	   MessageBox.Show(exceptionObject.Message, "PIN_PROJECT");
      }
}

		
private void btnReport_Click(object sender, System.EventArgs e)
{
	// Create a CrystalReport1 object
	CLIENT_REPORT myReport = new  CLIENT_REPORT();

	// Set the DataSource of the report
	myReport.SetDataSource(myAdp);

	// Set the Report Source to ReportView 
	crystalReportViewer1.ReportSource = myReport;
}

public class g1
{
  public int OID {get;set;}
  public string Name{get;set;}
  public bool IsActive {get;set;}
}

IQueryable<g1> _all;
_all = GetAll_g1().AsQueryable();

List<g1> partOfAll = _all.where(p => p.IsActive == true).ToList();