I am using C#, FormView and SqlDataSource. I have a form with several fields. The form needs to :
a) Inserting the User_Name (from textbox), Password (fromtextbox) and UserType_Id (shared variable set in code behind) into Users table..
b) Retrieve the newly generated User_Id (autonumber) from Users table.
2. Insert the User_Id from the previous table and insert it with the other values (Firstname, lastName, etc) into ANOTHER table Dealers.
Can anyone help with this at all. Any help would be greatly appreciated.