Might be too late to be of help... and I'm not sure if you're using SQL
Server...but..
In the past, I have inserted many records into one to many tables with a
single call by creating a sproc capable of processing a XML input
parameter (text or ntext data type).
I found this technique useful, too, when having to insert to or update a
table with many fields of data. Instead of having deal with all of the
fields, I could use a loop in the C# form to gather up all the data
field names and values, build an XML document and feed it to a sproc.
If done right, you don't have to update the sproc each time you add or
change fields in the table.
*** Sent via Devdex
http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!