Mismatch columns in the PrimaryKey : Source Vs Target

Question

0.00/5 (No votes)

See more:

SQL

I am trying to Merge two DataSets in c# .net framework 4.0, It raised " Mismatch columns in the PrimaryKey : versus " My 1st Dataset is from SQl Server of DataType "Varchar", while Other is from Oracle Database of DataType "Varchar2".

OrgStockMaster.PrimaryKey = new DataColumn[] { OrgStockMaster.Columns["PkID001"] }; //SQL Database

dtOracleStock.PrimaryKey = new DataColumn[] { dtOracleStock.Columns["PkID001"] }; //Oracle Database

While Doing this,

dsStockMaster.Merge(StkFrmOracle); DataSet dsDiff = dsStockMaster.GetChanges();

It raises this DataException : Mismatch columns in the PrimaryKey : .PkID001 versus .PKID001.

Posted 4-Dec-12 20:39pm

Pankajk.Singh

Add a Solution

Comments

[no name] 5-Dec-12 3:25am

use same datatype for PK in both DB...

Pankajk.Singh 5-Dec-12 4:22am

string QryForSupp = " Select col1 as PkID001 from ABC ";

SqlDataAdapter SqlDAforSupp = new SqlDataAdapter(QryForSupp, Con);
DataSet dsStockMaster = new DataSet();
SqlDAforSupp.Fill(dsStockMaster);
DataTable OrgStockMaster = dsStockMaster.Tables[0];

OrgStockMaster.PrimaryKey = new DataColumn[] { OrgStockMaster.Columns["PkID001"] };

if (oraConn.State != System.Data.ConnectionState.Open)
{
oraConn.Open();
}

string checkQry = "SELECT col1 as PkID001 FROM AAA ";

DataSet StkFrmOracle = new DataSet();
OleDbCommand cmdStockMast = new OleDbCommand();
cmdStockMast.CommandText = checkQry;
cmdStockMast.CommandType = CommandType.Text;
cmdStockMast.Connection = oraConn;
OleDbDataAdapter odaForStock = new OleDbDataAdapter(cmdStockMast);
odaForStock.Fill(StkFrmOracle);

DataTable dtOracleStock = StkFrmOracle.Tables[0];

dtOracleStock.PrimaryKey = new DataColumn[] { dtOracleStock.Columns["PkID001"] };

dsStockMaster.Merge(StkFrmOracle); //This line is throwing Exception.
DataSet dsDiff = dsStockMaster.GetChanges();
My Oracle Column is of Data Type "varchar2", while SQL Column is "Varchar".
I think this is why I'm getting exception.

[no name] 5-Dec-12 4:25am

Ya thats why I've told you to change Table Definition..

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)