C#

OleDbConnection clsConnection;
           clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\one.mdb;");
           clsConnection.Open();
           //first table
           WTest1.oneDataSet f_table = new WTest1.oneDataSet();
           OleDbDataAdapter dAdapter = new OleDbDataAdapter("SELECT * FROM first", clsConnection);
           dAdapter.Fill(f_table, "first");

           //second table
           WTest1.oneDataSet s_table = new WTest1.oneDataSet();
           OleDbDataAdapter dAdapter1 = new OleDbDataAdapter("SELECT * FROM second", clsConnection);
           dAdapter1.Fill(s_table, "second");

<br />
Runtime Error: Syntax Error in FROM Clause

List<post> list = Posts.FindAll(delegate(Post p)
{
     return (p.DateCreated.Date >= dateFrom && p.DateCreated.Date <= dateTo);});
}
</post>

List<sales> list = Sales.FindAll(delegate(Sales s)
{
      //code would go here, but not sure how to do this.
} 
</sales>