Home All Groups Group Topic Archive Search About

about Datatable and relations

Author
6 Feb 2006 10:57 PM
# Cyrille37 #
Hello,

I make a little words indexer (search engine like), without a SQL server.
So I'm using Datatable to store data.

The schema is like:
table Words
    + WORD
    + IID
table WordsIndex
    + WORDS_IID
    + NOTES_IID
table Notes
    + IID
    + TEXT

Relations are like :
    Words => WordsIndex <= Notes

I've read in the documentation that I can only use the "parent" function to
select data with method DataTable.Select(). Function 'child' is not available
for select, only for aggregation.

So, is the only solution is to make cascading foreach() using
DataTable.GetChildRows() and GetParentRows() ???

How to manage cascading many-to-many relations with DataTables ?

Hope to be clear enough ;o)
Thanks,
Cyrille.

AddThis Social Bookmark Button