how to insert data in to two tables?

hi,

i have got a problem, iam creating an asp.net application, but i pretend to insert data in two different tables, but i have no ideia how to do this.Can you help to solve this problem? please........

So, you need to insert data into two different tables? What database are you using? If you are using SQL or MSDE, you would use 2 insert statements or a stored procedure.|||

scosta wrote:

hi,

i have got a problem, iam creating an asp.net application, but ipretend to insert data in two different tables, but i have no ideia howto do this.Can you help to solve this problem? please........

This is as simple as executing two SQL INSERTS in sequence or as complicated as writing a stored proc that does the same thing.
Time to pick up an introductory book on SQL Server and ADO.NET my friend.
|||

iam using Sql, and i want to use the way to solve the problem, or 2 insert statements or a stored procedure.

how to insert data in to two tables?

hi,

iam creating an asp.net application the database is created on the SQLSERVER, but i have a problem, i pretend to insert data in to 2 tables and i have no ideia how to do this. Can you help me to solve this problem? Please....

you would need 2 insert statements. check out books online for syntax on INSERT. You could also use stored procedures to have all the inserts in it so you can get your job done in one trip to the server.sql