Hello MyPost,

Please feel free to contact me if you are still experiencing issues with this scenario.

Hello Mypost,

Is the value coming as NULL if you try turning of AutoCRUD to debug the CRUD events and the changed value ? A sample illustrating the issue in practice would be greatly appreciated and will allow me to examine this matter in more detail.

Do not hesitate to contact me with any updates or questions.

Thanks for reply, Please look at my below issue.

Hi,

I am using DropDown editor control in grid, I want to update cell value when change the DropDown value.

when i am changing the dropdown value and update my sql table the getting null value error, because my sql column do not allow me to set null value.

when i am updating the value in my table as per changed in dropdowneditor, getting null error, why is this issue coming?

My code is look like that

<ig:BoundDataField DataFieldName="Caption" Key="Id" Header-Text="Caption"
Width="80px" />

<ig:EditingCore BatchUpdating="true">
<Behaviors>

<ig:CellEditing Enabled="true" EditModeActions-EnableF2="true">
<ColumnSettings>
<ig:EditingColumnSetting ColumnKey="Id" EditorID="valProvider" />
</ColumnSettings>
</ig:CellEditing>
</Behaviors>
</ig:EditingCore>

<EditorProviders>
<ig:DropDownProvider ID="statusProvider">
<EditorControl ID="statusEditorCntrl" runat="server" DisplayMode="DropDownList" TextField="Caption"
ValueField="Id" DataKeyFields="Id" Width="80px" DataSourceID="Source" >
</EditorControl>
</ig:DropDownProvider>
</EditorProviders>