Child Table

1 reply. Last post: May 16, 2011 3:26 AM by Lili Khiung
Tags :
  • New Discussion
  • New Question
  • New Product Feedback

Hi,

 

I'm working with a WebGrid and I fill with a Datasource, but I have several errors as Time out because I manage about 1 million or more registers, so I've changed the datasource with a class in C# to fill the webgrid.

 

I have a root table and one child table, so in my class i have functions that returns me dataset or datatable but in both cases I only could insert the root table and the child table always gets empty.

 

How can I fix it?

 

A part of my code

 

 

 

 

<RootTable Caption="Ticket" DataKeyField="TcID" DataMember="Tickets"> <Columns> <ISWebGrid:WebGridColumn Caption="TcID" DataMember="TcID" Name="TcID" Width="100px" DataType="System.Int32" /> <ISWebGrid:WebGridColumn Caption="Date" DataMember="Date" DataType="System.DateTime" Name="Date" Width="100px" /> <ISWebGrid:WebGridColumn Caption="Sub" DataMember="Sub" DataType="System.Decimal" Name="Sub" Width="100px" /> <ISWebGrid:WebGridColumn Caption="Total" DataMember="Total" DataType="System.Decimal" Name="Total" Width="100px" /> </Columns> <ChildTables> <ISWebGrid:WebGridTable Caption="det" DataKeyField="Tck_Id" DataMember="det"> <Columns> <ISWebGrid:WebGridColumn Caption="Part" DataMember="Part" DataType="System.Int32" Name="Part"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Quantity" DataMember="Quantity" DataType="System.Decimal" Name="Quantity"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Descrip" DataMember="Descrip" Name="Descrip" Width="350px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Price" DataMember="Price" DataType="System.Decimal" Name="Price"> </ISWebGrid:WebGridColumn> </Columns> <PreviewRowSettings LoadOnDemand="True"> </PreviewRowSettings> <SelfReferencingSettings LoadOnDemand="True" /> </ISWebGrid:WebGridTable> </ChildTables> </RootTable>
All times are GMT -5. The time now is 3:20 AM.
Previous Next