Re: GridView databinding to LINQ join query

Qin Dian Tang - MSFT — Mon, 24 Nov 2008 02:44:01 GMT

Hi rozialishah,

I think you can try to bind the property name directly in GridView. For me, if you bind any object such as List<>, I just use property name to bind the control. Not quite sure about your case, but just try it.

Thanks,

Re: GridView databinding to LINQ join query

rozialishah — Fri, 21 Nov 2008 14:03:58 GMT

Thanks you,

It works the way the article explain but I was wondering if we could directly access object.property in the bound field of grid view.

Syed

Re: GridView databinding to LINQ join query

Qin Dian Tang - MSFT — Fri, 21 Nov 2008 07:47:27 GMT

Hi rozialishah,

Have a look at this article: http://tiredblogger.wordpress.com/2007/07/11/table-joins-in-linq-good-bad-and-complexly-ugly/

Thanks,

GridView databinding to LINQ join query

rozialishah — Tue, 18 Nov 2008 23:03:28 GMT

Hi,

I am having gridview which is binded to the linq query as folllowing

Public Overridable Function getInventoryWorksheet(ByVal OrderDetailspredicates As List(Of Expression(Of Func(Of Order_Detail, Boolean))), _
                                                      Optional ByVal Productpredicates As List(Of Expression(Of Func(Of Product, Boolean))) = Nothing) As IQueryable
        ' These predicates will build the where condition for the query at run time
        Dim OrderDetailspredicate = PredicateBuilder.True(Of Order_Detail)()
        Dim Productpredicate = PredicateBuilder.True(Of Product)()
        ' Combine the predicates by And
        Productpredicate = PredicateBuilder.CombinePredicates_And(Productpredicates)
        OrderDetailspredicate = PredicateBuilder.CombinePredicates_And(OrderDetailspredicates)
        Dim db = New MyLinQDatabaseDataContext
        Dim orderDetails = From current In db.Order_Details.Where(OrderDetailspredicate)
        Dim groups = From mygroup In orderDetails.GroupBy(Function(group As Order_Detail) group.ItemID) Select New With _
                       { _
                        .ItemID = mygroup.Key, _
                        .QtyOrdered = mygroup.Sum(Function(group As Order_Detail) group.QTYOrdered), _
                        .QtyShipped = mygroup.Sum(Function(group As Order_Detail) group.QtyShiped) _
                       }
        ' Dim result = groups.Join(
        Dim groupdata = (From OD In groups Join Products In db.Products.Where(Productpredicate) On OD.ItemID Equals Products.SKU).DefaultIfEmpty
        'Dim datatable = groupdata.ToADOTable()
        'Dim stil = From testt In groupdata Select 
        Return groupdata

 End Function

So my groupdata is Iquerable of two objects OD {ItemID,QtyOrdered,QtyShipped} and a complete Products object.

I want to databind the gridview to groupdata Please see my code below

  <asp:GridView ID="GvInventoryWorkSheet" AllowPaging="false"  AllowSorting="True"  width="800px"  
        PageSize="20"  AutoGenerateColumns="False"    
        runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" >
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
       <PagerStyle CssClass="PagerStyle" />
       <PagerSettings PageButtonCount="5" Position="TopAndBottom" Mode="NumericFirstLast"   FirstPageText="First" LastPageText="Last" />
        <RowStyle CssClass="customerListNormal" BackColor="#F7F6F3" 
            ForeColor="#333333" />
        <Columns>
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:CheckBox ID="aspxCBX"   ToolTip='<%# DataBinder.Eval(Container.DataItem, "OD.ItemID") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
           <asp:BoundField  ItemStyle-Width="80px" HeaderText="Item No." DataField="OD.ItemID" SortExpression="OD.ItemID" />
           <asp:BoundField  ItemStyle-Width="80px" HeaderText="SKU" DataField="Products.SKU" SortExpression="Products.SKU" />
        </Columns>
        <PagerStyle  CssClass="GvPagerRow" />
        
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle CssClass="GvHeader" />
        <EditRowStyle BackColor="#999999" />
        <AlternatingRowStyle CssClass="customerlistAlternate" BackColor="White" 
            ForeColor="#284775" />
    </asp:GridView>

But it say OD.ItemID is not a dataItem of the datasource. Can anybody tell me how can I acheive this functionality.

Thank,

Syed

Data Presentation Controls

Re: GridView databinding to LINQ join query

Re: GridView databinding to LINQ join query

Re: GridView databinding to LINQ join query

GridView databinding to LINQ join query