We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Copying a dataset via Stored Procedures

I want to copy part of a dataset into an SQL database via a stored procedure that takes parameters. The stored procedure uses the INSERT command Using the SQLDataAdapter.Update(dataset,tablename) I can get this to work, but only if the rows in the dataset have been modified. Is there another command that I can use to insert non-modified rows, or is there a way I can change the row-state to "Modified"?

Live Chat Icon For mobile
Up arrow icon