填充基于详细信息视图中的绑定列的文本框 - 空值问题

发布于 2024-10-12 07:49:59 字数 558 浏览 4 评论 0原文

我正在尝试从详细信息视图中的绑定文本字段填充日期。当列中存在 DBNull 时，我不断收到错误消息。填充文本字段时如何避免 DBNull。对此的任何帮助都会很茫然。

我的代码如下：

 <asp:TemplateField HeaderText="CBYD Clear Date">
              <EditItemTemplate>
                  <asp:TextBox ID="CBYDExpDate" runat="server" ReadOnly="true" Text='<%# IIf(Eval("CBYDDate") is DBNull.Value,"", String.Format("{0:MM/dd/yyyy}", Eval("CBYDDate").AddDays(30)))%>' />                                                      
          </EditItemTemplate>
    </asp:TemplateField>

原文

I'm trying to populate a date from a bound text field in a DetailsView. I keep getting a error when a DBNull is in the column. How do I avoid the DBNull when populating the text field. Any Help on this would be great at a loss.

My code is as follows:

 <asp:TemplateField HeaderText="CBYD Clear Date">
              <EditItemTemplate>
                  <asp:TextBox ID="CBYDExpDate" runat="server" ReadOnly="true" Text='<%# IIf(Eval("CBYDDate") is DBNull.Value,"", String.Format("{0:MM/dd/yyyy}", Eval("CBYDDate").AddDays(30)))%>' />                                                      
          </EditItemTemplate>
    </asp:TemplateField>

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

山田美奈子 2024-10-19 07:49:59

最简单的方法是在您调用的代码隐藏中定义一个函数：

Text='<%# getDateText(Eval("CBYDDate"),"{0:MM/dd/yyyy}", 30) %>'

并在代码隐藏中定义一个函数：

 Protected Function getDateText(ByVal value As Object, ByVal dateFormatString As String, ByVal addDays As Int32) As String
     If value Is Nothing OrElse value Is DBNull.Value Then
         Return String.Empty
     ElseIf TypeOf value Is Date Then
         Dim d As Date = DirectCast(value, Date)
         Return String.Format(dateFormatString, d.AddDays(addDays))
     Else
         Return value.ToString
     End If
 End Function

有关其他信息，请参阅 MSDN

The simpliest would be to define a function in codebehind that you call:

Text='<%# getDateText(Eval("CBYDDate"),"{0:MM/dd/yyyy}", 30) %>'

and in codebehind:

 Protected Function getDateText(ByVal value As Object, ByVal dateFormatString As String, ByVal addDays As Int32) As String
     If value Is Nothing OrElse value Is DBNull.Value Then
         Return String.Empty
     ElseIf TypeOf value Is Date Then
         Dim d As Date = DirectCast(value, Date)
         Return String.Format(dateFormatString, d.AddDays(addDays))
     Else
         Return value.ToString
     End If
 End Function

For additional informations have a look at MSDN

回复收藏 0 原文

~没有更多了~