Can a DataTable have foreign keys?

[Guest]

I love the feature of DataTable to specify a Primary Key and then be able to
search by it using the Rows.Find method...

but is there a way to do this for a foreign or alternate key- i.o.w. to be
able to search in a specific column besides the Primary Key column(s) ??

 

[John Wood]

Use the "select" method to do this, where you'd pass in an expression such
as "myfield = 14".
Keep in mind that every select you run, it will be faster the second time -
the first time it builds an index in a hashtable automatically. The index is
deleted when any of the rows are updated. Alternatively you can use the
AddIndex and RemoveIndex (IBindingList methods) to set up the indexes before
the select. Hope that helps.