SQL database not saving

I am trying to add a row to a database, i am able to put the row into the database and view it ina datagrid while the VB program is running, but when the program closes that row dissapears. What code am i missing to update the database table instead of just the working dataset?

Code:

---

Dim saverow2 As DataRow
        If saverow = 0 Then
            saverow2 = MainDBDataSet.Assesments.NewRow()
            saverow2.Item("Customer") = CustomerName
            .
            .
            .
            MainDBDataSet.Tables("assesments").Rows.Add(saverow2)
            Me.TableAdapterManager.UpdateAll(Me.MainDBDataSet)
endif

---

I would write a standard SQL INSERT Query to add the new record to my database.

Where can i see and example of that? I am new to SQL.

What kind of SQL server are you running? SQL Server? MySQL? Oracle?

SQL server.

See the Database FAQ section on this site.

I see the database FAQ section, but i dont think i understand. From what i see what im doing should work right? Inserting the row to the dataset then updating the table via the dataset.

The faq says to use the update method to save the changes to the database, im using the command but its not updating the database.

Sorry for the ignorance, ive never used SQL before.