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