Intersoft Community - WebGrid Enterprise - Refresh Child table data

Refresh Child table data

yudi — Wed, 02 Mar 2011 14:52:13 GMT

I’d like to add information that hopefully usefull for your specific scenario.

In order to refresh child table using JavaScript function, please refer to Martin’s post. Should you need to invoke the JavaScript function from an ASP.NET Button click event, please try to use following approach.

Add an ASP.NET Button that will be used to refresh the child table of WebGrid.

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Refresh Child Table" />

Add a WebFlyPostBackManager, set the ServiceUrl property to the url of your page and enable the UI mode. The WebFlyPostBackManager code will look like below.

<ISWebDesktop:WebFlyPostBackManager ID="WebFlyPostBackManager1" runat="server" ServiceUrl="~/UnderTest/RefreshChildTableData.aspx"
    EnableUIMode="true">
    <FlyPostBackSettings PostViewState="true" />
</ISWebDesktop:WebFlyPostBackManager>

In Page_Load event, create an instance of WebFlyPostBackListener.

protected void Page_Load(object sender, EventArgs e)
{
    WebFlyPostBackListener listener = new WebFlyPostBackListener(this.Page);
}

In the Button1_Click event handler, add following code in order to invoke the “refreshChild” JavaScript function.

protected void Button1_Click(object sender, EventArgs e)
{
    WebFlyPostBackManager1.ClientAction.InvokeScript("button2_onclick();");
}

The refresh of the child table is indicated by the appearance of “Refreshing child table…” text in the status bar of WebGrid.

Hope this helps.

Refresh Child table data

qawely — Wed, 02 Mar 2011 08:50:01 GMT

Hi Martin,

thanks for your reply. This was what I have tried during in the description of my first post. The refresh action did happen, but the child table data did not reflect any different.

Refreshing the page by browser (F5) key however does it, but this is not what I wanted. I've also tried the server side refresh, but it didn't work either though the postback did happen.

Regards,

Larry

Refresh Child table data

MarTin — Tue, 01 Mar 2011 23:16:52 GMT

Hello Larry,

To refresh child table, you simply need to use the following script:

function refreshChild()
{
   var grid = ISGetObject("WebGrid1");
   grid.Tables["Orders"].Refresh();
}

I have attached a sample file for your reference. In the sample, I used hierarchical grid with table Orders and Order Details as its child tables. By using the code above, I simply refresh the child table with named "Orders".

Hope this helps.

Thank you.

Refresh Child table data

qawely — Tue, 01 Mar 2011 11:36:28 GMT

Hi,

I have a hierachical table with child tables. I wanted to refresh my child table but couldn't manage to do so.

I've looked at some of the community posts and tried to refresh my child table via a script

function refreshChild() { var grid = ISGetObject("WebGrid1");

grid.Tables["MyChildTable"].Refresh(); // Using DataMember name

}

and IN ASP

protected void Button1_Click(object sender, EventArgs e)

{

WebGrid1.ClientAction.InvokeScript("refreshChild();");

}

This doesn't work.

I then tried <

asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" OnClientClick="refreshChild()" />

With the OnClientClick and the refreshChild() function is invoked (i had put alert boxes there to tell me). However the child table still does not refresh. Only until i restart my web server that the child table data (new data) is reflected correctly. Logging out or closing browser doesn't help. I've set HierarchicalMode="LoadOnDemand" but does not make a difference. Would appreciate if someone can point me in the right direction.

Best Regards,

Larry