how do i make a page that adds a record to an ms sql 05 server table.

lets say i have a form on form.aspx

i want to put the data from the form into this table
server: MySever
datbase: webDB
tabe: formtable

hope this makes sence, thanks

e.g.
a name feild
a age feild
gender multi choice male or female
a address textbox

etc.

Insert FormTable ( Columns ) Values ( ??? )

Originally Posted by Learning Newbie

Insert FormTable ( Columns ) Values ( ??? )

please could you give a bit more details?

ie an example for 1 feild,

cheers

Joe, he just did...
John gave you the basic INSERT sql query statement.

Take a look there, it might help you:
http://sqlcourse.com/
http://www.sql-tutorial.com/sql-insert-sql-tutorial/