VB.NET

update records+vb.net

Thread Solved

•

Join Date: Jun 2009

Posts: 60

Reputation: emint is an unknown quantity at this point

Solved Threads: 4

emint

Offline

Junior Poster in Training

update records+vb.net

Jul 13th, 2009

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.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 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")
 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

•

Join Date: Oct 2008

Posts: 3,955

Reputation: adatapost has a brilliant future

Solved Threads: 705

adatapost

Offline

Senior Poster

Re: update records+vb.net

Jul 13th, 2009

emint,
Fill the dataset.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 ...
 Dim cb As New OleDb.OleDbCommandBuilder(da)
 Dim ds As New DataSet
 ds.Fill(ds,"DBGetLoan2000")
 ...
 ...
 Dim cb As New OleDb.OleDbCommandBuilder(da)
 Dim ds As New DataSet
 ds.Fill(ds,"DBGetLoan2000")
 ...