table doesnt have primary key / xsd problem...

[jack]

using the following xsd code :

<xs:element name="tblUsers" >
<xs:complexType >
<xs:sequence>
<xs:element name="UserID" type="xs:int" />
<xs:element name="FullName" type="xs:string " />
<xs:element name="UserName" type="xs:string " />
<xs:element name="Password" type="xs:string " />
<xs:element name="Email" type="xs:string " />
</xs:sequence>
</xs:complexType>
<xs:unique name="tblUsersK ey1" msdata:PrimaryK ey="true">
<xs:selector xpath="." />
<xs:field xpath="mstns:Us erID" />
</xs:unique>
</xs:element>

i'm unable to execute this against a dataset loaded with the schema and a
sample xml data file.

theRow = systemDB.Tables["tblUsers"].Rows.Find(theU ser.UserID);

Exception Details: System.Data.Mis singPrimaryKeyE xception: Table doesn't
have a primary key.

what am i missing?

[jack]

after a good bit of searching, i found one way to deal with it.

systemDB = new DataSet();
systemDB.ReadXm lSchema("db.xsd ");
systemDB.ReadXm l("db.xml");
x[0] = systemDB.Tables["tblUsers"].Columns["UserID"];
systemDB.Tables["tblUsers"].PrimaryKey = x;

this accomplishes the goal... But to avoid having to hard portions of the
schema into the app I need to find a way of embedding the PK within the xsd
file. Any suggestions?

"jack" <ja**@bone.co m> wrote in message
news:f6******** ************@ad elphia.com...

using the following xsd code :

<xs:element name="tblUsers" >
<xs:complexType >
<xs:sequence>
<xs:element name="UserID" type="xs:int" />
<xs:element name="FullName" type="xs:string " />
<xs:element name="UserName" type="xs:string " />
<xs:element name="Password" type="xs:string " />
<xs:element name="Email" type="xs:string " />
</xs:sequence>
</xs:complexType>
<xs:unique name="tblUsersK ey1" msdata:PrimaryK ey="true">
<xs:selector xpath="." />
<xs:field xpath="mstns:Us erID" />
</xs:unique>
</xs:element>

i'm unable to execute this against a dataset loaded with the schema and a
sample xml data file.

theRow = systemDB.Tables["tblUsers"].Rows.Find(theU ser.UserID);

Exception Details: System.Data.Mis singPrimaryKeyE xception: Table doesn't
have a primary key.

what am i missing?