c# - 如何在 DataGridView 单元格中显示 Linq 查询

Question

如何在 DataGridView 单元格中显示 Linq 查询？

我想在 BoundField 中显示查询查看评论中的图片

我想改变这个

改变这张照片

后端：

var show = (from u in database.tbl_SubUser
            orderby u.SubUserID descending
            select new
            {
                u.UserID_FK,
                u.Name,
                u.SubUserID,
                u.Day
            }).ToList();
e.Result = show;

正面 ：

 <asp:GridView ID="grdShowListSubUser" Width="100%" AutoGenerateColumns="false" DataSourceID="dsshowlistSubuser2" runat="server" CssClass="table table-bordered table-condensed table-hover table-responsive" OnRowCommand="grdShowListSubUser_RowCommand" AlternatingRowStyle-BackColor="AliceBlue" AllowPaging="true">
                            <Columns>
                                <asp:TemplateField HeaderText="ردیف" HeaderStyle-BackColor="Moccasin">

                                    <ItemTemplate>
                                        <asp:Label ID="lblRowCount" runat="server" Text='<%#Container.DataItemIndex + 1 %>'></asp:Label>
                                    </ItemTemplate>

                                </asp:TemplateField>

                                <asp:BoundField DataField="Name" HeaderText="نام شعبه" NullDisplayText="" HeaderStyle-BackColor="Moccasin" />

                                <asp:BoundField DataField="day" HeaderText="مدت اعتبار" NullDisplayText="" HeaderStyle-BackColor="Moccasin" />

                                   <asp:BoundField DataField="UserID_FK" HeaderText="زیرمجموعه"  NullDisplayText="" HeaderStyle-BackColor="Moccasin" />




                                <asp:TemplateField HeaderText="عملیات" HeaderStyle-BackColor="#33cccc">
                                    <ItemTemplate>

                                       <asp:LinkButton ID="lbtnDelete" runat="server" Text="حذف" CssClass="btn btn-danger btn-xs" CommandName="DoDelete" OnClientClick="return confirm('با حذف این کاربر کلیه اطلاعات مرتبط حذف خواهد شد .ایا میخواهید این کاربر حذف شود؟')" CommandArgument='<%# Eval("SubUserID") %>'></asp:LinkButton>




                                        <asp:LinkButton ID="lbtnEdit" runat="server" Text="ویرایش" CssClass="btn btn-info btn-xs" CommandName="DoEdit" CommandArgument='<%#Eval("SubUserID")%>'></asp:LinkButton>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>

标签： c#asp.netlinq

Answer 1

尝试列名和表名编辑

        var show = (from u in database.tbl_SubUser
                join shop in database.tbl_Shop on u.UserID_FK equals shop.ID
                orderby u.SubUserID descending
                select new
                {
                    u.UserID_FK,
                    u.Name,
                    u.SubUserID,
                    u.Day,
                    ShopName = shop.Name

                }).ToList();
    e.Result = show;