new to asp.net

[buzzby247]

hi there. i am very new to asp.net
i have an IIS server and am building an asp form. what i would like to do is make a form that will send the details for the form to a database and also email the recipient a confirmation.

here is the table for my form, please let me know if this is right:

CREATE TABLE FlyMeToTheMoonR esults
(
Id int,
Name varchar,
Age int,
Email varchar,
Phone int,
Address varchar (255),
Postcode varchar (8),
)

the email address my contain numbers as well as letters.

i am used to a lamp emvironment so therefore validation is a new thing to me. altho i have found a validation script for my form.

my greatest need is to know how to make a table (if this one is not right), how to submit my form to that table, how to view the results of that table whenever i want. since the form will deal with the sending of the data on the same page i can sort ofhandle the confirmation message that comes up altho a hint at this wont go amiss.

thank you for your help in this

[DrBunchman]

Hi buzzby247,

You've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.

Dr B

[Curtis Rutland]

Well, to be honest, all these questions are very broad. Books have been written about these questions. I suggest you find yourself a good ASP.NET with Databases book or tutorial and read it, because we can't teach you from the beginning. I suggest one of the Wrox books.