I am in the process of trying to complete a web form on Visual Studio 2010. It n
ID: 3631566 • Letter: I
Question
I am in the process of trying to complete a web form on Visual Studio 2010. It needs to be linked to a SQL Server database. I have already created the database on SQL Server, it's called customer. It has fields Last Name, First Name, Address, City, State, Zip, Phone Number, Gender, and Date Account Opened.On the web form, all of the fields are textboxes except for Gender which is a radio button and Date Account Opened which is a calendar.
When a customer enters information in the web form it needs to be inserted into the database. Also, I am not allowed to let the user input CUSTOMER_ID. I need to assign the CUSTOMER_ID and output the CUSTOMER_ID when the user is successfully added using an output parameter.
I am unsure of the steps I need to follow to do this. I am a little fuzzy on how data can be inserted into the database when the user clicks submit. I also can't find any information on how to generate the customer ID and have it show on the web form so the user knows their ID.
Any help or tips on this would be extremely useful. I'm working using Visual Studio 2010. This is object oriented programming. If you could indicate how I would use the toolbox or properties window it would also be appreciated.
Explanation / Answer
Hope this may help you: As your problem definition for the you can set the CUSTOMER_ID to autoincrement in your sql server which you are designing your database... then only the user don't have to put the customer_id since the sql server will handle that task. ------------------------------------------------------ for the connection of your sql server with visual studio is very easy task if you follow the wizard steps for connection your database with the form you defined in your visual studio. i recommend you to follow the msdn site : http://msdn.microsoft.com/en-us/library/h0y4a0f6%28v=VS.80%29.aspx in this site you will find the step by step wizard way to connect your visual studio with the sql server..... wish you good luck...
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.