0

Helo every one
i m trying to update record to ms database using vb.net. but i m getting error message. pls help me where i made mistake. here is my code.

Dim da As New OleDb.OleDbDataAdapter("SELECT * From tblCustomer", strPath)
                Dim cb As New OleDb.OleDbCommandBuilder(da)
                Dim ds As New DataSet

                ds.Tables("DBGetLoan2000").Rows(position).Item(1) = txtFName.Text
                ds.Tables("DBGetLoan2000").Rows(position).Item(2) = txtLName.Text

                da.Update(ds, "DBGetLoan2000")


                MsgBox("Record updated")

thank you

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by __avd
0

emint,
Fill the dataset.

...
 Dim cb As New OleDb.OleDbCommandBuilder(da)
 Dim ds As New DataSet
 ds.Fill(ds,"DBGetLoan2000")
 ...
0

helo adatapost
thank you for ur reply, it works fine, thank you

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.