如何显示GridView控件中的空数据行 [英] How to show empty data row in gridview control

问题描述

在这里，我用的GridView在这里工作是gidview结合

Here I am working with gridview here is the gidview binding

conn = new SqlConnection(strconnection);
string squery = "sql query";

da = new SqlDataAdapter(squery, conn);
ds = new DataSet();
da.Fill(ds, "tbl1");

GridView1.DataSource = ds;
GridView1.DataBind();

这GridView控件ASP code

This the gridview control asp code

<asp:GridView ID="GridView1" runat="server" GridLines="None" 
     HeaderStyle-CssClass="grid_header" 
     RowStyle-CssClass="grid_item" 
     RowStyle-Height="30px"  
     AutoGenerateColumns="false" Width="775px" EmptyDataText="Empty">
   <Columns>
      <asp:BoundField HeaderText="Order Code" DataField="ordercode" 
           HeaderStyle-HorizontalAlign="Left" 
           ItemStyle-HorizontalAlign="Left"  />
      <asp:BoundField HeaderText="Transation Code" DataField="transcode"  
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Plan Name" DataField="product" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Plan Started" DataField="Start_d" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Plan Ending" DataField="End_d" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:CheckBoxField HeaderText="Payed" DataField="Payed" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Pay Date" DataField="PayDate" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Payed Amt" DataField="amtpaid" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
      <asp:BoundField HeaderText="Pay Amt" DataField="PayAmount" 
           HeaderStyle-HorizontalAlign="Center" 
           ItemStyle-HorizontalAlign="Center" />
   </Columns>
</asp:GridView>

这是结果EMP这样

 Header1 header2 header3 header4 
     1       asdas   22sdas  asdasda
     2       sasa             asdasas
     3       asdas  
     4                         asdasas

这样的结果。

下面我的问题是我想说明的空地方只是显示空消息。我该怎么做？

Here my problem is I want show the NULL places just show the "EMPTY" Message. How can I do that?

推荐答案

您可以使用 NullDisplayText =空 NullDisplayText属性

<asp:BoundField DataField="transcode"
        NullDisplayText="EMPTY"
        HeaderText="header2"/>

如果取之于你的数据库来是不是 NULL ，但一个空字符串，你将需要使用模板字段

If what is coming from your DB is not NULL but an empty string, you will need to use template field

<asp:TemplateField HeaderText="header2">
<ItemTemplate>
    <%# Eval("transcode").ToString() == "" ? "EMPTY" : Eval("transcode").ToString() %>
</ItemTemplate>
</asp:TemplateField>

这篇关于如何显示GridView控件中的空数据行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！