how to SqlBulkCopy using different column between excel and dabase table

Hi,

You need to map the Column name link below as Given in article

sqlBulkCopy.ColumnMappings.Add("Id", "PersonId")
sqlBulkCopy.ColumnMappings.Add("Name", "Name")
sqlBulkCopy.ColumnMappings.Add("Salary", "Salary")

I hope this will help you out.

I found the issue, it seems that I misstype the column name.

@Shshikant: thanks for your attantion and help :)