private void btnGenerate_Click(object sender, EventArgs e) { errorProvider1.Clear(); message1.Clear(); string month = cmbMonth.Text.Trim(); string year = cmbYear.Text.Trim(); DataSet dsReportData = new DataSet(); int columnIndex = 0; string reportStatistics = string.Empty; string message = string.Empty; if (month.Equals("[SELECT]")) { message = MessageManager.GetMessage("44"); errorProvider1.SetError(cmbMonth, message); message1.MessageText = message; grpExpenseStatistics.Visible = false; grpReport.Visible = false; return; } if (year.Equals("[SELECT]")) { message = MessageManager.GetMessage("44"); errorProvider1.SetError(cmbYear, message); message1.MessageText = message; grpExpenseStatistics.Visible = false; grpReport.Visible = false; return; } if (rbnIndividual.Checked) { dsReportData = monthlyReport.MonthlyReportData(month, year, MonthlyReport.ReportType.Individual); } else { dsReportData = monthlyReport.MonthlyReportData(month, year, MonthlyReport.ReportType.ItemWise); } if (dsReportData.Tables[0].Rows.Count > 0) { lblMessage.Text = monthlyReport.GeneralDetails(month, year); lblFinalizeDetails.Text = GetReportFinalizationDetails(month, year); grpExpenseStatistics.Visible = true; grpReport.Visible = true; dgrReport.DataSource = dsReportData.Tables[0]; if (rbnIndividual.Checked) { dgrReport.Columns[0].Visible = false; } columnIndex = rbnIndividual.Checked == true ? 2 : 1; dgrReport.Columns[columnIndex].Width = 150; SetGridStyle(); } else { grpExpenseStatistics.Visible = false; grpReport.Visible = false; MessageManager.DisplayMessage("45", month, year); } }