如何在 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>

Answer 1

尝试列名和表名编辑&nbsp; &nbsp; &nbsp; &nbsp; var show = (from u in database.tbl_SubUser&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; join shop in database.tbl_Shop on u.UserID_FK equals shop.ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; orderby u.SubUserID descending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select new&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; u.UserID_FK,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; u.Name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; u.SubUserID,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; u.Day,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ShopName = shop.Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }).ToList();&nbsp; &nbsp; e.Result = show;