gridview绑定，如果T1这一列中的某一行的值为15:00，则这一单元格不显示内容，为空

Question

而其他T2、T3列绑定的数据能正常显示

Answer 1

   public void bind()
        {
            SqlConnection sqlcon;
            string strCon = "Data Source=(local);Database=aspnetdb;Uid=sa;Pwd=123";
            string sqlstr = "select ID,booktime,DATENAME(weekday,booktime) as weekday ,T1 ,T2,T3from (select id,T1 ,T2,T3 datename(week,booktime)as week,booktime from [aspnetdb].[dbo].[book]) b where week=(select DATENAME(WEEK,getdate()))";
            sqlcon = new SqlConnection(strCon);
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
            DataSet myds = new DataSet();
            myda.Fill(myds, "book");
            DataView view = myds.Tables["book"].DefaultView;            this.GridView1.DataSourceID = null;
            GridView1.DataSource = view;
            GridView1.DataBind();
            GridView1.ShowFooter = true;
        }

Answer 2

在sql语句里做处理,如果等于15:00返回值是空.string sqlstr = "select ID,booktime,DATENAME(weekday,booktime) as weekday ,T1 ,T2,T3 
from (select id,T1=case when T1='15:00' then '' else T1 end ,T2,T3 datename(week,booktime)as week,booktime from [aspnetdb].[dbo].[book]) b 
where week=(select DATENAME(WEEK,getdate()))";

Answer 3

调整一点string sqlstr = "select ID,booktime,DATENAME(weekday,booktime) as weekday ,T1 ,T2,T3 
from (select id,T1=case when T1='15:00' then null else T1 end ,T2,T3 datename(week,booktime)as week,booktime from [aspnetdb].[dbo].[book]) b 
where week=(select DATENAME(WEEK,getdate()))";

Answer 4

<asp:GridView ID="gvList" runat="server" AutoGenerateColumns="False" Width="100%"
                CssClass="TAB" HorizontalAlign="Center" OnRowDataBound="gvList_RowDataBound">
                <Columns>
                    <asp:TemplateField HeaderText="年月">
                        <ItemStyle HorizontalAlign="Center" Width="60px" />
                        <ItemTemplate>
                            <input name="id" type="hidden" value='<%# Eval("id") %>' />
                            <%# Eval("year") %>-<%# Eval("month") %><br />
                            <asp:HyperLink ID="hlRe" runat="server" Visible="false">查看备注</asp:HyperLink></ItemTemplate>
                    </asp:TemplateField>模板列