Create table on DB along with data based on DataTable

Question

In my C# code, I have get a DataTable from excel,It has somedata.Now I want to create a table in database using this DataTable ,and insert it's data to database. How could I do it? using SqlBulkCopy?

I want to write a method like this

///using DataTable dt to create Table and insert data to this created table
public bool CreateTable(string sqlconnectionstring,DataTable dt)
{

}

This is bad practise ! Read this question stackoverflow.com/questions/1348712/… — mybirthname
– mybirthname, Commented Aug 19, 2015 at 2:31

Ali pishkari · Accepted Answer · 2015-08-19 05:26:58Z

1

INSERT INTO dbo.ImportTest 
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=C:\ImportData.xls', [Sheet1$])

answered Aug 19, 2015 at 5:26

Ali pishkari

5424 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create table on DB along with data based on DataTable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related