DataSet relationship
-
I have a DataSet with two tables with a relationship.
dataSetNodeData.Relations.Add(new DataRelation("Relationship",
dataTableTransmittal.Columns["Node ID"],
dataTableDocuments.Columns["Parent"]));This is working, but now the customer have changed the indata so Parent is now a commaseparated string with id numbers so the same document can belong to several Node ID's. Can I make the DataRelation work with a commaseparated string? Or do I have to rewrite my application totaly?
-
I have a DataSet with two tables with a relationship.
dataSetNodeData.Relations.Add(new DataRelation("Relationship",
dataTableTransmittal.Columns["Node ID"],
dataTableDocuments.Columns["Parent"]));This is working, but now the customer have changed the indata so Parent is now a commaseparated string with id numbers so the same document can belong to several Node ID's. Can I make the DataRelation work with a commaseparated string? Or do I have to rewrite my application totaly?
No, that's not going to work. You need to rethink your architecture. I suspect you need to change your dataTableDocuments to have a record per parent id, even if they are stored as a csv. I'd say don't store them that way in the first place, just add records for each parent relationship.
Christian Graus Driven to the arms of OSX by Vista.
-
No, that's not going to work. You need to rethink your architecture. I suspect you need to change your dataTableDocuments to have a record per parent id, even if they are stored as a csv. I'd say don't store them that way in the first place, just add records for each parent relationship.
Christian Graus Driven to the arms of OSX by Vista.