How to update a table in VB.net using oledbconnection

[Seemaraj]

I have doubt in VB.Net on how to update the records in table. I m using MS Access database. I have a table named len_graph with 9 fields like Lenid,Lenval,Lenval1,test1,test2,test3,test4,test5 ,test6.

At first time when the start button is clicked the records are added in the table where only 4 fields of the table is filled . When the button is clicked the second time I want to update the table by entering the data in the fifth field also(ie., test2 field) but I am unable to update the table.

I m using OLEdbconnection for connecting the database

Suggest me a solution for Table updation.

[digitalmanic]

Dim db as string = Server.MapPath("dbname.mdb")
Dim conn As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=" & db)
Dim strSql As String = "update len_graph set test2 = " & test2 & " where Lenid= 1;"
Dim cmd As New OleDbCommand(strSql, conn)
conn.Open()
cmd.ExecuteReader()
conn.Close()



Ambika Praveen