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