strongly typed dataset

[Ced]

Hi,

I have to add 40 records in 40 tables with my application (using strongly
typed dataset). Do I have to use 40 times the "Fill" method before adding
each record in the corresponding table ? If not, how can I do to give a new
value for the primary key to each record ?

thanx,
Ced

 

[Willy Esteban]

It depends what the data source is, right? If you're using SQL Sever, for
example, you could write a stored procedure that does the forty select
statements, create a sqldataadapter that uses that stored procedure in the
select and then do the fill. One caveat is that doing it that way your
tables will have generic names like Table1, Table2, etc.; but, those are
easily changed.

willy