Possible to create new SQL table from a datatable?

[SJG0526]

I have a datatable built within the program. The data has not come directly from any underlying table. I want to now save this datatable as a new SQL Server table. Is this possible and if so, how?

Thks

 

[TipGiver]

Yes it is possible, but what do you mean by 'built within the program' ?

 

[SJG0526]

I have this code (partial shown) and add more columns, then insert rows into the added table. The table only resides in memory, not in SQL Server.

            Dim workTable As DataTable = mdsTempImport.Tables.Add("TempImport")

            workTable.Columns.Add("UID", Type.GetType("System.Int32"))
            With workTable.Columns.Item("UID")
                .AutoIncrement = True
                .AutoIncrementSeed = 1
                .AutoIncrementStep = 1
            End With
            workTable.PrimaryKey = New DataColumn() {workTable.Columns("UID")}

            workTable.Columns.Add("ImportBatchUID", Type.GetType("System.Int32"))

 

[TipGiver]

So the host pc of you application will have sql server installed. You want to connect to a database, create a table, and last copy the contents of your built-in to the table in the database.

Do you argee?

 

[SJG0526]

I don't want to create the SQL table ahead of time. I want the program to create the SQL table just like it was a copy of the structure and data in the TempImport table in the dataset.

 

[djj55]

One way to do this would be to have your code create the table (making sure the table name is not on the server) then loop through all the datatable rows inserting the data one row at a time.
djj

 

[TipGiver]

Ok then,

Dim a_copy_of_workTable As new datatable
workTable.copy(a_copy_of_workTable)