DataGridView Cell Previous Value

[Roach]

VB.NET 2005 2.0 Framework application is using a DataGridView for SQL
data access and user data entry. As part of exception/error handling,
the app wants to advise the user when he/she enters a value into a DGV
field that is inappropriate; for example, an alpha character in a cell
containing an integer value. When the user types in the alpha and
hits enter, BeginEdit fires off, realizes the cell is dirty, and can
see the previous/old cell .Value, but not the newly entered character/
value. DataError then promptly frags the entry (interdicting
CellValueChanged execution), but again can't say what value/
character(s) the user entered that were inappropriate. Since the
entered characters persist on the DGV (until .CancelEdit and .EndEdit
are called), they must be somehow accessible; can anyone explain how
to grab them?

Thanks for your help!

 

[Brendon Bezuidenhout]

Hey Roach,

If you handle validation on a cellular level you can access the formatted
value or cancel the validation and value being changed at all...

look into the DataGridViewCellValidatingEventArgs and the CellValidating()
method of the DGV:
http://msdn2.microsoft.com/en-us/li...ewcellvalidatingeventargs_members(VS.90).aspx

HTH
Brendon