updating a database through a visual basic form

[janita]

Hi
i need to update a database which is connected to a form in visual basic.
the entries that made in text boxes present in the form must be updated to the connected database.
Can u help me with a sample code..

thanks,

[smartchap]

Using ADO and its update method u can update the data written in textboxes or a grid etc in a form. For updating u can place a command button on form which is clicked after all fields / controls on the form are filled as required.

[oumaG]

<QUOTE>
Ms Access
using ADO you can write the following code
Public dbase As New ADODB.Connection
Public rsconn As New ADODB.Recordset
Set dbase = New ADODB.Connection
dbase.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\databaseName.mdb"
Set rsconn = New ADODB.Recordset
Set rsconn = dbase.Execute("UPDATE tableName SET field1 = '" & txtfieldName.Text &"' WHERE keyField = '" & txtkeyField.Text & "'")

With rsconn
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Source = "select * from ItableName "
.ActiveConnection = dbase
.Open

End With


Set rsconn = Nothing
Set dbase = Nothing
</QUOTE>

[debasisdas]

TRY USING THIS

con.begintrans                   'con is the ADODB connection object
con.execute "your insert / update statement here"
con.committrans