Insert to SQL(resolved Mend rawks)

[Beast777]

Okay finally got my first webapp up and its static, has no sql connections. I have been reading and looking at the forum for how to connect to a database. What I want to do is create a webform, fill in a textbox, click the button to save and have it write to the table on the SQL server. My server is called webserver, my database is webtest and my table is answer and the field is answer1. From what I have read it seems you need to put postback code in the form load event, create a datatable from all the data on the sql server, add a datarow and then do an update from the sqladapter. This seems like alot of bandwith usage for a simple update or am I barking up the wrong tree. I don't care what the data is thats there already, I just want to add a new row.