Null values on edit form

[Daniel]

If for example I have a table in my database looking like that:
-------------------------------------------------
TEST
-------------------------------------------------
ID         int                     autoincrement PK
A          nvarchar(20)
B          nvarchar(10)    null
C          int                     null
-------------------------------------------------

So field A always require a value, but fields B and C can have nulls.
Now if I create simplest linq data source, and radgrid using that data source to select/insert/edit data in that database.
Everything is nice, except that If on edit/insert forms I leave field for B empty, in database it will input empty string instead of null. That would still be ok, I could live with it. But if I leave field for C (integer) empty, I will get an exception that the value from the field can't be converted into int32.

So my question is: how can I force radgrid to replace empty values on edit/insert form with NULL?

Thanks,

Daniel

[Shinu]

Hello Daniel,

Check the following forum thread which discusses similar scenario.
What is the CORRECT way to handle null values in a RadGrid.

Also check the following help article which explains how to handle db null values.
Handling Null Database Values Using Data Source Controls.

Thanks,
Shinu.