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; if (cmbReportType.SelectedItem.ToString() == "Highest Salary") { ds = accMonthRevenue.GetHighestSalary(Convert.ToInt32(txtFromNoofPeople.Text), Convert.ToInt32(txtToNoofPeople.Text) , BU, AccountList, selectedYear); } else { ds = accMonthRevenue.GetLowestSalary(Convert.ToInt32(txtFromNoofPeople.Text), Convert.ToInt32(txtToNoofPeople.Text) , BU, AccountList, selectedYear); } dgvReportView.AutoGenerateColumns = true; dgvReportView.DataSource = ds.Tables[0]; dgvReportView.Show(); } catch (Exception ex) { MessageBox.Show("An error occured while generating the report.\nPlease try again in sometime."); } }