Comments by kesiw - CodeProject

kesiw 17-Dec-13 15:14pm View

I have tried something similiar to what you suggest, however, as I loop through the tables expecting d3 to change it does not.
it works the first time through - when i == 0, the field "myfieldOnlyInOneTable" exists only in the second table, so the first part of the if returns false so it does not look for the value,
hwoever, the second time through it sees that it is in the table, however, the d3 still hold the value of the first table, so it fails with the msg that myfieldOnlyInOneTable does not exist in the first table.
I look for a value in the select new using:
myValue = (dataset[i].Columns.Contains("myfieldOnlyInOneTable")) ? d3.Field<string>("myfieldOnlyInOneTable") : string.Empty

any ideas?

kesiw 16-Dec-13 16:20pm View

Thank you for your quick response! I do not think this will work as I have a different number of tables in the xml files, I do not use all the tables, and the joins are on different fields for different tables.

kesiw 15-Jul-13 13:39pm View

I am not following. I am using C# - I can't get the copyToDataTable to work. I am using a query that joins two tables. It gives results but fails when I try to copy the results to the datatable using copyToDataTable

Comments by kesiw (Top 3 by date)