public static DataTable GetCustomers()
{
DataTable dataTableCustomers = new DataTable();
using (OleDbConnection connection = ConnectionRepository.GetDataConnection()) {
OleDbDataAdapter adapter = new OleDbDataAdapter(string.Empty, connection);
adapter.SelectCommand.CommandText = "SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [Country], [City] FROM [Customers]";
adapter.Fill(dataTableCustomers);
}
return(dataTableCustomers);
}
public static DataTable GetOrders(string _customerID)
{
DataTable dataTableOrders = new DataTable();
using (OleDbConnection connection = ConnectionRepository.GetDataConnection()) {
OleDbDataAdapter adapter = new OleDbDataAdapter(string.Empty, connection);
adapter.SelectCommand.CommandText = string.Format("SELECT [OrderID], [CustomerID], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipCountry], [ShipPostalCode], [ShippedDate] FROM [Orders] WHERE [CustomerID] = '{0}'", _customerID);
adapter.Fill(dataTableOrders);
}
return(dataTableOrders);
}