B
Brian
I used the designer in VS.NET 2003 to create a dataset. Within that
dataset, there is an element "Tags", with a primary key and
relationship:
<xs:element name="Tags">
<xs:complexType>
<xs:sequence>
<xs:element name="TagName" type="xs:string" minOccurs="0" />
<xs:element name="TagDesc" type="xs:string" minOccurs="0" />
<xs:element name="System" type="xs:boolean" minOccurs="0" />
<xs:element name="FieldType" type="xs:string" minOccurs="0" />
<xs:element name="FieldLength" type="xs:integer" minOccurs="0"
/>
<xs:element name="Decimal" type="xs:integer" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:key name="pkTags" msdatarimaryKey="true">
<xs:selector xpath=".//mstns:Tags" />
<xs:field xpath="mstns:TagName" />
</xs:key>
<xs:keyref name="TagsLabelsTags" refer="pkTags"
msdataeleteRule="Cascade">
<xs:selector xpath=".//mstns:LabelsTags" />
<xs:field xpath="mstns:TagName" />
</xs:keyref>
Nothing special, right?
When I attempt to build the project I get a series of compile errors
in the code behind:
'Convert' is not a member of 'Boolean'.
Public Sub SetTagDescNull()
Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here
End Sub
There is one error for each of the non-key fields, all in the
Set_Field_Null() subroutines.
I'm lost. Any ideas?
dataset, there is an element "Tags", with a primary key and
relationship:
<xs:element name="Tags">
<xs:complexType>
<xs:sequence>
<xs:element name="TagName" type="xs:string" minOccurs="0" />
<xs:element name="TagDesc" type="xs:string" minOccurs="0" />
<xs:element name="System" type="xs:boolean" minOccurs="0" />
<xs:element name="FieldType" type="xs:string" minOccurs="0" />
<xs:element name="FieldLength" type="xs:integer" minOccurs="0"
/>
<xs:element name="Decimal" type="xs:integer" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:key name="pkTags" msdatarimaryKey="true">
<xs:selector xpath=".//mstns:Tags" />
<xs:field xpath="mstns:TagName" />
</xs:key>
<xs:keyref name="TagsLabelsTags" refer="pkTags"
msdataeleteRule="Cascade">
<xs:selector xpath=".//mstns:LabelsTags" />
<xs:field xpath="mstns:TagName" />
</xs:keyref>
Nothing special, right?
When I attempt to build the project I get a series of compile errors
in the code behind:
'Convert' is not a member of 'Boolean'.
Public Sub SetTagDescNull()
Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here
End Sub
There is one error for each of the non-key fields, all in the
Set_Field_Null() subroutines.
I'm lost. Any ideas?