Hierarchical Grid, how to refresh the data of the child table?

8 replies. Last post: November 17, 2010 9:25 PM by Yudi
Tags :
  • New Discussion
  • New Question
  • New Product Feedback
Hi,

I have an Hierarchical Grid with one Child table.

The rootTable has a DataMember filled by a storedProcedure and I use for this Datasource

a FilterExpression attribute and a FilterParameters tag:

<FilterParameters>
<asp:ControlParameter PropertyName="Text" Name="invoicenumber" ControlID="TextBox1"></asp:ControlParameter>
</FilterParameters>

The child Table has a DataMember filled by a storedProcedure which has as input parameter

a ControlParameter:

<asp:ControlParameter ControlID="TextBox2" ConvertEmptyStringToNull="True"
DefaultValue="" Name="productnumber" PropertyName="Text" Type="String" />

So the stored procedure use this parameter to make the query.

I added a button on my application and inside the Button event I put this code to refresh the data:

WebGrid1.DataBind();


So the data of the root table is refreshed but the data of the child table no.

Why?

The same thing if I remove the ControlParameter for the DataMember used for the childTable

and use I FilterExpression attribute and a FilterParameters tag.


So how to refresh the also data of the ChildGrid for a Hierarchical Grid?


Thanks in advanced.

Best regards,

Daniele Barbini





All times are GMT -5. The time now is 4:21 PM.
Previous Next