all groups > asp.net datagrid control > december 2004 >
You're in the

asp.net datagrid control

group:

table relationships


table relationships et
12/27/2004 7:50:51 PM
asp.net datagrid control:
How do I programmtically get the relationships of a table??

I can get the list of columns:
dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid., New Object() {Nothing,
Nothing, strTableName, Nothing"})

, but when I change it to Foreign_Keys, no data is returned.

dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, New
Object() {Nothing, Nothing, strTableName, Nothing})

Re: table relationships Jason
12/28/2004 5:14:56 AM
ET,
What database are you using? If it's SQL, try accessing the system
tables for getting at this information.

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

Jason

[quoted text, click to view]
AddThis Social Bookmark Button