update the db with null

[Alyssa]

Hi,
I want to update the db with null value if the user leaves a column value empty. How to obtain this? During edit and update i want to convert empty data to null.

[Princy]

Hi Alyssa,

You can try the following code snippet in the UpdateCommand events of the RadGrid.

C#:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
 {
    if (e.Item is GridEditableItem)
    {
        GridEditableItem edit = (GridEditableItem)e.Item;
        string id =(edit["ColumnUniqueName"].Controls[0] as TextBox).Text;
        if (id == string.Empty)
        {
          id = null;
        }
       // Code to Update id to DB
    }
 }

Thanks,
Princy