2003et,
You will want to use the classes in the System.Data.SqlClient namespace.
You can use a SqlConnect object to get a connection to SQL server, and then
you can use the SqlDataAdapter to set up the commands to insert, update,
delete and select data from that table.
Then, you just have to add the rows to your table (so that the state is
seen as added) and then pass the dataset through to the SqlDataAdapter that
you created.
Hope this helps.