Problem with added table in App data Db ASPNETDB.MDF
I am new to C#, ASP.NET, SQL, and LINQ. I am a complete novice trying to find a way to finish my first Web app. I added a table to the ASPNETDB.MDF. I named it User_Signup. I added the fields: UserId, FirstName, LastName, Address1, Address2, City, ZipCode, State, TermsCheckBox, PrivacyCheckBox, BotEmailsCheckBox, PartnerEmailsCheckBox. I did types of nvarchar(50) for all but State, UserId and the check boxes. I did nvarchar(20) for State. I did bit for the check boxes and uniqueidentifier for UserId. Also State is a DropDownList not a TextBox. I added a relationship between the aspnet_Users table and my new User_Signup table. The aspnet_Users UserId is the primary key and the UserId in User_Signup is the foreign key.
It compiles and runs. It creates the new user and updates the aspnet_Users table but it doesn't update my User_Signup table. I have been over it a thousand times and can't figure out what I did wrong. I have searched a ton of forums and 2 reference books. but I am stuck.Please Help!
Also one added question. When I deploy to my web server. Will the connection string be the same except the server name?