Intersoft Community - WebGrid Enterprise - Self-referencing Webgrid Error

Self-referencing Webgrid Error

gkfahnbulleh@lakepiso.com — Sun, 08 Nov 2009 14:28:25 GMT

James, I got it to work. Except that it only goes 1 generation deep.

Self-referencing Webgrid Error

james — Fri, 06 Nov 2009 22:15:20 GMT

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.

Self-referencing Webgrid Error

gkfahnbulleh@lakepiso.com — Fri, 06 Nov 2009 09:02:09 GMT

James I DID Not get it working.

Self-referencing Webgrid Error

james — Thu, 05 Nov 2009 20:09:23 GMT

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.

Self-referencing Webgrid Error

gkfahnbulleh@lakepiso.com — Thu, 05 Nov 2009 07:31:36 GMT

The sample you provide uses a microsoft Access database. I am using SQL Server, and it does not accept a paremeter in the form (ParentID=?) but rather (ParentID=@Param1)

Self-referencing Webgrid Error

james — Thu, 05 Nov 2009 01:37:02 GMT

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

Hope this helps,

James.

Self-referencing Webgrid Error

gkfahnbulleh@lakepiso.com — Wed, 04 Nov 2009 20:42:40 GMT

My webgrid errors when I use the self-referencing feature. Click the Link