How do I change DataRow.RowState to Added?

Hi

I have filled a DataTable from a different data source to the one I want to insert into. I want to use my TableAdapter.Update method to insert the DataTable rows. If I could change the DataRow.RowState to Added that would solve my problem but the property is read only (perhaps for good reason).

The DataTable from the source data uses the same schema as the destination source.  Are there any simple options available to achieve this?

Thanks
AndrewStart Free Trial