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); }