Hi everyone,
I have problem with dropdown in WebDataGrid, here is the thing, I have set an SqlDataSource to WebDataGrid, the data source has 3 columns as following:
id_no , fname , clocation in a table named e_locations
everything is working fine and the data is shown when I run the project, but I want to use dropdown in the columns (clocation), the drop down should view data from another table has all locations named "locations" and the column name is "location", so here is what I have done, I create a new SqlDataSource for the table locations, I added a DropDownProvider and set the DataSource ID to SqlDataSource of the locations, and then I went to Edit Behaviors>Cell Editing > Column Settings, I have added an item, and columnKey was set to "clocation", and set the EditorID to my provider! now when I run the project nothing is shown, nothing at all, but when I remove the provider it works fine!! any help please?
by the way, I am getting this warning when I add the provider!
Warning Validation (ASP.Net): Element 'EditorControl' is missing required attribute 'runat'.
Hello Osama,
I have created a small sample trying to reproduce the described behavior, which you will find attached. In my sample I am using SQL data source with DropDownProvider.
Please test it on your side and let me know how it behaves. If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me along with steps to reproduce.
Having a working sample on my side, which I can debug, is going to be very helpful in finding the root cause of this behavior.
Thank you for your cooperation.
Looking forward to hearing from you.
Regards,Martin
7183.Sample.zip
I'm sorry for taking this long to verify your answer, your answer has helped me and resolved my issue, I'm really thankful for your help and support.