EmmanuelNwokedi
asked on
Updation query in VB.net
Hello experts I am working on an application where I update the MsAccess database by coding. Now I am stuck with minor error but i did't able to rectify.
please tell me what's wrong in this code
Private Sub updateAppNote()
If AppConn.State.ToString = "Closed" Then
AppConn.Open()
End If
Dim SQL As String = "UPDATE Applicant_Note " & _
"set Time_Stamp='" & Now.ToShortDateString & " " & Now.ToShortTimeString & "', Note='" & txtnote.txt & _
"' Where NID=" & CLng(dgvNoteList.CurrentRo
MsgBox(SQL)
Dim Dc As New OleDbCommand(SQL, AppConn)
Dc.ExecuteNonQuery()
AppConn.Close()
please tell me what's wrong in this code
Private Sub updateAppNote()
If AppConn.State.ToString = "Closed" Then
AppConn.Open()
End If
Dim SQL As String = "UPDATE Applicant_Note " & _
"set Time_Stamp='" & Now.ToShortDateString & " " & Now.ToShortTimeString & "', Note='" & txtnote.txt & _
"' Where NID=" & CLng(dgvNoteList.CurrentRo
MsgBox(SQL)
Dim Dc As New OleDbCommand(SQL, AppConn)
Dc.ExecuteNonQuery()
AppConn.Close()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.