Get SQL command from datatable ?

Is there a way to create a sql command to create a table in SQL from a DataTable

And after create insert the data automatically (I'm running foreach row)

But my table is dinamic how can I do this dinamically

I think it is possible but you have to map .NET data types to SQL ones...

by having table created in SQL you could define your select statement and to generate other commands using SqlCommandBuilder Class. I think this is what you want to do...

hope this helps

Hum...I didn't get..

What I need is to extract/generate the command "Create table dados {.....}" from a DataTable that was create in C#

Microsoft has a article on this.

Ok Thanks