Following is my datable column
Policy No
Certificate/Asset Number
Policy Start Date
Policy End Date
Loan Account No
Customer Name
Hypothecation
Risk Location Address
Suminsured
Action
Following is my databse table column
policy_no
certificate_asset_number
policy_start_date
policy_end_date
loan_account_no
customer_name
hypothecation
risk_location_address
policy_suminsured
action
public UploadDetails UplodExcel(DataTable lst)
SqlBulkCopy objbulk = new SqlBulkCopy(con);
objbulk.DestinationTableName = "abc_tbl";
objbulk.ColumnMappings.Add("Policy No", "policy_no");
objbulk.ColumnMappings.Add("Certificate/Asset Number", "certificate_asset_number");
objbulk.ColumnMappings.Add("Policy Start Date", "policy_start_date");
objbulk.ColumnMappings.Add("Policy End Date", "Policy End Date");
objbulk.ColumnMappings.Add("Loan Account No", "loan_account_no");
objbulk.ColumnMappings.Add("Customer Name", "customer_name");
objbulk.ColumnMappings.Add("Hypothecation", "hypothecation");
objbulk.ColumnMappings.Add("Risk Location Address", "risk_location_address");
objbulk.ColumnMappings.Add("Suminsured", "policy_suminsured");
objbulk.ColumnMappings.Add("Action", "action");
objbulk.WriteToServer(lst);
above is code It's giving me following error
The given ColumnMapping does not match up with any column in the source or destination.
What I have tried:
i tried everything but not succeed please help me on this