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.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)