George,

When using SQL Server, you need to use the named parameter such as @ReportsTo. For instance,

SELECT      *
FROM          Employees
WHERE      (ReportsTo IS NULL) OR
                        (ReportsTo = @ReportsTo)

Make sure the method name is properly assigned to the SelectSelfReferenceRowMethod in your ISDataSource, then your page should run properly. Note: I've tried to use SQL and it works fine using the above query.

Hope this helps, 
James.

Hi George, thanks for your response.

I presume you've managed to get it work in SQL Server? Please let me know if you still have other issues.

James.

Hi George,

The issue is not in the WebGrid, but I think on the ISDataSource configuration. When load on demand is used and the Grid is bound to ISDataSource, you need to configure the SelectSelfReferenceRowMethod property in your ISDataSourceTable, which points to an existing method defined in your table adapter.

To understand further, see the SelfRef_LoadOnDemandChildRetrieval.aspx sample in WebGrid C# Solution. Then open the dsNorthwind_LoadOnDemand.xsd and notice the GetDataBy method defined in the table adapter, which is used to retrieve the self referencing children.

If you need a walkthrough, paste this url in your VS Document Explorer,  ms-help://ISNet.WebUI.WebGrid.V7/ISNet.WebUI.WebGrid/Creating Self Reference LoadOnDemand WebGrid.html

James.

Hi Adrian,

You can get the pending changes data in server-side by handling the BatchUpdate server-side event.

First, you can access all modified rows through e.PendingChanges, and then loop through the list of the modified cell data in the Data property of each row change.

Here's the C# code example that shows how to achieve this scenario.

protected void Page_Load(object sender, EventArgs e)
{
     WebGrid1.BatchUpdate += new EventHandler<BatchUpdateEventArgs>(WebGrid1_BatchUpdate);
}
void WebGrid1_BatchUpdate(object sender, BatchUpdateEventArgs e)
{
    foreach (WebGridRowChanges changes in e.PendingChanges)
    {
        foreach (WebGridCellData cellChanges in changes.Data)
        {
            string newText = cellChanges.NewText;
               
            // TODO: update your data row to the new text
        }
    }
}

Let me know if the above sample works for you. 

Hope this helps,
James.

Hi Chris,

Try to call coverFlow.RefreshUIElement() after your items source is populated.

Let me know if that works for you.

Hope this helps,
James.