|
-
Nov 5th, 2004, 05:58 AM
#1
Thread Starter
Frenzied Member
Unable to fill a typed dataset
I am using the microsoft.applicationblocks.data "FillDataSet" method to fill a typed dataset I generated from vs.net. Here is it's schema, very simple
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Drawings" targetNamespace="http://tempuri.org/Dataset1.xsd" elementFormDefault="qualified"
attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset1.xsd" xmlns:mstns="http://tempuri.org/Dataset1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="Drawings" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="IB2_DRAWING_ISSUE" msdata:AutoIncrement="false">
<xs:complexType>
<xs:sequence>
<xs:element name="IB2_PART_NO_1" type="xs:string" minOccurs="0" />
<xs:element name="IB2_PART_NO_2" type="xs:integer" minOccurs="0" />
<xs:element name="IB2_PART_NO_3" type="xs:string" minOccurs="0" />
<xs:element name="IB2_DRAWING_ISSUE" type="xs:integer" minOccurs="0" />
<xs:element name="IB2_STATUS" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:key name="PK1">
<xs:selector xpath=".//mstns:IB2_DRAWING_ISSUE" />
<xs:field xpath="mstns:IB2_PART_NO_1" />
</xs:key>
<xs:key name="PK2">
<xs:selector xpath=".//mstns:IB2_DRAWING_ISSUE" />
<xs:field xpath="mstns:IB2_PART_NO_2" />
</xs:key>
<xs:key name="PK3">
<xs:selector xpath=".//mstns:IB2_DRAWING_ISSUE" />
<xs:field xpath="mstns:IB2_PART_NO_3" />
</xs:key>
<xs:key name="PK4" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:IB2_DRAWING_ISSUE" />
<xs:field xpath="mstns:IB2_DRAWING_ISSUE" />
</xs:key>
</xs:element>
</xs:schema>
And here is my code:
VB Code:
Dim ds As New Drawings
SqlHelper.FillDataset(constr,CommandType.Text, sqlquery, ds, "IB2_DRAWING_ISSUE")
I get design time error stating that the method can't be called with these parameters. And it is complaining about the ds which is a typed dataset.
Can anyone please help me. As a worst case scenario, I could use the ordinary dataadapter and invoke the fill method. WOuld that help me, or is there something wrong with my typed dataset?
/Henrik
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|