I have a MS SQL database that needs to be populated using a complicated on-line application form.
What is the best way to do this using visual studio?
The application form is collecting information on organisations and over a wide variety of variables so ideally needs to be over several pages. Also, some of the responses need to come from pre-designated otions. I have created many table in which to store the data - and i know how to display the information using visual studio to update a very simple one page form. What i am struggling with is when i need to collect lots of information and then update the database as a whole. I know that the wizard form in Visual cannot cope with this so how do it do it?!!