How to update a table enteries in MS ACCESS using Vb.net?

tell me a way to update the existing entries in a table in MS ACCESS using vb.net. i ve to update the "amount" field of all customer of a bank every time they withdraw and deposit.kindly help me as soon as possible. |||K so follow this steps


First add oledbcommandbuilder


means u have to give a varible for it


as


dim adpt as new oldebdataadapter


dim ds as new dataset


dim cb as new oledbcommandbuilder(adpt)


adpt.update(ds,"tablename")


msgbox("Record Is Updated")


hope u know the way of using oledbdataadapter


take care


peace be with u |||u can use database connection to insert data into tables





'Creating connection Object


set Conn=server.createobject("ADODB.Connecti鈥?br>

'Creating Recordset Object


set rs = Server.CreateObject("ADODB.Recordset")


'Initialising Provider String





connStr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" %26amp; Server.MapPath("Studentrecords.mdb")





'Opening Connection to Database


Conn.open connStr





strSQL_Insert = "INSERT INTO tblStudent ( FName, SurName, Email, StudentNo, Password, Keystage, EntryTime)" %26amp; _


" VALUES ('" %26amp; strName %26amp; "','" %26amp; strLastName %26amp; "','" %26amp; strEmail %26amp; "','" %26amp; strUserName %26amp; "','" %26amp; strPassword %26amp; "','" %26amp; strKS %26amp; "','" %26amp; strDate %26amp; "');"





On error resume next


rs.execute(strSQL_Insert)





Conn.Close


Set Conn = Nothing