bulk insert to SQL server table

[eranby]

Hi,

I'm trying to insert Datatable into my SQL table named TA100
I'm using this code :

 public void refreshTable(DataTable freshData)
        {
            //con is the sql connection which is already open
            SqlBulkCopy copy = new SqlBulkCopy(con);
            copy.DestinationTableName = "TA100";
            copy.WriteToServer(freshData);
        }

the connection is open and close out of the method.
the table is not infected from this action.
I tryed in many other ways uselessly.
I can't even execute simple "insert into" query (the result is not affect the table)
does anyone have any suggestions?

thanks Eran

[shweta123]

Hi,

Please refer this Article regarding your question.