public DataTable loadRawIngredientData()
{
// create a dbConnection and pass the database name
dbConnection dbConn = new dbConnection("ChocoMambo.accdb");
// create a data table to store the table tblCustomers
DataTable dtb = dbConn.GetDataTable("qryRawIngredientsActive");
return dtb;
}
public DataTable loadSupplierPurchaseData()
{
// create a dbConnection object and pass the database name
dbConnection dbConn = new dbConnection("ChocoMambo.accdb");
// create a DataTable to store the table tblCustomers
DataTable dtb = dbConn.GetDataTable("qrySupplierPurchaseActive");
return dtb;
}
private DataTable loadDataTable()
{
// create a dbConnection object and pass the database name
dbConnection dbConn = new dbConnection("ChocoMambo.accdb");
// create a DataTable to store the table tblCustomers
DataTable dtb = dbConn.GetDataTable("Products");
return dtb;
}