How to prevent "Input string was not in a correct format" in DataGridView

[Pieter Coucke]

Hi,

When a user types a non numeric-value in a numeric column in a DataGridView,
and he tries to leave the cell, he gets this "Input string was not in a
correct format."-exception.

Is there a (nice) way to get rid of this exception? And just put a "0" in
the place? Or somehow trigger this single exception (does exceptions have a
unique type-number?) and do some appropriate actions?

Thanks a lot in advance,

Pieter

[Ken Tucker [MVP]]

Hi,

I would use the cellvalidating event to check the format but
there is a dataerror event for dealing with that messagebox.

http://msdn2.microsoft.com/en-us/lib...ng(VS.80).aspx

http://msdn2.microsoft.com/en-us/lib...or(VS.80).aspx

Ken
---------------
"Pieter Coucke" <pi**********@hotmail.com> wrote in message
news:eG**************@TK2MSFTNGP05.phx.gbl...

Hi,

When a user types a non numeric-value in a numeric column in a
DataGridView, and he tries to leave the cell, he gets this "Input string
was not in a correct format."-exception.

Is there a (nice) way to get rid of this exception? And just put a "0" in
the place? Or somehow trigger this single exception (does exceptions have
a unique type-number?) and do some appropriate actions?

Thanks a lot in advance,

Pieter

[Pieter Coucke]

Thanks. i'm now using a "If TypeOf e.Exception.InnerException Is
System.FormatException Then" in the DataError. but isn't there a way to
correct the value? Put the old value in the cell? Because now my users are
getting really confused: they go to another tab (and see this tab), but the
error is pointing to the previously used tab...

[Onwuka Emeka]

You might want to put a validator to validate the entry so the form is not
posted to the server with invalid data

"Pieter Coucke" <pi**********@hotmail.com> wrote in message
news:eG**************@TK2MSFTNGP05.phx.gbl...

Hi,

When a user types a non numeric-value in a numeric column in a
DataGridView, and he tries to leave the cell, he gets this "Input string
was not in a correct format."-exception.

Is there a (nice) way to get rid of this exception? And just put a "0" in
the place? Or somehow trigger this single exception (does exceptions have
a unique type-number?) and do some appropriate actions?

Thanks a lot in advance,

Pieter