Hmmm.... I'm not sure that's the problem.
I wrote the dataset to xml and it's 115KB. I also created a seperate
win app just to load this dataset in a plain datagrid, but with no
improvement.
Could i post the xml dataset?
The code in the test win app is as simple as
DataSet ds = new DataSet();
ds.ReadXmlSchema("c:\\xml.xsd");
ds.ReadXml("c:\\xml.xml");
dataGrid1.DataSource = ds.Tables[0];
The XML schema is this
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns=""
xmlns:xs="
http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:Locale="en-ZA">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="tblProject">
<xs:complexType>
<xs:sequence>
<xs:element name="pkiProjectID" msdata:ReadOnly="true"
msdata:AutoIncrement="true" type="xs:int" />
<xs:element name="sBusinessPartnerCode" type="xs:string"
/>
<xs:element name="dClientRate" type="xs:decimal" />
<xs:element name="fkiCompanyID" type="xs:int" />
<xs:element name="fkiDivisionID" type="xs:int" />
<xs:element name="sProjectCode" type="xs:string" />
<xs:element name="sProjectName" type="xs:string" />
<xs:element name="sProjectDescription" type="xs:string"
minOccurs="0" />
<xs:element name="fkiProjectLead" type="xs:int" />
<xs:element name="fkiProjectManager" type="xs:int" />
<xs:element name="dtPlannedStart" type="xs:dateTime" />
<xs:element name="dtPlannedFinish" type="xs:dateTime" />
<xs:element name="dtActualStart" type="xs:dateTime" />
<xs:element name="dtActualFinish" type="xs:dateTime" />
<xs:element name="dtCreatedOn" type="xs:dateTime" />
<xs:element name="fkiCreatedBy" type="xs:int" />
<xs:element name="dtRevisedOn" type="xs:dateTime" />
<xs:element name="fkiRevisedBy" type="xs:int" />
<xs:element name="fkiCalenderID" type="xs:int" />
<xs:element name="fkiProjectStatusID" type="xs:int" />
<xs:element name="fkiProjectPhaseID" type="xs:int" />
<xs:element name="dPercComplete" type="xs:decimal" />
<xs:element name="bDeleted" type="xs:boolean" />
<xs:element name="CardName" type="xs:string"
minOccurs="0" />
<xs:element name="sProjectStatus" type="xs:string"
minOccurs="0" />
<xs:element name="PlannedHours" type="xs:decimal"
minOccurs="0" />
<xs:element name="ActualHours" type="xs:decimal"
minOccurs="0" />
<xs:element name="AvgPercComplete" type="xs:decimal"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblProjectTeam">
<xs:complexType>
<xs:sequence>
<xs:element name="pkiProjectTeamID"
msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
<xs:element name="fkiProjectID" type="xs:int" />
<xs:element name="fkiPersonID" type="xs:int" />
<xs:element name="fkiProjectRoleID" type="xs:int" />
<xs:element name="sFullName" type="xs:string"
minOccurs="0" />
<xs:element name="sRoleName" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblQuote">
<xs:complexType>
<xs:sequence>
<xs:element name="DocEntry" type="xs:int" minOccurs="0"
/>
<xs:element name="DocNum" type="xs:int" minOccurs="0" />
<xs:element name="DocDate" type="xs:dateTime"
minOccurs="0" />
<xs:element name="CardCode" type="xs:string"
minOccurs="0" />
<xs:element name="fkiCompanyID" type="xs:int"
minOccurs="0" />
<xs:element name="Project" type="xs:string" minOccurs="0"
/>
<xs:element name="Total" type="xs:decimal" minOccurs="0"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblOrder">
<xs:complexType>
<xs:sequence>
<xs:element name="DocEntry" type="xs:int" minOccurs="0"
/>
<xs:element name="DocNum" type="xs:int" minOccurs="0" />
<xs:element name="DocDate" type="xs:dateTime"
minOccurs="0" />
<xs:element name="CardCode" type="xs:string"
minOccurs="0" />
<xs:element name="fkiCompanyID" type="xs:int"
minOccurs="0" />
<xs:element name="Project" type="xs:string" minOccurs="0"
/>
<xs:element name="Total" type="xs:decimal" minOccurs="0"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblTask">
<xs:complexType>
<xs:sequence>
<xs:element name="pkiTaskID" msdata:ReadOnly="true"
msdata:AutoIncrement="true" type="xs:int" />
<xs:element name="fkiCompanyID" type="xs:int" />
<xs:element name="LineNum" type="xs:int" />
<xs:element name="fkiProjectID" type="xs:int" />
<xs:element name="fkiProjectPhaseID" type="xs:int" />
<xs:element name="Description" type="xs:string" />
<xs:element name="dtPlannedStart" type="xs:dateTime" />
<xs:element name="dtPlannedFinish" type="xs:dateTime" />
<xs:element name="dPlannedHours" type="xs:decimal" />
<xs:element name="dtActualStart" type="xs:dateTime" />
<xs:element name="dtActualFinish" type="xs:dateTime" />
<xs:element name="dPercComplete" type="xs:decimal" />
<xs:element name="dActualHours" type="xs:decimal"
minOccurs="0" />
<xs:element name="sPhaseName" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="dsProjectsKey1" msdata
rimaryKey="true">
<xs:selector xpath=".//tblProject" />
<xs:field xpath="pkiProjectID" />
</xs:unique>
<xs:unique name="dsProjectTeamsKey1" msdata
rimaryKey="true">
<xs:selector xpath=".//tblProjectTeam" />
<xs:field xpath="pkiProjectTeamID" />
</xs:unique>
<xs:unique name="dsTasksKey1" msdata
rimaryKey="true">
<xs:selector xpath=".//tblTask" />
<xs:field xpath="pkiTaskID" />
<xs:field xpath="fkiCompanyID" />
<xs:field xpath="LineNum" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="Project_x0020_Team_x0020_Members"
msdata
arent="tblProject" msdata:child="tblProjectTeam"
msdata
arentkey="pkiProjectID" msdata:childkey="fkiProjectID" />
<msdata:Relationship name="Project_x0020_Quotes"
msdata
arent="tblProject" msdata:child="tblQuote"
msdata
arentkey="sProjectCode" msdata:childkey="Project" />
<msdata:Relationship name="Project_x0020_Orders"
msdata
arent="tblProject" msdata:child="tblOrder"
msdata
arentkey="sProjectCode" msdata:childkey="Project" />
<msdata:Relationship name="Project_x0020_Tasks"
msdata
arent="tblProject" msdata:child="tblTask"
msdata
arentkey="pkiProjectID" msdata:childkey="fkiProjectID" />
</xs:appinfo>
</xs:annotation>
</xs:schema>