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(); }
private void mnuReport_Click(object sender, RoutedEventArgs e) { DataModel.IISM_Dataset.ProdInventoryDataTable dt = new DataModel.IISM_Dataset.ProdInventoryDataTable(); DataModel.IISM_DatasetTableAdapters.ProdInventoryTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.ProdInventoryTableAdapter(); adpt.Fill(dt); DataModel.IISM_Dataset.WarehouseDataTable dt2 = new DataModel.IISM_Dataset.WarehouseDataTable(); DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter adpt2 = new DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter(); adpt2.Fill(dt2); DataModel.IISM_Dataset.ProductsDataTable dt3 = new DataModel.IISM_Dataset.ProductsDataTable(); DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter adpt3 = new DataModel.IISM_DatasetTableAdapters.ProductsTableAdapter(); adpt3.Fill(dt3); var qry = from pi in dt join wh in dt2 on pi.WhID equals wh.WhID join p in dt3 on pi.ProdNoID equals p.ProdNoID orderby pi.ProdNoID, pi.WhID select new { WhId = pi.WhID.ToString("00"), wh.WhDesc, ProdNo = pi.ProdNoID.ToString("0000"), p.ProdName, Quantity = Convert.ToDecimal(pi.Quantity) }; Classes.FillDataGridcs._lst.Clear(); Classes.FillDataGridcs.DataGridName = "Products Inventory"; foreach (var item in qry) { Classes.FillDataGridcs.AddElements(item); } dt.Dispose(); adpt.Dispose(); dt2.Dispose(); adpt2.Dispose(); dt3.Dispose(); adpt3.Dispose(); IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid(); OpenW.Show(); }