Column does not exist in table error

Question

Hi,

I perform a set of operations on a dataset table:

MyDataSet sharedDS = new MyDataSet();
MyDataSet referenceDS = new MyDataSet(); 
sharedDS.Table1.Reset(); 
sharedDS.Merge(referenceDS);

I get a System.ArgumentException: Column_X does not exist in Table1 if I try to access the column this way:

MyDataSet.Table1.FindByKey().Column_X

However, this way everything's fine:

MyDataSet.Table1.FindByKey()["Column_X"]

Can anyone explain what's the issue here?

Reference (originally meant for another problem): http://stackoverflow.com/questions/764004/reset-primary-key

Answer 1

I think this line :

sharedDS.Table1.Reset();

is causing you trouble.

I think the .reset is clearing the schema. Use .Clear() istead!