My goal is to slurp out of SQL server (via OleDB) a table's
field and primary key fields. The DotNet stuff has my head spinning....
I have:
dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new Object[]
{"test",null,null,"TABLE"});
This gets me the DataSet for that table in the Schema, but I can't seem to
figure
out where to go from here. I guess have to interate through a Collection
in this DataSet or it's ChildRelations, but I haven't been able to find a
good description/sample in either MSDN or via the Net. Can someone
give me a simple sample, or point me in a direction?
Thanks.