ADO.NET equivelant of RS.AddNew?

I have the datareader down, but that is like opening a recordset for forward readonly access.

So now I need to save a record to my table.

I know I can do an INSERT INTO db command, but is there anything similar to the old ADO recordset.AddNew method?

It is much easier to deal with than trying to put a string together for the insert as you have to check for ' and it gets messy with all the concatenation of strings

Use the dataset instead. You can add new rows to it, or edit an existing one, and then go fo an .Update()

Have you started with datasets yet, btw?

nope, i knew they existed, but haven't coded anything with them yet. I will look for some examples

You also have the option of EXECUTENONQUERY, and you'll need to create the SQL statements yourself.

ADO.NET quickstart:
http://samples.gotdotnet.com/quickst...sOverview.aspx