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