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>
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.
Please note that the updated value may be observed on one of the grid's CRUD events - handling the events of the dropdown provider is not necessary and would not give the desired results due to the order in which events fire.
Do not hesitate to contact me with any updates or questions.
Hello MyPost,
Please feel free to contact me if you are still experiencing issues with this matter.