I am using visual basic 2005 express edition. I am having problems adding and updating an access database.

My problem is updatingand not adding.

The following is the code.

Private Sub cmdAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdAdd.Click
            Dim row As DataRow = dt.NewRow()
            row("deptno") = deptnobox.Text
            row("dname") = dnamebox.Text
            row("location") =locationbox.text
            dt.Rows.Add(row)
            ShowDataSet()
                    End Sub

Private Sub cmdUpdateRow_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdUpdateRow.Click
Dim rows As DataRow() = dt.Select("deptno = " & deptnobox.Text)
rows(0)("dname") = dnamebox.Text
rows(0)("location") = locationbox.text
ShowDataSet()
End Sub

Private Sub cmdAccept_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdAccept.Click
            ds.AcceptChanges()
            ShowDataSet()
                    End Sub

Private Sub ShowDataSet()
            lstModel.Items.Clear()
            For Each row As DataRow In dt.Rows
                If row.RowState <> DataRowState.Deleted Then
lstModel.Items.Add(row("deptno")& controlchars.tab & row("dname") & controlchars.tab & row("location"))
End If
Next row
End Sub

** ds is the dataset and connection is done conn as new oledb.oledbconnection and all other variables defined as global.

Any suggestions or opinions?

what is your error???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

There is no error shown. It will add the entries to the list box and I can see that in the display of the list box.

When I click update, it has no error message. Then when the form is reloaded again I see the original entries (3).

That means it is not getting committed to the database.