How to insert data into database from data set or datatable

[micydon]

Hi I hve loaded a data table with values from a database. I want to insert these values into another table in database. How can we insert data directly from datatable into database. Can anybody help me to solve this problem.

[leckey 0]

Are you just moving data from table1 to table2? Are there changes to the data in the datagrid before saving to table2? I'm just trying to figure out why you need the datagrid if you are just migrating data...

[Not Active]

This doesn't have anything to do with ASP.NET. Try the SQL/ADO/ADO.NET forum.

only two letters away from being an asset