The given columnmapping does not match up with any column in the source or destination.

Question

1.00/5 (1 vote)

See more:

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

Posted 17-Jun-23 6:22am

Akshay malvankar

Updated 17-Jun-23 8:47am

Add a Solution

Comments

Richard MacCutchan 17-Jun-23 12:50pm

Which line causes the error?

Akshay malvankar 17-Jun-23 13:07pm

objbulk.WriteToServer(lst);

2 solutions

Solution 1

See this article Space in the column’s name[^]
You might need to put the column name in brackets like below;

SQL

use DemoDatabase
go
/*Query with square bracket*/
select  [country code], [country name]
from tblCountries
Go
/*Query with double quotes*/
select  "country code", "country name"
from tblCountries
Go


objbulk.ColumnMappings.Add("[Policy No]", "policy_no");

Posted 17-Jun-23 8:42am

Mike Hankey

Updated 17-Jun-23 8:43am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2023-06-17T08:47:00

Solution 2

Look at your code:

C#

objbulk.ColumnMappings.Add("Policy End Date", "Policy End Date");

Then chck the tables: policy_end_date should be in that one:

C#

objbulk.ColumnMappings.Add("Policy End Date", "policy_end_date");

Posted 17-Jun-23 8:47am

OriginalGriff

Comments

Akshay malvankar 18-Jun-23 1:33am

Thank you

OriginalGriff 18-Jun-23 2:23am

You're welcome!