I have decided to put my duplicate part number checking in the business object.  Well, that's where it belongs, anyway, right?

Here is my code:

private void PartsBO_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
{
    if (IsDuplicatePartNumber())
    {
        this.AddBrokenRuleByKey(this.partnum, "DuplicatePartNumber");
    }
}

private Boolean IsDuplicatePartNumber()
{
    SqlCommand mCommand = new SqlCommand();
    mCommand.CommandText = "SELECT COUNT(*) FROM PartsMaster WHERE partnum = @partnum AND partindex != @partindex";
    mCommand.Parameters.Add(new SqlParameter("@partnum", SqlDbType.VarChar));
    mCommand.Parameters.Add(new SqlParameter("@partindex", SqlDbType.Int));
    mCommand.Parameters["@partnum"].Value = this.partnum;
    mCommand.Parameters["@partindex"].Value = this.partindex;
    return ((int)ExecuteScalar(mCommand) > 0);
}

The window will let me know that a rule is broken.  But it does not say which rule, which field, nor does my beautifully crafted message pop up.  How do I get the window to do two things:  1)  Mark the field that is having the problem; and 2)  show my message.

Thanks!
Bill

Hi Bill.

On this line:

        this.AddBrokenRuleByKey(this.partnum, "DuplicatePartNumber");

try this:

        this.AddBrokenRuleByKey(PartsBOFieldNames.partnum, "DuplicatePartNumber");

Hope it helps.

Great!  That helps for part one.  Now, how do I get the window to recognize the localization message involved?  It has the alert icon next to the field now, which alerts the user.  The tooltip looks like it is trying to present my custom message, but it is filled with some coding that will scare the average user.

Thanks, again, Ivan!  You are a big help!
Bill

Hi Bill.

I'm glad it is working, you are welcome.

Regarding the message, I think you should be passing a "Text values" key, not a
"Messages key" from your Messaging Project. Is that the case?

Uh...that was it...

Embarassing.

Hey...at least, I am learning! 

Nothing to feel embarassed at all. I'm really glad it worked for you.

Trent once almost made me wear a chicken suit on one of his classes. How is that for an embarassing situation?

Yeah...but let's lay the foundation as of why...Ivan had offered to all attendees that I buy the beer...or something along those lines...isn't that right, Ivan?

Oh? And how is this is different from your normal dress?

Hum... I was tempted to say that I didn't know what you were talking about, but then I realized I don't have administrative priviledges to delete posts on the forum.

Well, usually I don't wear any...