insert multiple records with ASP.NET

Hi,

I would like to insert multiple records in 1 table with ASP.NET.

I also would like to insert 1 record in 2 different tables with ASP.NET.

How could I get this to work?
I use SQL server 2000, so, I presume there must be a way of doing this with
stored procedures?

Any ideas??
THX

This has been posted several times in the Ultradev group

If you look at the code DW generates, you can find the 3 or 4 lines
that actually do the insert. Copy and paste the couple you need and
then hand code.

Check out http://groups.google.com/groups?q=+%22mark+bodoh%22&hl=en&lr=&ie=UTF-8&as_qdr=w&selm=b23d5a64.0311170703.61cc1a60%40pos ting.google.com&rnum=1