|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
September 26th, 2004, 10:33 PM
|
|||
|
|||
"help"
hi! everyone i need a code on how to add my Personal Information my database. I have already my Personal Information is firstname, lastname, nickname, address, city/town, province, country, e-mail, phone, communication mode preferred (Postal Mail, E-mail, Telephone), occupation, industry. And I need a code on how to add and edit at my database.
|
|
#2
September 30th, 2004, 02:37 PM
|
|||
|
|||
|
Firstly, Open a DB connection
Code:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Database Connection"
For inserting data, Insert into [tablename] ([column name]) values ([data to coresponding column]) Code:
strSQl="insert into yourTableName ('firstname', 'lastname', 'nickname', 'address', 'city/town', 'province', 'country', 'e-mail', 'phone', 'communication mode preferred' ,'occupation', 'industry')
values('micheal','line','cuty','abc','abc','abc',' abc','abc@hotmail.com',45454545,'mail','CEO','IT') "
For updating data, Update [tablename] set [column name]='[data to update' where [condition] Code:
strSQl="update yourTableName set address='def', phone=12345786 where firstname="micheal' and last name='line'" execute query Code:
Conn.Execute strSQl
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > "help" |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
