private void FindingTxNumber() { errorProvider.SetError(txtTxNumber, string.Empty); if (txtTxNumber.Text.Trim().Length > 0) { //string sql = "TxNumber LIKE '%" + txtTxNumber.Text.Trim() + "%'"; //InvtBatchTXF_Header oHeader = InvtBatchTXF_Header.LoadWhere(sql); if (InvtBatchTXF_HeaderEx.IsTxNumberInUse(txtTxNumber.Text.Trim())) { BindingToBeConfirmedList(); } else { errorProvider.SetError(txtTxNumber, "Transfer Number field does not exist!"); } } else { errorProvider.SetError(txtTxNumber, "Transfer Number field cannot be blank!"); } }