I have a simple radgrid that is attached to a SQL database table whose scheme I am not able to alter. There are a number of fields that do not allow NULLS in the database but for my purposes I can allow NULLS for certain fields.
My question is, what is the best way to handle this? there are probably a dozen fields in this grid and the majority are simply text boxes. My first thought was that when the update command is fired to loop through all of the controls to check if they are NULL and if they are to simply make them pass a space. My problem is I am not sure how to do this easily.
Can anyone think of a better way to do this?
Thank you
Adam
My question is, what is the best way to handle this? there are probably a dozen fields in this grid and the majority are simply text boxes. My first thought was that when the update command is fired to loop through all of the controls to check if they are NULL and if they are to simply make them pass a space. My problem is I am not sure how to do this easily.
Can anyone think of a better way to do this?
Thank you
Adam