Updating SQL Database - Using DataTable

I am quite new to ASP.net 2.0. I have had plenty of experience using ADO.net in standard windows applications.

In my app I am opening a connection to an SQL database and I am creating a DataTable without a DataSet:

Shared m_cnADONetConnection As New System.Data.SqlClient.SqlConnection

Shared m_daDataAdapter As System.Data.SqlClient.SqlDataAdapter

Shared m_rowPosition As Integer

Shared m_dtContacts As New System.Data.DataTable

I am initializing everything and filling my DataTable when the Page first Loads if it isnt a postback.Protected Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Form1.Load

If Not Page.IsPostBack Then

m_rowPosition = 0

m_cnADONetConnection.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:First ASP DatabaseApp_DataMyFirstDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

m_cnADONetConnection.Open()m_daDataAdapter = New System.Data.SqlClient.SqlDataAdapter("Select * From Books", m_cnADONetConnection)m_cbRefillCommand = New System.Data.SqlClient.SqlCommand

m_daDataAdapter.Fill(m_dtContacts)

Me.ShowCurrentRecord()

End IfEnd Sub

The Me.ShowCurrentRecord Sub assigns the values of the current record(row) in the DataTable via (m_rowPosition) to TextBox controls on the form:

I also have record navigation buttons on my form: << < > >> Moving me from record to record (row to row) by incrementing or decrementing m_rowPosition

All is good! I am able navigate the DataTable and the textboxes change their text properties accordingly from record to record.

The only other control on my form is a button which I'm coding its click event to save changes that I made to the current row (record) by changing the values in the textboxes then clicking save.

 Here is my code:Protected Sub ButtonSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonSave.Click

If m_dtContacts.Rows.Count <> 0 Then

m_dtContacts.Rows(m_rowPosition).BeginEdit()m_dtContacts.Rows(m_rowPosition)("Title") = TBTitle.Text

m_dtContacts.Rows(m_rowPosition)("Author") = TBAuthor.Textm_dtContacts.Rows(m_rowPosition)("YearPublished") = TBYearPublished.Text

m_dtContacts.Rows(m_rowPosition)("Price") = TBPrice.Textm_dtContacts.Rows(m_rowPosition)("LastReadOn") = TBLastReadOn.Textm_dtContacts.Rows(m_rowPosition)("PageCount") = TBPageCount.Text

m_dtContacts.Rows(m_rowPosition).AcceptChanges()

m_dtContacts.Rows(m_rowPosition).EndEdit()

m_dtContacts.AcceptChanges()

m_daDataAdapter.Update(m_dtContacts)

End Sub

After I click save I can navigate through my records and back to the one I just changed and updated and all is well. The changes were made in the table.

However, when I close the page and exit out of Visual Web Developer and reopen the database: THE CHANGES WERENT UPDATED!!!

 This worked all the time in VB2005.net when developing a standard windows app.

Can I use the same approach I was using in my code above or am I missing something. 

 

I have read and searched all over and what I'm thinking is that my UpdateCommand, InsertCommand, DeleteCommand, SelectCommand are empty.

Do I have to do it this way?