471,317 Members | 1,638 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,317 software developers and data experts.

about Datatable and relations

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.
Feb 6 '06 #1
0 928

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Edward Mostrom | last post: by
reply views Thread by Chris Ericoli | last post: by
4 posts views Thread by Fred Nelson | last post: by
2 posts views Thread by Emre DİNÇER | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.