I am trying to use drop down editor for editing a child column. I followed the example give in the video below.
http://news.infragistics.com/aspnet/media/p/182701.aspx
The dropdown does show when adding or editing a child row but the drop down is not populated. does anyone have any clue if this supposed to work. I check the datasource and it's fine.
Yes. It does work. I have a grid that has drop downs in four of the columns. Make sure you have the
DropDownProvider configured correctly. And, make sure it's linked to the
<
ig:EditingColumnSetting....>
tag for the field.
Note that this is in a child row. below is the code for editor and binding. Am I missing something???? If this work it will halp me a lot, else need to redisgn and find another solution.
Columns><ig:BoundDataField DataFieldName="SizeName" Key="SizeID"><Header Text="SizeName" /></ig:BoundDataField></Columns>
...
<EditorProviders><ig:DropDownProvider ID="ddlSize"><EditorControl DataKeyFields="SizeID" DataSourceID="SqlDSSizeDropDown" DropDownContainerMaxHeight="200px"EnableAnimations="False" EnableDropDownAsChild="False" ValueField="SizeName"Width="100px"><DropDownItemBinding ValueField="SizeName" /></EditorControl></ig:DropDownProvider></EditorProviders>
ig:EditingCore><Behaviors><ig:CellEditing><ColumnSettings><ig:EditingColumnSetting ColumnKey="SizeID" EditorID="ddlSize" /></ColumnSettings></ig:CellEditing><ig:RowAdding><ColumnSettings><ig:RowAddingColumnSetting ColumnKey="SizeID" EditorID="ddlSize" /></ColumnSettings></ig:RowAdding></Behaviors></ig:EditingCore>
Hi,
I just checked with a DropDownProvider bound to an AccessSource in a child band with the grid having load on demand. I saw the data in the drop down. Your DropDownItemBinding does not have a TextField set, so that could be why yours is blank. Try setting that to SizeName and try again.
<DropDownItemBinding ValueField="SizeName" TextField="SizeName" />
Let us know if it works.
regards,David Young
Thanks for the reply, that fixed the problem of showing the data in the dropdown. But I have another problem, I am not able to save the changes, If I change the value it updates the row but not the database. Below are the changes I made, I think I am not putting the SizeID and SizeName correctly. Also why Do i have to specify the DataKeyFields, ValueField and TextField twice?
Assuming you are working with a datasource that will automatically update, what you need to do is a server event for EditingCore.RowUpdating. It doesn't have to have any code in it, but must be defined for the Hierarchical DataGrid. If you want it to update as soon as you exit edit mode, attach a client handler to exited edit mode for cell editing and put a commit() statement in there. Otherwise, define a rowupdating client handler and then it will go back to the server when the active row changes.
Let us know if you need more specific help.
regards,Dave
yeah I tried this but there is no luck. I even put a save button on the page to trigger a post back and comit from the grid but that's not updating the database either.
Is there a way to get a simple sample project that demonstrates this functionality? I can see what I am doing wrong more easily.
It's just a parent child relational data where the parent is a product and the child table is sdifferent sizes (selectable from the size table). I need something really simple to see this working.
thanks
Hi, any luck with this?
I have a similar situation where I am trying to have Save button to do the actual save. I tried to retrieve the changed column values, but always got the values that were on initial load.
When I added a OnRowUpdating event to the grid, it did not return to the server at all. Did I miss something or is there any alternate way of doing this.
Thanks