c# - how to validate sharepoint list column against ValidationFormula programmatically

Question

I need to validate a string that user submit against SPField.ValidationFormula while adding new record to custom list in c#.

Line to add new record is

SPListItem item = mylist.Items.Add();

I have formula in

column.ValidationFormula

and my string to validate is in this variable

mystringtovalidate

How can I validate mystringtovalidate against column.ValidationFormula then if is valid I'll do item.Update();

Answer 1

You can use following pattern

try {
    item.Update();
}
catch(SPListDataValidationException ex) {
    //ex.Message
}

https://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistdatavalidationexception_members(v=office.14).aspx