Database INSERT statement

[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.AppSet tings("strConnection"))
Dim strSQL As String = "INSERT INTO tblDL (DLNumber, DateAdded) VALUES
('" & strDL & "', " & Now & ");"

Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)

End Sub

[Marina]

You are never actually executing the query. All you do is create an
OleDbCommand object with the query text. But that's it.

You need to open the connection, run the query, then close the connection.

"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

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.AppSet tings("strConnection"))
Dim strSQL As String = "INSERT INTO tblDL (DLNumber, DateAdded) VALUES
('" & strDL & "', " & Now & ");"

Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)

End Sub

[Sparky Arbuckle]

LOL! I shouldn't have drank last night!

[Pat]

Drinking is good but at the right time..
And the funniest thing is that i see more of .Net when drink:)

"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

LOL! I shouldn't have drank last night!