Hello: I'm working in Visual Studio 2012 and am creating a new website. I have a form that contains a formview control.
I need to have a dropdown that needs to populate from an sql table (table1). It will also allow users to enter new values.
If they select from an existing value, when saving, it will be inserting into a different table (table 2) then the one which it's populating from.
If the user is entering a new value into the dropdown, I will need it to insert the text into table 1 and after, use the new id it creates when inserting to insert into table 2.
I'm hoping that the combobox will be able to do all this so I'm giving it a try.
So far, I configured the combobox to populate from a sql server lookup table. Because the control will need to allow the user to enter new values so I set the dropdownstyle to simple.
I am having troubles however, figuring out how to configure it so that if the user enters a new value ...
Go to the complete details ...