vendredi 8 avril 2016

SqlBulkCopy is not inserting rows in same order from the .net DataTable to Sql table in Sql Server

objDataTable=ConversionClass.ConvertToDataTable(strFilePath,"tbl_transactonData", ",");       String strConnectionString =ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;

        SqlBulkCopy bulkCopy = new SqlBulkCopy(strConnectionString);
        bulkCopy.DestinationTableName = "tbl_AllTransactiondata";
        try
        {
            bulkCopy.WriteToServer(objDataTable);
        }
        catch (Exception ex)
        {

        }
        finally
        {
            bulkCopy.Close();
        }

I need to transfer value from datatable to Sql Table using SqlBulkCopy. But SqlBulkCopy is not inserting rows in proper order .Please suggest solution for the same.

Aucun commentaire:

Enregistrer un commentaire