I am having trouble updating my Database from my code using a DataSet. I'm using SQL Server 2008 and Visual Studio 2008. Here is what I've done so far.

I have created a table in SQL Server called MyTable which has two columns: id nchar(10), and name nchar(50).

I have then created a datasource in my VB.net project that consists of this table using the dataset wizard and called this dataset MyDataSet.

I run the following code on a button click:

    Try
        Dim myDataSet As New MyDataSet
        Dim newRow As MyDataSet.MyTableRow = myDataSet.MyTable.NewMyTableRow
        newRow.id = "1"
        newRow.name = "Alpha"
        myDataSet.MyTable.AddMyTableRow(newRow)
        myDataSet.AcceptChanges()
    Catch ex As Exception
        MsgBox(ex.Message)
    End Try

when I run this and check the rows in SQL Server it returns 0 rows

What have I missed? How can I add these rows / save changes in a dataset to the database? I have seen other examples that use a TableAdapter but I don't think I want to do this, I think I should be able to achieve this just using a DataSet. Am I mistaken?

Help is greatly appreciated!