Administrator Admin
Number of posts : 160 Age : 38 Location : Lucknow Job/hobbies : Software Engeener What U like To do ? : Because Its Rock with me. Registration date : 2008-01-06
| Subject: To update the record 1/22/2008, 1:08 am | |
| 1. Connection is describe in data base connectivity new topic - Quote :
- Set AdoCmd = New ADODB.Command
Dim StrSQL As String StrSQL = "Update product set p_name = '" & Text3.Text & "',price = '" & Text4.Text & "',no_of_units = '" & Text5.Text & "' Where p_code ='" & Text1.Text & "'" AdoCmd.ActiveConnection = adocon AdoCmd.CommandText = StrSQL AdoCmd.CommandType = adCmdText AdoCmd.Execute
| |
|