private void button1_Click(object sender, EventArgs e) { Queue <InventoryItem> listInventoryItems = PartNumberRepository.GetAllNonZeroItems(); reportViewer1.LocalReport.DataSources.Clear(); //clear report reportViewer1.LocalReport.ReportEmbeddedResource = "LiveStock.rdlc"; // bind reportviewer with .rdlc Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("LiveStockDataset", listInventoryItems.ToList()); // set the datasource reportViewer1.LocalReport.DataSources.Add(dataset); dataset.Value = listInventoryItems.ToList(); reportViewer1.LocalReport.Refresh(); reportViewer1.RefreshReport(); }
private Queue <InventoryItem> GetDataSourceFromDb() { Queue <InventoryItem> listInventoryItems = new Queue <InventoryItem>(); try { listInventoryItems = PartNumberRepository.GetAllNonZeroItems(); } catch (Exception exp) { objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error GetDataSourceFromDb - " + exp.Message + " StackTrace:- " + exp.StackTrace); MessageBox.Show("Error while fetchig Data from DB", "Error in DB Access", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(listInventoryItems); }