Create new table in database from DataTable

[Guy007]

I have a DataTable that is passed to me from an external application.

I would like to save this DataTable to my database (MS SQL server) using .net (c#).

How can a NEW table be automatically created from a dataset? I imagine SQLDataAdapter and SQLCommand may need to be used, but i still haven't quite managed to figure out how!

any ideas?

thanks

[DeanMiller]

you are trying to create a whole new table or just a new row in the existing table?

[Guy007]

A whole new table - the local database is still empty....