Record not adding to the database

[benkollam]

Hi,
I have problem updating the changes in the dataset to the database. I am using an Access database and following is the code used for adding a new row. Please help

Private Sub ClientAdd_Load( ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
Try
conString = "User ID=;Password=;D ata Source=C:\VBPro ject\SasloBilli ng\SASLO-Billing.mdb;Pro vider=Microsoft .Jet.OLEDB.4.0; Persist Security Info=False" ';Initial Catalog=ClientI ndex"
sqlString = "Select * from ClientIndex"
dsClient = New DataSet
daClient = New OleDb.OleDbData Adapter(sqlStri ng, conString)
daClient.Fill(d sClient, "ClientInde x")
Catch exLoad As Exception
MsgBox(exLoad.M essage)
End Try
End Sub

Private Sub btnSave_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles btnSave.Click
Try
rowClient = dsClient.Tables ("ClientIndex") .NewRow
rowClient("File No") = txtFileNo.Text
rowClient("Main File") = txtFileNo.Text
rowClient("PCFi le") = "No PC"
dsClient.Tables ("ClientIndex") .Rows.Add(rowCl ient)
'dsClient.Accep tChanges()
daClient.Update (dsClient,"Clie ntIndex"))
MsgBox("Record Added Sucessfully")
Catch exSave As Exception
MsgBox(exSave.M essage)
End Try
End Sub

[kenobewan]

Does your dataset load initially? Do you need to open and close your connections to the db? Do you receive an error message?

Essentially, I believe that you need to create a new object and then update the dataset with that - not try to update the dataset directly. Have a look at this:
How to Add a New Record

Hope that this helps.

[benkollam]

Does your dataset load initially? Do you need to open and close your connections to the db? Do you receive an error message?

Essentially, I believe that you need to create a new object and then update the dataset with that - not try to update the dataset directly. Have a look at this:
How to Add a New Record

Hope that this helps.

Yes. Dataset is loading initially. I dont think there is no need open and close connections to the db. I am not receiving the error messages. I have same problem with modifying records too. Changes are reflecting withing the dataset. ie, if i navigate thru the recordset the changes are still there. But these changes are not seen in the database. Again no error message.
Following is the update statement used.

Private Sub btnSave_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles btnSave.Click
Try

DAClient.Update (Client1, "ClientInde x")
Catch exUpdate As Exception
MsgBox(exUpdate .Message)
End Try
End Sub

[kenobewan]

I don't see your update SQL statement. What I believe is happening is that your database is not being updated, as trying to update it through the data adapter won't work.

Hope that this helps.