private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.ProducCategoryDataTable dt = new DataModel.IISM_Dataset.ProducCategoryDataTable();
DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter();
adpt.Fill(dt);
var qry = from i in dt
select new
{
ID = i.PCatID.ToString("000"),
i.PCatDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Product Category";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
private void mnuReport_Click(object sender, RoutedEventArgs e)
{
DataModel.IISM_Dataset.ProductsDataTable dt = new DataModel.IISM_Dataset.ProductsDataTable();
DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter();
adpt.Fill(dt);
DataModel.IISM_Dataset.ProducCategoryDataTable dt2 = new DataModel.IISM_Dataset.ProducCategoryDataTable();
DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.ProducCategoryTableAdapter();
adpt2.Fill(dt2);
var qry = from p in dt
join c in dt2 on p.PCatID equals c.PCatID
select new
{
Prodno = p.ProdNoID.ToString("0000"), p.ProdName, p.Price, p.Description,
IsActive = p.Active, SalesTax = p.IVU, p.Cost, PCatID = p.PCatID.ToString("000"), c.PCatDesc
};
Classes.FillDataGridcs._lst.Clear();
Classes.FillDataGridcs.DataGridName = "Products";
foreach (var item in qry)
{
Classes.FillDataGridcs.AddElements(item);
}
dt.Dispose(); adpt.Dispose(); dt2.Dispose(); adpt2.Dispose();
IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid();
OpenW.Show();
}
