Intersoft Community - WebGrid Enterprise - WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

Glayaar — Sun, 14 Mar 2010 23:43:01 GMT

The next build of WebGrid 7 will be released in a few weeks which already include this feature. The method to bound Hierachical LINQ DataSource to WebGrid will be similar to the WebGrid documentation article "Outbound Mode".

Here is the snippet for InitializeDataSource and PreInitialize event handler for Northwind data:

protected void wgTest_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    NorthwindV2DataContext northwind = new NorthwindV2DataContext();

    var query = from c in northwind.Customers
                select c;

    e.DataSource = query.ToList();

}

protected void wgTest_PreInitialize(object sender, EventArgs e)
{
    NorthwindV2DataContext northwindContenxt = new NorthwindV2DataContext();
    
    // assign OnPreInitialize event in ASPX
    // defines the Object Relations
    ArrayList objectRelations = new ArrayList();
    objectRelations.Add(new WebGridObjectRelation(
            typeof(List<Customer>), "CustomerID", "Orders",
            typeof(List<Order>), "CustomerID"));

    // defines the Parent and Child Type information
    // objectTypes contains 3 object array: The parent collection type,
    // child item type, the primary keys of child collection
    // Primary keys can be string (if only 1 primary key defined),
    // or array of string for multiple primary keys scenario.
    ArrayList objectTypes = new ArrayList();
    objectTypes.Add(new object[] {
        typeof(List<Customer>), typeof(Customer), "CustomerID"});
    objectTypes.Add(new object[] {
        typeof(List<Order>), typeof(Order), "OrderID"});

    // assign the required definitions through SetObjectRelations method
    // the SetObjectRelations need to be called in new PreInitialize method
    // since it needs to be initialized in earliest phase.
    wgTest.SetObjectRelations(objectRelations, objectTypes);

}

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

Glayaar — Wed, 24 Feb 2010 21:19:33 GMT

Sorry for the late reply, you are correct currently WebGrid 7 has not supported this feature yet. However an enchancement is being developed and is scheduled to be ready in the next WebGrid 7 build.

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

nicola.lorusso@loransrl.net — Wed, 24 Feb 2010 10:17:37 GMT

Have you planned a update for this issue?

We need this function before buying WebGrid 7, how much time we must wait?

Thanks, Nicola

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

Glayaar — Wed, 17 Feb 2010 05:11:15 GMT

I am stil discussing this issue with our developer. I will inform you if there is any update / progress regrading this issue.

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

cymdiaz — Mon, 15 Feb 2010 21:50:34 GMT

Greetings,

Can you tell me how to populate a hierarchical datagrid using LinqDataSources? Visual Studio 2010 RC, Windows 7,. As far as I can tell from the documentation this feature is not supported. I don't think this can be true for WebGrid 7, I must be mistaken, but cannot find how to do it.

Thanks

Carlos