How to update data in MS-Access through vb.net

[Pra tham]

i m new to vb.net please help me to update the database records through vb.net

[osama Abboshi]

hello

oledbdataadapter1.selectcommand.comandtext="Update () from tabel1 where Rec_number=value('" & textbox1.text &"')

textbox1.text appear the recnumber when form Load

[Pra tham]

what is selectcommand.. ?

[BRawn]

selectcommand is a built-in method in the .net framework.

Alternatively, what you can do is the following:

Public Sub updateUsers()
        Dim updateQuery As String = ("UPDATE Users SET UserName = "  _
                    + (txtUserName.Text.Trim + " WHERE UserID = 1"))
        Dim adapter As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
        adapter.SelectCommand.CommandText = updateQuery
    End Sub

It's just an example to get you going. If you need anymore help just ask and someone will help you :)