what is the wrong of this SQL Bulkcopy code

Vote count:

0

this code dosent insert data i donot knoW why? Dim dt As New Data.DataTable dt.Columns.Add() Dim row As Data.DataRow = dt.NewRow row(0) = "3" dt.Rows.Add(row) dt.AcceptChanges()

    Using cn As New SqlClient.SqlConnection(PHARMY2014.My.Settings.pharmy_database2012ConnectionString.ToString)
        cn.Open()

        Using copy As New SqlClient.SqlBulkCopy(cn)
            copy.DestinationTableName = "dbo.DETALIED_TEMP"

            copy.WriteToServer(dt)
        End Using
    End Using
End Sub

asked 19 secs ago

plavix89

1

what is the wrong of this SQL Bulkcopy code