Greetings, and thank you in advance.
I have been trying, and failing horribly at trying to INSERT values from an <asp:TextBox> into a access database. I get no errors which leads me to believe that my insert command is wonky. I am however, able to SELECT * from TableName. I would like to do this on an <asp:button> here's my sub:
Sub submit (sender As Object, e As EventArgs)
dim dataconn, datacomm,sqlinsert
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.o;data_ source=" & "C:\....\...\Database.mdb;")
dataconn.Open()
sqlinsert="INSERT INTO TableName(Field1,Field2,Field3,Field4) VALUES (TextBox1.Text, TextBox2.Text...)"
datacomm=New OleDbCommand(sqlinsert, dataconn)
dataconn.Close()
End Sub
So that being said, I've tried that pesky INSERT so many different ways I'm at my wits end. And seens how I've been a week to learn a language, I have no place else to turn
Would I have to to do a .DataBind()? or something I'm just not sure.
Any help would be great, I only have until 9am Wednesday to finish. :/
Thank you again in advance,
Dave
