In a previous posting I mentioned how I'd need to determine a column's name
and datatype. I failed to mention that I was using an ADO.NET dataset in a
C# windows application. A reply to my posting prompted me to do more
research into datasets and I found most of what I need.
However, I am stuck here...how do I determine if a column in a dataset is a
foreign key to another table in the database? Assume that I've set up my
database correctly and have named my foreign key relationships.
How do I test for this while looping through the columns in the dataset? Or
is there another way?