ADO.NET: insert data from dataset/dataview/datatable into new table in a database
Posted on 2011-03-02
Hi, I have a query that i need to run, do some stuff, and then insert result into a table in an access database. So, I've run the query and put it into a datatable... or dataview or dataset... don't know exactly what i need, but i can do all three.
So, when I have my result... how do i get that back into the database... what's the easiest and quickest way? Do i put it from a dataset, or datatable or dataview into the database (in a new table in this case) or how do i go about this? (can you show code required?)