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

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

Post by Pieter Cou » Thu, 20 Apr 2006 18:29:50


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
 
 
 

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

Post by Ken Tucker » Thu, 20 Apr 2006 19:49:17

Hi,

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

http://www.yqcomputer.com/ (VS.80).aspx

http://www.yqcomputer.com/ (VS.80).aspx

Ken
---------------

 
 
 

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

Post by Pieter Cou » Thu, 20 Apr 2006 20:20:03

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...
 
 
 

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

Post by Otis Mukin » Thu, 20 Apr 2006 20:44:43

On Wed, 19 Apr 2006 13:20:03 +0200, "Pieter Coucke" < XXXX@XXXXX.COM >



Have you tried what Ken suggested??

Good luck with your project,

Otis Mukinfus
http://www.yqcomputer.com/
http://www.yqcomputer.com/
 
 
 

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

Post by Pieter Cou » Thu, 20 Apr 2006 21:29:26

Yes I tried the CellValidating-event, and could check it with a
Typeconverter, but wasn't able to put the old value back when I needed...
 
 
 

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

Post by Onwuka Eme » Fri, 21 Apr 2006 07:12:36

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