Inserting a dataset

  • Thread starter Thread starter John
  • Start date Start date
That's going to depend on how the datatables inside the dataset were
populated. The key is rowstate and if it's not changed (Modified, Deleted,
Added) then you're going to have to loop through the rows and fire your sql
statements based on those values.

Where is the data coming from in the first place? DTS might be a much better
way to go about doing this if at all possible.
 
The dataset would have new data only i.e. no conflict with existing keys and
also it only needs to be appended. The dataset insert is to be done within a
webmethod which gets the dataset as parameter from the calling procedure.

Thanks

Regards
 
Back
Top