PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim objCN AsNew ADODB.Connection
Dim strConnect AsString
Dim strSQL AsString
strConnect = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source=dtbMovies.mdb"
strSQL = "UPDATE Movie SET Movie = 'txtM1.text' , Time1 = 'txt11.text' WHERE Key = '1'"
objCN.Open(strConnect)
objCN.Execute(strSQL)
EndSub
visualbasic.net 2003 in case you couldn't tell
in the update statement, how do I make it realize that those are txt boxes on the form and not just straight text? thx
Dim objCN AsNew ADODB.Connection
Dim strConnect AsString
Dim strSQL AsString
strConnect = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source=dtbMovies.mdb"
strSQL = "UPDATE Movie SET Movie = 'txtM1.text' , Time1 = 'txt11.text' WHERE Key = '1'"
objCN.Open(strConnect)
objCN.Execute(strSQL)
EndSub
visualbasic.net 2003 in case you couldn't tell
in the update statement, how do I make it realize that those are txt boxes on the form and not just straight text? thx
Last edited: