Problem with cell validation...

[Sheldon Barr]

I'm using a GridDataBoundGrid and I've added a number of columns using the GridBoundColumn Collection Editor in VS.NET.

One of the columns is bound to a floating point number and I'm trying to use the ValidateValue item to do automatic validation of cells in that column. I have set the item values as follows.

NumberRequired = True
Minimum = 0.01
Maximum = 24

Unfortunetly, this does not have any effect, I can still enter any value into the cells. Is there something else I need to do to get validation working?

Thanks.

[Clay Burch]

This appears to be a bug. Setting these values in the designer did not 'take'. We'll get this fixed.

However, I was able to get these values to 'take' by explicitly setting them in an Form Load event handler with code such as:

//C#
this.gridDataBoundGrid1.GridBoundColumns["Quantity"].StyleInfo.ValidateValue = New GridCellValidateValueInfo(True, 0.01, 1000, "bad number")

'VB.NET
     Me.GridDataBoundGrid1.GridBoundColumns("Quantity").StyleInfo.ValidateValue = New GridCellValidateValueInfo(True, 0.01, 1000, "bad number")

[Sheldon Barr]

Clay, thanks for the workaround, but there seems to be a problem indexing the GridBoundColumn by name. My GridBoundColumn is called 'hoursColumn' in the VS.NET designer and it is the 3rd column (index 2).

The following code returns null.

gridDataBoundGrid1.GridBoundColumns["hoursColumn"]

Whereas this code returns the correct column object.

gridDataBoundGrid1.GridBoundColumns[2]

I'm using this as a workaround to my problem, hope this makes sense.

[Clay Burch]

Is "hoursColumn" the MappingName for your GridBoundColumn, or is it the HeaderText? Is it also the exact case?

Thanks

[Sheldon Barr]

Ok, "hoursColumn" is the design name of the column. I tried using the HeaderText of the column and that worked.

I seem to have run into another problem though. The AllowEnter attribute doesn't seem to work whether I set it through the designer or directly in code. I have a column "notesColumn" with CellType=TextBox and AllowEnter=false but the column still allows newlines to be entered.

What's more, the previous column is the "hoursColumn" I described earlier, has AllowEnter=false, and pressing enter correctly moves the cursor to the next column but inserts a newline there. I have ActivateCurrentCellBehaviour=SelectAll set for the table so this also has the unhappy side-effect of deleting the text in the "notesColumn".

I'd appreciate any guidance you could give me.

[Clay Burch]

Sheldon,

I tried to see this behavior in the attached simple sample. The first 2 columns are text columns and they both have AllowEnter = False, but I don't see this problem. Maybe you could spot some difference between this sample and what you are doing?

Clay

[Tom Le Blanc]

Is there any way to short-circut the ValidateValue.NumberRequired to allow for an empty cell?

e.g. If a user enters a value in a validated cell and realizes it's the wrong cell, but doesn't want a zero in the cell.

Do you have any sample code (VB preferred) on how to roll that using the GridCellValidateValueInfo?

Thanks, Tom