private void cmbRoute_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         if (chkAllRoutes.Checked)
         {
             gvList.DataSource = mySupplier.ListActiveSuppliersOfRoute("%", txtSearchText.Text);
         }
         else
         {
             gvList.DataSource = mySupplier.ListActiveSuppliersOfRoute(cmbRoute.SelectedValue.ToString(), txtSearchText.Text);
         }
     }
     catch { }
 }