/// <summary>
 /// Function to fill the grid
 /// </summary>
 public void Gridfill()
 {
     try
     {
         DataTable dtbl = new DataTable();
         AccountLedgerSP spAccountLedger = new AccountLedgerSP();
         if (cmbAccountGroup.Text.Trim() == string.Empty)
         {
             cmbAccountGroup.Text = "All";
         }
         if (txtMobile.Text.Trim() == string.Empty)
         {
             txtMobile.Text = "All";
         }
         if (txtPhone.Text.Trim() == string.Empty)
         {
             txtPhone.Text = "All";
         }
         if (txtEmail.Text.Trim() == string.Empty)
         {
             txtEmail.Text = "All";
         }
         if (txtLedgerName.Text.Trim() == string.Empty)
         {
             txtLedgerName.Text = "All";
         }
         if (txtMobile.Text == "All")
         {
             txtMobile.Text = string.Empty;
         }
         if (txtPhone.Text == "All")
         {
             txtPhone.Text = string.Empty;
         }
         if (txtEmail.Text == "All")
         {
             txtEmail.Text = string.Empty;
         }
         if (txtLedgerName.Text == "All")
         {
             txtLedgerName.Text = string.Empty;
         }
         dtbl = spAccountLedger.PartyAddressBookSearch(cmbAccountGroup.Text, txtMobile.Text, txtPhone.Text, txtEmail.Text, txtLedgerName.Text);
         dvgPartyAddressBook.DataSource = dtbl;
     }
     catch (Exception ex)
     {
         MessageBox.Show("PAB:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }