Replies
Thank you for your response. This was helpful information and what I was after!!!
Zdravko,
Thank you for your quick response! I didn't consider changing the insert sql statement to use UPPER on my sqldatasource. For the insert that solution works perfectly. I have to ensure all input goes to upper case when it gets written to the database because a seperate linux process will be consuming the database information and its process code is case sensitive and expects upper case. This is not a process I control.
However, I am faced with the same issue when a row update occurs (cell input must be forced to upper case). So, I changed the sql update statement in the same fashion as for the insert. That takes care of getting the value to upper case in the database table, but the input in the grid cell remains lower case until I perform a rebind on the grid after which the upper case value is displayed. Is the rebind a necessity in this case?
Originally, I was looking for a way to perform the Insert case conversion in the rowAdding event on the client or server side ( I haver tried both ). In the server side RowAdding event everything seems to be readonly that I need to access. On the client side RowAdding event, I set up, I can alter the value of the grid cell, using set_value, but when I press the enter key to commit the new value, I see the conversion change momentarily, on the add row, but it then appears as the original input value, in a new grid row, after a rebind is called. I suspect this has something to do with the cell not being in edit mode when I am trying to alter it in the rowAdding event.