Inserting Records to SQL Server with Visual Studio

admin

Administrator
Staff member
Hello,

I am new to ASP.net and Visual Studio.

I have created a new ASP.NET Web Application and have started with a
simple form.


I have created a simple test database that will store a person's first
and last name and their SSN. The primary key is an autonumbered field.


So I have made a connection in Visual Studio with the sql data adapter
and have dragged 3 text boxes on the web form.


For each text box, I have set the data source to be the field in the
database or (dataset)


So now I have dragged a button on to the form.


Do I put the insert, update, and delete code in the button properties?


Can visual studio.net generate the code to do this, or do I manually
have to write to code to do this. If it has to be done manually, could
someone please post sample code on how to do this? And where would I put that code in visual studio.


My text box names are f_name, l_name, and ssn.
And the fields in the database are labeled the same way.


Also does anyone know of a good book or website that shows the basics of webforms with visual studio.net (inserting records, updating records, deleting records)



Thanks in advance for any helpThanks
 
Back
Top