i have a database, i want to make it connected in vb..
tell me the coding for editing any record.
Jaseem Ahmed
2
Junior Poster
Recommended Answers
Jump to Postthis following code for editing data. change as you needed.
' Edit Query SQlQuery = "UPDATE Data " & _ " SET Name ='" & Trim(txtName.Text) & "'," & _ " Address ='" & Trim(txtAddress.Text) & "'," & _ " TelpNo ='" & Trim(txtTlpNo.Text) & "'," & …
All 2 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
this following code for editing data. change as you needed.
' Edit Query
SQlQuery = "UPDATE Data " & _
" SET Name ='" & Trim(txtName.Text) & "'," & _
" Address ='" & Trim(txtAddress.Text) & "'," & _
" TelpNo ='" & Trim(txtTlpNo.Text) & "'," & _
" Email ='" & Trim(txtEmail.Text) & "'" & _
" WHERE Id='" & Trim(txtId.Text) & "'"
' Execute Sql query
Con.Execute SQlQuery, , adCmdText
' Message if record already edited
MsgBox "Data Successfully Edited"
Jx_Man
987
Nearly a Senior Poster
Featured Poster
this following code for editing data. change as you needed.
' Edit Query
SQlQuery = "UPDATE Data " & _
" SET Name ='" & Trim(txtName.Text) & "'," & _
" Address ='" & Trim(txtAddress.Text) & "'," & _
" TelpNo ='" & Trim(txtTlpNo.Text) & "'," & _
" Email ='" & Trim(txtEmail.Text) & "'" & _
" WHERE Id='" & Trim(txtId.Text) & "'"
' Execute Sql query
Con.Execute SQlQuery, , adCmdText
' Message if record already edited
MsgBox "Data Successfully Edited"
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.