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