private void btnGenerateReport_Click(object sender, EventArgs e) { try { int selectedYear = Convert.ToInt32(cmbYear.SelectedItem.ToString()); int?BU = null; var AccountList = new List <Account>(); if (rbBUList.Checked) { BU = Convert.ToInt32(lstBUAcc.SelectedValue); } else { foreach (Account item in lstBUAcc.SelectedItems) { Account a = new Account(); a.AccountID = Convert.ToInt32(item.AccountID); AccountList.Add(a); } } AccountMonthRevenue accMonthRevenue = new AccountMonthRevenue(); DataSet ds; ds = accMonthRevenue.MarginPerEmployeeYTD(BU, AccountList, selectedYear); dgvReportView.AutoGenerateColumns = true; dgvReportView.DataSource = ds.Tables[0]; dgvReportView.AutoResizeColumns(); dgvReportView.Show(); //CallTestMethod(); } catch (Exception ex) { MessageBox.Show("An error occured while generating the report.\nPlease try again in sometime."); } }