Asp 『 sql insert multi row data 』

Dear sirs,

Ask you about ASP Master, I has create 2 table,
my question is : how to insert 5 row data to table02 and 1 row in table01

form.asp
bookname
price

table01
refid vbookname vprice
1 | java | 10


table02
trefid tbookname tprice
1 | Java | 10
2 | Java | 10
3 | Java | 10
4 | Java | 10
5 | Java | 10


Picture Provide: http://img403.imageshack.us/img403/4915/tableorder.jpg


thank you

 

to insert data into table 1 you would use the following query:
INSERT INTO table01(vbookname,vprice) VALUES('NewBookName',15.25)

to insert data into table 2 you would use the following query:
INSERT INTO table02(tbookname,tprice) VALUES('NewBookName',15.25)

Please make sure that when you go to the table design mode that refid and trefid is an identity

Good Luck!

 

to insert record into database using ASP, you can find detailed tutorial here;

http://w3schools.com/ado/ado_add.asp

 

INSERT INTO table01(vbookname,vprice) VALUES('NewBookName',10)