Validation Rules for Strings

Question

Validation Rules for Strings

RONALD BEAUMAN 81

I have a question regarding validation rules for strings. Normally, a validation rule evaluates input as it is typed. However, I would like to queue-up the input, and at the end of cell entry, validate the string against a database. Can this be done?

Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-07-30T07:55:13.79+00:00

Hi,@ PeterEberlein-5570. I don't quite understand queuing the input and validating the string against the database at the end of the cell entry. What does it mean specifically, could you give me an example?
RONALD BEAUMAN 81 Reputation points

2021-07-31T02:07:36.053+00:00

I would like to take a part number and validate it against a part master within a database from within a validation rule. Can I do it in a cell-level validation or do I have to do it in a row-level validation?
Hui Liu-MSFT 48,711 Reputation points Microsoft External Staff

2021-08-03T09:21:51.52+00:00

Hi,@ PeterEberlein-5570. Did you use some knowledge and content from wpf? How does your input data establish a connection with the database? Could you show some relevant code and data? And does the meaning of cell-level and row-level correspond to individual cell values and multiple values in a single row?

RONALD BEAUMAN 81

I have included a snippet of code that illustrates what I am trying to do. While the code doesn't work, it does show the intended logic.

public class PartAmtValidationRule : ValidationRule
{
    public string MustEndWith = "\t";

    public override ValidationResult Validate(object value, System.Globalization.CultureInfo cultureInfo)
    {
        MessageBoxResult result;

        MySqlDataReader readin3 = null;

        MySqlConnection con3 = null;

        MySqlCommand cmd3;

        bool readresult3;

        string str3;
        string database_name3;
        string partstat;
        string content;

        string acct_ID = MENUSELECT.aid;
        string golden = MENUSELECT.golden;

        var parm = value as string;

        content = parm.ToString();

        if (parm.EndsWith(MustEndWith))
        {
            content = content.Substring(0, content.Length - 1);

            (retrieve the part record)

            if (!readresult3)
            {
                result = MessageBox.Show("Part number is not on file.  Please re-enter.", "", 
                      MessageBoxButton.OK, MessageBoxImage.Error);

                readin3.Close();

                con3.Close();

                return new ValidationResult(false, null);
            }
            }

            readin3.Close();

            con3.Close();
        }

        return new ValidationResult(true, null);
    }
}