Data validation in DataBound Grid

[Patrick Noble]

1. I have a DataBoundColumn with a TextFormat control linked to a decimal field in a dataset. I am able to restrict entry to single decimal place numeric using the styleinfo, but can''t get rid of the DBNull error message that appears if I type the delete key and then try to leave the field. How can I best deal with this, do I have to handle an event or is there a simpler way just using the designer?

2. My application updates other columns in the same row in a datatable based on entry into specific columns. The result of this is not reflected in the grid until I leave the row. How can I force the grid to update when I leave a cell rather than just the row?

[Patrick Noble]

OK, I see the answer to 2 in another post, use grid.binder.endedit. Just need help with 1 now.

>1. I have a DataBoundColumn with a TextFormat control linked to a decimal field in a dataset. I am able to restrict entry to single decimal place numeric using the styleinfo, but can''t get rid of the DBNull error message that appears if I type the delete key and then try to leave the field. How can I best deal with this, do I have to handle an event or is there a simpler way just using the designer?
>
>2. My application updates other columns in the same row in a datatable based on entry into specific columns. The result of this is not reflected in the grid until I leave the row. How can I force the grid to update when I leave a cell rather than just the row?
>
>

[Administrator]

What version of our code are you using? In the sample below, using 2.0.5.1, I do not see a problem pressing the delete key to empty a decimal cell. What are you doing differently? WindowsApplication2_9386.zip

[Patrick Noble]

My fault. Too embarassed to explain it. >What version of our code are you using? In the sample below, using 2.0.5.1, I do not see a problem pressing the delete key to empty a decimal cell. > >What are you doing differently? > >WindowsApplication2_9386.zip > >