Save routine not working

[vishalsangwan]

Hi Everybody,

I am writing an application using the bindingnavigator and the oledbDataAdapter. I am not able to save the changes to the actual access database. Please help me. The code follows.

Thank you
Vishal



I have opened a connection and the following code binds the database with the bindingnavigator using a oledbDataAdapter. And also to the text box. Where we can edit the fields and later on save them.

Me.objDataAdapter = New OleDbDataAdapter("Select * from datatable", Me.objConnection)
 
        Me.objDataAdapter.Fill(Me.objDataTable)
 
        Me.BindingSource1.DataSource = Me.objDataTable
        Me.BindingNavigator1.BindingSource = Me.BindingSource1
        Me.BindingNavigator1.Dock = DockStyle.None
        Me.Controls.Add(Me.BindingNavigator1)
 
        Me.Controls.Add(Me.RichTextBox1)
        Me.RichTextBox1.DataBindings.Add(New Binding("Text", Me.BindingSource1, "audit_task_no", True)) 
 

The following is the save routine.

        Try
            Me.objDataAdapter.Update(Me.objDataTable)
            MsgBox("Changes Successful Saved ")
        Catch ex As Exception
            MsgBox("Saved Failed")
        End Try
 
        Try
            Me.objDataTable.AcceptChanges()
        Catch ex As Exception
            MsgBox("Update failed")
        End Try 
 

I have declared objDataAdapter and other variables gloable thats why I am using Me.objDataAdapter.

[vishalsangwan]

What do I mean when I say that I am not able to save the changes?
I mean that they are not reflected in the database when I reopen it.

Does an error occur?
No error occurs.

If not then how am I determining that the save operation didn't work?
No changes are reflected in the database.

What value does Update return?
It returns zero.

So, there might be a problem with the update function.

I am binding the richtext box with the bindingsource. And the bindingsource is the datatable. Are the values in the datatable automatically updates when I change a value in the richtext box? If not how can I do that.


Any kind of suggestion would be highly appreciated.
Thanking you in anticipation.
vishal