Display the on sale items from the groceries.mdb database in a DataGrid control. Pick a select statement for choosing which data to display.
SELECT * FROM Groceries; SELECT Item, Price FROM Groceries; SELECT Item, Price FROM Groceries WHERE OnSale=True; SELECT Price, Quantity FROM Groceries WHERE Item="Dog Food"; SELECT Item, Price FROM Groceries WHERE Price>3.00; SELECT Item, Price FROM Groceries WHERE 1.00 <= Price AND Price<=3.50;