Intersoft Community - WebGrid Enterprise - Simple question on binding to complex object

Simple question on binding to complex object

samtran0331 — Mon, 29 Mar 2010 09:58:10 GMT

Glenn,

Thank you for your help.

Your example works fine.

However, there is still something wrong within my class file...it binds perfectly well in all other data controls..but not WebGrid.

I needed to move on so I just re-wrote the query and object so that it would work with Webgrid.

Thanks for your help though!

Simple question on binding to complex object

Glayaar — Thu, 18 Mar 2010 21:36:27 GMT

Attached is the sample code ported to VB. Running the snippet you provided does not result in any issue in my environment. However, in the data generation, you did not insert the StructID and StructDesc property so the displayed column will be empty.

Please see the attached sample for the lambda expression in assigned the property during creating a new instance

Simple question on binding to complex object

samtran0331 — Thu, 18 Mar 2010 08:54:31 GMT

Thanks so much for your help Glenn.

Sorry to say that I'm working in VB.Net and while I can get your C# example to work, when I translate the code to VB.Net, it doesn't work.

Both projects have the same references. Both test pages have the same html/code on the aspx page.

I'm inserting the VB codebehind, which should be an exact translation of your C# example, can you see what would make it not work??

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data

Partial Public Class _Default
    Inherits System.Web.UI.Page

    Public dt As DataTable

    Private Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
        If dt Is Nothing Then
            dt = New DataTable("Parent")
            dt.Columns.Add("ID")
            dt.Columns.Add("Name")
            dt.Columns.Add("Author")
            dt.Columns.Add("CustomObj", GetType([Object]))
            dt.Rows.Add(New Object() {1, "B1", "A1", New CustomStruct()})
            dt.Rows.Add(New Object() {2, "B2", "A2", New CustomStruct()})
            dt.Rows.Add(New Object() {3, "B3", "A3", New CustomStruct()})
            dt.Rows.Add(New Object() {4, "B4", "A4", New CustomStruct()})
        End If

    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        With Me.GridView1
            .DataSource = Me.dt
            .AutoGenerateColumns = False
            .DataBind()
        End With
    End Sub

    Protected Sub TestInitializeDataSource(ByVal sender As Object, ByVal e As ISNet.WebUI.WebGrid.DataSourceEventArgs)
        e.DataSource = Me.dt
    End Sub

End Class

Public Class CustomStruct
    Private _StructID As String
    Public Property StructID() As String
        Get
            Return _StructID
        End Get
        Set(ByVal value As String)
            _StructID = value
        End Set
    End Property

    Private _StructDesc As String
    Public Property StructDesc() As String
        Get
            Return _StructDesc
        End Get
        Set(ByVal value As String)
            _StructDesc = value
        End Set
    End Property
End Class

Simple question on binding to complex object

Glayaar — Wed, 17 Mar 2010 23:25:32 GMT

In my test the template cell method works. Attached is the sample page I used to test the template cell.

I create a simple datatable with a column which hold a complex object which is bound to WebGrid and GridView. The data is shown correctly in both WebGrid and GridView.

I am already using the latest build of WebGrid 7 and WebUI Framework

Simple question on binding to complex object

samtran0331 — Wed, 17 Mar 2010 08:23:27 GMT

Hi Glenn,

Thanks for the response, but I tried that already and got the error:

DataBinding: 'System.DBNull' does not contain a property with the name 'ETID'.

I've also tried brackets around the Eval like this:

<asp:Label ID="Label1" runat="server" Text='<%# Eval("[Sunday.ETID]") %>'></asp:Label>

and get the error:

DataBinding: '[Sunday' is not a valid indexed expression.

I've also tried this:

<ISWebGrid:WebGridColumn Caption="Sun ETID" Name="SunETID" ColumnType="Template" DataMember="Sunday">
<CellTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("ETID") %>'></asp:Label>
</CellTemplate>
</ISWebGrid:WebGridColumn>

Which returns the error:

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ETID'.

I'm inserting my test page as a code snippet...it includes a standard Gridview, a telerik RadGrid, and an Intersoft Webgrid...also note that I have a test page with nothing but the Webgrid and it still doesn't work.

