I have an XML data source (Main) that I am binding to my gridview. I want one column to be a combobox. I'm using a separate XML file (Options) for the combobox options.
1) When I set the data source for the combobox to the Options dataset, the column is blank. I want it to be the value listed in the Main dataset. The result I seek is that when the grid loads, the values from the Main dataset are loaded. The user can then edit the combobox column by selecting from the drop down that is populated from the Options dataset. How can I achieve this?
2) Obviously, I want to save these back edits back to the main dataset. How can I rebind the column to the Main dataset?