Access extended properties from a dataset
Posted on 2006-04-14
Greetings, I added some extended properties to some columns in my sql 2005 table, but I'm having trouble accessing these properties from my dataset. Do I need to remove my TableAdaptor compeletly and re-add it in my .xsd file in order for me to be able to access the extended propeties I added? Here is the VB code I'm trying.
For Each DC As DataColumn In ourData.Cont.Columns
If DC.ExtendedProperties.ContainsKey("Prop1") AndAlso DC.ExtendedProperties.Item("Prop1").ToString = "Y" Then
' Do something...
DC.ExtendedProperties.count is 0 for some reason