The main purpose of the RenderModes are to rendered a different structure and Style-sheets for the controls, and they are mainly affecting the visual appearance or behavior.
About the issue, I believe it has something to do with the data source bound to the DropDownList versus the data source bound to the Grid. We've experienced a similar issue, if a ComboBox or DropDownList has multiple values of the same type, then no item will be selected.
You can try isolating the issue by trying the steps below:
Remove all columns except the one with the issue.
Try setting both the DataValueField and DataTextField properties of the DropDownList to be the same, as "fundingsourcename"
Try replacing the RadDropDownList with an ASP DropDownList and confirm the same issue happens. Of course you will also need to change the SelectCommand in the SqlDataSource control. Try something like "SELECT DISTINCT [fundingsourcename] FROM [Budget2013].[dbo].[vwRegistrationCPListWithFundingInfo]"
Extract the DISTINCT values of fundingsourcename column from the "vwRegistrationLineltems" table and compare that to the DISCTINCT values of fundingsourcename column in the "vwRegistrationCPListWithFundingInfo" table. Check if the vwRegistrationLineltems Table has some fundingsourcename values that the "vwRegistrationCPListWithFundingInfo" does not. Since the Grid is trying to find and select a DropDownList item by the text property, which might not exist in the DropDownList's data source, in that case it will not select anything.
You can find attached a sample project which uses a DataTable with dummy data to test this scenario. It would be very helpful if you could modify this sample to produce the error and send it back to us. We can then see what is causing the issue and help resolve it.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.