|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 23rd, 2004, 07:48 AM
|
|||
|
|||
Help with Inserting data into a database
I have a vb form with various text boxes and I wan't to be able to Insert the data within these text boxes into my table. The code below will insert constant values. However, I need to replace these values with variable names..Does anybody know
the correct cyntax....Please 'dbs.Execute " INSERT INTO tablename " & "(FirstName,LastName) VALUES " & "('Harry', 'Washington');"
|
|
#2
January 23rd, 2004, 07:55 AM
|
||||
|
||||
|
Code:
dbs.Execute "INSERT INTO tableName (FirstName, LastName) VALUES('" & txtFname.Text & "', '" & txtLname.Text & "');"
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Help with Inserting data into a database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
