在网格视图的绑定字段中显示多个数据字段

本文关键字:字段 显示 数据 视图 绑定 网格 | 更新日期: 2023-09-27 17:52:48

我有以下sql查询,我想在gridview中显示,基本上是连接字段。

我该怎么做?

SELECT 
--RTRIM(C.CustomerFirstName) + ' ' + LTRIM(C.CustomerLastName) as CustomerFullName,
C.CustomerCompany,
C.CustomerPosition, 
C.CustomerCountry, 
C.CustomerProvince, 
C.CustomerContact,
CP.ActionDate, 
CP.ProductCode,
CP.CustomerEmail
     FROM tblCustomers C
    INNER JOIN 
    tblCustomerProducts CP ON 
C.CustomerEmail = CP.CustomerEmail
     ORDER BY ActionDate DESC

这是网格视图的HTML。我想让CustomerFirstName和CustomerLastName放在一个字段

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" 
        GridLines="None" Width="231px" AutoGenerateColumns="False">
        <RowStyle BackColor="#EFF3FB" />
        <Columns>
            **<asp:BoundField DataField="CustomerFirstName" HeaderText="Name" />
            <asp:BoundField DataField="CustomerLastName" HeaderText="Last Name" />**
            <asp:BoundField DataField="CustomerCompany" HeaderText="Company/Organisation" />
            <asp:BoundField DataField="CustomerPosition" HeaderText="Position" />
            <asp:BoundField DataField="CustomerCountry" HeaderText="Country" />
            <asp:BoundField DataField="CustomerProvince" HeaderText="Province" />
            <asp:BoundField DataField="CustomerContact" HeaderText="Contact" />
            <asp:BoundField DataField="CustomerEmail" HeaderText="Email Address" />
            <asp:BoundField DataField="ActionDate" HeaderText="Action Date" />
            <asp:BoundField DataField="ProductCode" HeaderText="Product code" />
        </Columns>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>

在网格视图的绑定字段中显示多个数据字段

您需要的是使用<asp:templatefield>而不是<asp:boundfield>

上面链接中的

步骤2显示了使用templatefield的一种方法。这里是另一个:

<columns>
    <asp:TemplateField  HeaderText="Name">
    <ItemTemplate>
        <div><%#Eval("CustomerFirstName")%>, <%#Eval("CustomerLastName")%></div>
    </ItemTemplate>
<asp:BoundField>
....
</columns>

我添加了<div>,,以显示您可以在<ItemTemplate>中使用基本的文本和html。