private void mnuReport_Click(object sender, RoutedEventArgs e) { try { DataModel.IISM_Dataset.WarehouseDataTable dt = new DataModel.IISM_Dataset.WarehouseDataTable(); DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter adpt = new DataModel.IISM_DatasetTableAdapters.WarehouseTableAdapter(); adpt.Fill(dt); var qry = from i in dt select new { WhID = i.WhID.ToString("00"), i.WhDesc, i.Notes }; Classes.FillDataGridcs._lst.Clear(); Classes.FillDataGridcs.DataGridName = "Warehouses"; foreach (var item in qry) { Classes.FillDataGridcs.AddElements(item); } dt.Dispose(); adpt.Dispose(); IISM.DataGrid.TemplateDataGrid OpenW = new IISM.DataGrid.TemplateDataGrid(); OpenW.Show(); } catch (Exception) { } }
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(); }