S
Sparky Arbuckle
I can't for the life of me figure out why this won't insert into my
database. I'm also not getting any errors when I run this. I've even
tried inside a TRY CATCH block and still nothing. I've run this web app
numerous times and each time I check the database, nothing is there! I
must be missing something small here.
Private Sub btnSubmitDLNumber_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btnSubmitDLNumber.Click
Dim strDL As String = tbDL.Text
Dim objConn As New
OleDb.OleDbConnection(ConfigurationSettings.AppSettings("strConnection"))
Dim strSQL As String = "INSERT INTO tblDL (DLNumber, DateAdded) VALUES
('" & strDL & "', " & Now & ");"
Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)
End Sub
database. I'm also not getting any errors when I run this. I've even
tried inside a TRY CATCH block and still nothing. I've run this web app
numerous times and each time I check the database, nothing is there! I
must be missing something small here.
Private Sub btnSubmitDLNumber_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btnSubmitDLNumber.Click
Dim strDL As String = tbDL.Text
Dim objConn As New
OleDb.OleDbConnection(ConfigurationSettings.AppSettings("strConnection"))
Dim strSQL As String = "INSERT INTO tblDL (DLNumber, DateAdded) VALUES
('" & strDL & "', " & Now & ");"
Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)
End Sub