Saving data to parent-child tables

[mohaimen]

Hi,

I am writing an ASP.NET application with SQL Server 2000 at the backend. In most of the cases data are entered in grids and saved in two tables - one record in a parent table and a number of records in the child table. Currently I am executing stroed procedures for saving individual records. It means if there are 20 records in a grid, stroed proc is run 21 times. Is there any better solution?

Regards.

Mohaimen

 

[jbenson001]

Nope, you need to call and Insert for each row.