You dont need to use SQL to create a new row or add it to the DB. After connection and everything is set up in the database. Create a dataTable from the table in your dataset where
you want to add the new row. Then create a new datarow on the datatable. After that you need to add information to the new datarow, then update the dataset.

It is really simple, I'm not at a VS.NET workstation, but I will provide some sample code when I get home later.

Look up dataRow and dataTable.