The Webgrid is the only control that won't bind to "Sunday.ETID"

Thanks for your help!

    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
    </telerik:RadScriptManager>
    <asp:GridView ID="GridView1" runat="server">
        <Columns>
            <asp:BoundField DataField="Client" HeaderText="Client" ReadOnly="True" SortExpression="Client" />
            <asp:BoundField DataField="JobDesc" HeaderText="Job" SortExpression="Job" />
            <asp:TemplateField HeaderText="Sun ETID">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Sunday.ETID") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <br />
    <telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None">
        <mastertableview>
        <RowIndicatorColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>
        <ExpandCollapseColumn>
        <HeaderStyle Width="20px"></HeaderStyle>
        </ExpandCollapseColumn>
            <Columns>
                <telerik:GridBoundColumn UniqueName="column1" DataField="Client" HeaderText="Client">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="column2" DataField="JobDesc" HeaderText="Job">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="column3" DataField="Sunday.ETID" HeaderText="Sun ETID">
                </telerik:GridBoundColumn>
            </Columns>
        </mastertableview>
    </telerik:RadGrid>
    <br />
    <ISWebGrid:WebGrid ID="WebGrid1" runat="server" UseDefaultStyle="True" Height="600px"
        DefaultStyleMode="Elegant" Width="90%">
        <LayoutSettings AllowAddNew="Yes" AllowColumnFreezing="Yes" AllowColumnMove="No"
            AllowDelete="Yes" AllowEdit="Yes" AllowExport="Yes" AllowFilter="No" AllowGrouping="No"
            AllowMultipleSelection="Yes" AllowSelectColumns="Yes" AllowSorting="Yes" AutoFitColumns="True"
            ShowRefreshButton="true" AutoWidth="True" ColumnFooters="No" GroupByBoxVisible="False"
            AllowContextMenu="False">
        </LayoutSettings>
        <RootTable>
            <Columns>
                <ISWebGrid:WebGridColumn Name="WebGridColumn0" Width="100px" DataMember="Client">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Name="WebGridColumn1" Width="100px" DataMember="JobDesc">
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Name="WebGridColumn2" Width="100px" DataMember="Sunday"
                    ColumnType="Template">
                    <CellTemplate>
                        <asp:Label ID="Label1" runat="server" Text='Hello'></asp:Label>
                    </CellTemplate>
                </ISWebGrid:WebGridColumn>
                <ISWebGrid:WebGridColumn Caption="Sun ETID" Name="SunETID" ColumnType="Template" DataMember="Sunday">
                    <CellTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ETID") %>'></asp:Label>
                    </CellTemplate>
                </ISWebGrid:WebGridColumn>
            </Columns>
        </RootTable>
    </ISWebGrid:WebGrid>
    </form>

Simple question on binding to complex object

Glayaar — Wed, 17 Mar 2010 04:24:30 GMT

You will need to use similar method with the Grid View. You will need to use cell template in order to bind complex object property. Here is the snippet:

<ISWebGrid:WebGridColumn Caption="Sun ETID" Name="SunETID" ColumnType="Template">
<CellTemplate>
    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Sunday.ETID") %>'></asp:Label>
</CellTemplate>
</ISWebGrid:WebGridColumn>

Simple question on binding to complex object

samtran0331 — Tue, 16 Mar 2010 09:57:17 GMT

Hi,

I'm trying to bind a complex object and can't figure out how to do it using WebGrid.

With a normal ASP.Net GridView control, I can do this:

<asp:TemplateField HeaderText="Sun ETID">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Sunday.ETID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

With a Telerik RadGrid, I can do this:

<telerik:GridBoundColumn UniqueName="column3" DataField="Sunday.ETID" HeaderText="Sun ETID">
</telerik:GridBoundColumn>

My datasource is an object called "Timesheet" this is the datasource for the grids.

Within the Timesheet object is another collection of objects for each day of the week.

That is why I can bind to "Sunday.ETID"..."Sunday" is an object within "Timesheet"

And "Sunday" has a property called "ETID".

What would be the syntax to bind a column using Intersoft WebGrid?

Thanks!