b2.f2, on 30 May 2012 - 10:57 AM, said:

it is Visible and not Visibility like this:

Button1.Visible = False/True

I don't get it how can you miss this when you type button and than point+V it appears self ? - ?

See, that's the problem. I am not using Visual Studio 2010. I know in previous Visual Studio versions it is simply

Button1.Visible = False/True

I am using Visual Studio 2011, and I am designing a tablet app. I'm not sure how the new code works.

    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        Dim cb As New OleDb.OleDbCommandBuilder(da)
        cb.GetUpdateCommand()
        ds.Tables(Book).Rows(inc).Item(1) = txtFirst.Text
        ds.Tables(Book).Rows(inc).Item(2) = txtLast.Text
        ds.Tables(Book).Rows(inc).Item(3) = txtMail.Text
        da.Update(ds, Book)
        MsgBox("The database has successfully been updated.")
        con.Close()
    End Sub
    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
        btnCommit.Enabled = True
        btnAdd.Enabled = False
        btnUpdate.Enabled = False
        btnDelete.Enabled = False
        txtFirst.Clear()
        txtLast.Clear()
        txtMail.Clear()
    End Sub
    Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click
        btnCommit.Enabled = False
        btnCommit.Enabled = False
        btnAdd.Enabled = True
        btnUpdate.Enabled = True
        btnDelete.Enabled = True
        inc = 0
    End Sub
    Private Sub btnCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommit.Click
        Dim cb As New OleDb.OleDbCommandBuilder(da)
        Dim NewRow As DataRow
        NewRow = ds.Tables(Book).NewRow()
        NewRow.Item("FirstName") = txtFirst.Text
        NewRow.Item("LastName") = txtLast.Text
        NewRow.Item("Address") = txtMail.Text
        ds.Tables(Book).Rows.Add(NewRow)
        da.Update(ds, Book)

        MsgBox("The new entry has been successfully added.")
        btnCommit.Enabled = False
        btnAdd.Enabled = True
        btnUpdate.Enabled = True
        btnDelete.Enabled = True
    End Sub
End Class

Actually, sorry. That didn't work. I'm not sure why, but at one point it was working, and when I entered cb.GetUpdateCommand(), it was working. But after I restart my computer, it did not work anymore... Not sure why.

This problem is also seen in my "Add New" button. It gives a SYNTAX error, both with the adding a new contact and with updating. I'll post my new code and pictures...

Salil999, on 15 May 2012 - 11:31 AM, said:

The column FirstName is in my table too. I really don't get what's going on with VB.NET...

I'm sorry for the late reply, as I did not have access to a computer.

Thank you for all your help. Ultimately, it was CharlieMay who was correct. I tried all of your methods, and was constantly recieving the same error. Thank you for all your help!

Also, I am using pradeep1210's suggestion for the new update command and con.close()

Thanks!!

This is the error it is showing me (it is attached)

Also, I'll be honest and say that I'm not the best coder. This is my first time handling databases, so please explain it to me step by step. What is that cb.GetUpdateCommad() you are using?