/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { if (cmbCashBankAC.Text.Trim() == string.Empty) { if (cmbCashBankAC.DropDownStyle != ComboBoxStyle.DropDown) { cmbCashBankAC.DropDownStyle = ComboBoxStyle.DropDown; } cmbCashBankAC.Text = "All"; } DataTable dtbl = new DataTable(); SalaryVoucherMasterSP spSalaryVoucherMaster = new SalaryVoucherMasterSP(); dtbl = spSalaryVoucherMaster.MonthlySalaryRegisterSearch(Convert.ToDateTime(txtVoucherDateFrom.Text.Trim().ToString()), Convert.ToDateTime(txtVoucherDateTo.Text.Trim().ToString()), Convert.ToDateTime(dtpSalaryMonth.Value.ToString("MMMM yyyy")), txtVoucherNo.Text.Trim(), cmbCashBankAC.Text.ToString(), cmbVoucherTypeName.Text.ToString()); dgvMonthlySalaryRegister.DataSource = dtbl; if (cmbCashBankAC.Text == "All") { cmbCashBankAC.Text = string.Empty; } } catch (Exception ex) { MessageBox.Show("MSR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }