insert into sql database via form

[tjones]

Hi, I'm new to ASP.NET and am currently going through the beginning C# book for ASP.NET.

What I'm trying to do is have a form on my website insert data into my sql server database. I keep finding information on how to create the tables and view data from the database on a webpage - however i don't see any tutorials for inserting into the database directly from the form - the code that's needed? Any tips on where to find info like that would be greatly appreciately.

Thanks in advance!

[korkus2000]

Welcome to WebmasterWorld,

ADO.Net really wants you to create a dataset and to use that until you do an update. Are you using the SqlDataAdapter [webmasterworld.com]? You can use regular ADO, but .Net really should use ADO.Net.

[tjones]

I hadn't looked at the SQLDataAdapter yet - thank you! I will start with that. Thanks for the quick reply.