Formatting DataBinder Eval data

Question

How can I format data coming from a DataBinder Eval statement in an ASPX page   For example  I want to display the published date of the news items in a particular format in the homepage  I m using the ASP NET 2 0 Repeater control to show the list of news items   The code for this goes like this    lt asp Repeater ID  Repeater1  runat  server  DataSourceID  ObjectDataSource1  gt   lt HeaderTemplate gt  lt table cellpadding  0  cellspacing  0  width  255  gt  lt  HeaderTemplate gt   lt ItemTemplate gt       lt tr gt  lt td  gt               lt a href   content latestNews aspx id  lt   DataBinder Eval Container DataItem   id     gt   gt                   lt asp Label ID  lblNewsTitle  runat  server  Text   lt    DataBinder Eval Container DataItem   title     gt   gt  lt  asp Label gt               lt  a gt       lt  td gt  lt  tr gt       lt tr gt  lt td gt              lt asp Label ID  lblNewsDate  runat  server  Text   lt    DataBinder Eval Container DataItem   publishedDate     gt   gt  lt  asp Label gt       lt  td gt  lt  tr gt   lt  ItemTemplate gt   lt FooterTemplate gt  lt  table gt  lt  FooterTemplate gt  lt  asp Repeater gt    Is there a way I could call a custom method with the DataBinder Eval value as its parameter  something like below     lt asp Label ID  lblNewsDate  runat  server  Text   lt    GetDateInHomepageFormat DataBinder Eval Container DataItem   publishedDate       gt   gt  lt  asp Label gt    If yes  then where do I write the GetDateInHomepageFormat method  I tried out in the code behind page but got a run time error  If this is not possible  is there a way to do inline formatting

User · Answer

You can use a function into a repeater like you said, but notice that the DataBinder.Eval returns an object and you have to cast it to a DateTime.

You also can format your field inline:

<%# ((DateTime)DataBinder.Eval(Container.DataItem,"publishedDate")).ToString("yyyy-MMM-dd") %>

If you use ASP.NET 2.0 or newer you can write this as below:

<%# ((DateTime)Eval("publishedDate")).ToString("yyyy-MMM-dd") %>

Another option is to bind the value to label at OnItemDataBound event.

User · Answer

This line solved my problem    lt   DateTime Parse Eval  DDDate   ToString    ToString  dd-MM-yyyy    gt

User · Answer

Text   lt    DateTime Parse Eval  LastLoginDate   ToString    ToString  MM dd yyyy hh mm tt        This works for the format as you want

User · Answer

After some searching on the Internet I found that it is in fact very much possible to call a custom method passing the DataBinder Eval value   The custom method can be written in the code behind file  but has to be declared public or protected  In my question above  I had mentioned that I tried to write the custom method in the code behind but was getting a run time error  The reason for this was that I had declared the method to be private   So  in summary the following is a good way to use DataBinder Eval value to get your desired output   default aspx   lt asp Label ID  lblNewsDate  runat  server  Text   lt    GetDateInHomepageFormat DataBinder Eval Container DataItem   publishedDate       gt   gt  lt  asp Label gt    default aspx cs code   public partial class  Default   System Web UI Page        protected string GetDateInHomepageFormat DateTime d                 string retValue                   Do all processing required and return value          return retValue            Hope this helps others as well

User · Answer

To format the date using the local date format use    lt     DateTime Eval  ExpDate    ToString  d    gt    How to Format an Eval Statement to Display a Date using Date Locale

User · Answer

After some searching on the Internet I found that it is in fact very much possible to call a custom method passing the DataBinder Eval value   The custom method can be written in the code behind file  but has to be declared public or protected  In my question above  I had mentioned that I tried to write the custom method in the code behind but was getting a run time error  The reason for this was that I had declared the method to be private   So  in summary the following is a good way to use DataBinder Eval value to get your desired output   default aspx   lt asp Label ID  lblNewsDate  runat  server  Text   lt    GetDateInHomepageFormat DataBinder Eval Container DataItem   publishedDate       gt   gt  lt  asp Label gt    default aspx cs code   public partial class  Default   System Web UI Page        protected string GetDateInHomepageFormat DateTime d                 string retValue                   Do all processing required and return value          return retValue            Hope this helps others as well

User · Answer

lt asp Label ID  ServiceBeginDate  runat  server  Text   lt     DataBinder Eval Container DataItem   ServiceBeginDate     0 yyyy        0001          DataBinder Eval Container DataItem   ServiceBeginDate     0 MM dd yyyy      gt   gt   lt  asp Label gt

User · Answer

Why not use the simpler syntax    lt asp Label id  lblNewsDate  runat  server  Text   lt    Eval  publishedDate     0 dddd d MMMM      gt   lt  label gt    This is the template control  Eval  that takes in the expression and the string format   protected internal string Eval  string expression  string format      http   msdn microsoft com en-us library 3d2sz789 aspx

User · Answer

There is an optional overload for DataBinder Eval to supply formatting    lt    DataBinder Eval Container DataItem   expression     format      gt    The format parameter is a String value  using the value placeholder replacement syntax  called composite formatting  like this    lt asp Label id  lblNewsDate  runat  server  Text   lt    DataBinder Eval Container DataItem   publishedDate     0 dddd d MMMM      gt   lt  label gt

User · Answer

There is an optional overload for DataBinder Eval to supply formatting    lt    DataBinder Eval Container DataItem   expression     format      gt    The format parameter is a String value  using the value placeholder replacement syntax  called composite formatting  like this    lt asp Label id  lblNewsDate  runat  server  Text   lt    DataBinder Eval Container DataItem   publishedDate     0 dddd d MMMM      gt   lt  label gt

User · Answer

To format the date using the local date format use    lt     DateTime Eval  ExpDate    ToString  d    gt    How to Format an Eval Statement to Display a Date using Date Locale

User · Answer

After some searching on the Internet I found that it is in fact very much possible to call a custom method passing the DataBinder Eval value   The custom method can be written in the code behind file  but has to be declared public or protected  In my question above  I had mentioned that I tried to write the custom method in the code behind but was getting a run time error  The reason for this was that I had declared the method to be private   So  in summary the following is a good way to use DataBinder Eval value to get your desired output   default aspx   lt asp Label ID  lblNewsDate  runat  server  Text   lt    GetDateInHomepageFormat DataBinder Eval Container DataItem   publishedDate       gt   gt  lt  asp Label gt    default aspx cs code   public partial class  Default   System Web UI Page        protected string GetDateInHomepageFormat DateTime d                 string retValue                   Do all processing required and return value          return retValue            Hope this helps others as well

User · Answer

lt asp Label ID  ServiceBeginDate  runat  server  Text   lt     DataBinder Eval Container DataItem   ServiceBeginDate     0 yyyy        0001          DataBinder Eval Container DataItem   ServiceBeginDate     0 MM dd yyyy      gt   gt   lt  asp Label gt

User · Answer

Thanks to all  I had been stuck on standard format strings for some time  I also used a custom function in VB   Mark Up -   lt asp Label ID  Label3  runat  server  text   lt    Formatlabel DataBinder Eval Container DataItem   psWages1D      gt    gt    Code behind -  Public Function fLabel ByVal tval  As String    fLabel   tval ToString      0 00       0 00   Zero   End Function

User · Answer

After some searching on the Internet I found that it is in fact very much possible to call a custom method passing the DataBinder Eval value   The custom method can be written in the code behind file  but has to be declared public or protected  In my question above  I had mentioned that I tried to write the custom method in the code behind but was getting a run time error  The reason for this was that I had declared the method to be private   So  in summary the following is a good way to use DataBinder Eval value to get your desired output   default aspx   lt asp Label ID  lblNewsDate  runat  server  Text   lt    GetDateInHomepageFormat DataBinder Eval Container DataItem   publishedDate       gt   gt  lt  asp Label gt    default aspx cs code   public partial class  Default   System Web UI Page        protected string GetDateInHomepageFormat DateTime d                 string retValue                   Do all processing required and return value          return retValue            Hope this helps others as well

User · Answer

There is an optional overload for DataBinder Eval to supply formatting    lt    DataBinder Eval Container DataItem   expression     format      gt    The format parameter is a String value  using the value placeholder replacement syntax  called composite formatting  like this    lt asp Label id  lblNewsDate  runat  server  Text   lt    DataBinder Eval Container DataItem   publishedDate     0 dddd d MMMM      gt   lt  label gt

User · Answer

You can use it this way in aspx page   lt    DataBinder Eval Container DataItem   DateColoumnName     0 dd-MMM-yyyy      gt

User · Answer

Text   lt    DateTime Parse Eval  LastLoginDate   ToString    ToString  MM dd yyyy hh mm tt        This works for the format as you want

User · Answer

This line solved my problem    lt   DateTime Parse Eval  DDDate   ToString    ToString  dd-MM-yyyy    gt

User · Answer

You can use a function into a repeater like you said, but notice that the DataBinder.Eval returns an object and you have to cast it to a DateTime.

You also can format your field inline:

<%# ((DateTime)DataBinder.Eval(Container.DataItem,"publishedDate")).ToString("yyyy-MMM-dd") %>

If you use ASP.NET 2.0 or newer you can write this as below:

<%# ((DateTime)Eval("publishedDate")).ToString("yyyy-MMM-dd") %>

Another option is to bind the value to label at OnItemDataBound event.

User · Answer

Why not use the simpler syntax    lt asp Label id  lblNewsDate  runat  server  Text   lt    Eval  publishedDate     0 dddd d MMMM      gt   lt  label gt    This is the template control  Eval  that takes in the expression and the string format   protected internal string Eval  string expression  string format      http   msdn microsoft com en-us library 3d2sz789 aspx

User · Answer

You can use a function into a repeater like you said, but notice that the DataBinder.Eval returns an object and you have to cast it to a DateTime.

You also can format your field inline:

<%# ((DateTime)DataBinder.Eval(Container.DataItem,"publishedDate")).ToString("yyyy-MMM-dd") %>

If you use ASP.NET 2.0 or newer you can write this as below:

<%# ((DateTime)Eval("publishedDate")).ToString("yyyy-MMM-dd") %>

Another option is to bind the value to label at OnItemDataBound event.

User · Answer

There is an optional overload for DataBinder Eval to supply formatting    lt    DataBinder Eval Container DataItem   expression     format      gt    The format parameter is a String value  using the value placeholder replacement syntax  called composite formatting  like this    lt asp Label id  lblNewsDate  runat  server  Text   lt    DataBinder Eval Container DataItem   publishedDate     0 dddd d MMMM      gt   lt  label gt

User · Answer

Thanks to all  I had been stuck on standard format strings for some time  I also used a custom function in VB   Mark Up -   lt asp Label ID  Label3  runat  server  text   lt    Formatlabel DataBinder Eval Container DataItem   psWages1D      gt    gt    Code behind -  Public Function fLabel ByVal tval  As String    fLabel   tval ToString      0 00       0 00   Zero   End Function

User · Answer

You can use a function into a repeater like you said, but notice that the DataBinder.Eval returns an object and you have to cast it to a DateTime.

You also can format your field inline:

<%# ((DateTime)DataBinder.Eval(Container.DataItem,"publishedDate")).ToString("yyyy-MMM-dd") %>

If you use ASP.NET 2.0 or newer you can write this as below:

<%# ((DateTime)Eval("publishedDate")).ToString("yyyy-MMM-dd") %>

Another option is to bind the value to label at OnItemDataBound event.

User · Answer

You can use it this way in aspx page   lt    DataBinder Eval Container DataItem   DateColoumnName     0 dd-MMM-yyyy      gt

[asp.net] Formatting DataBinder.Eval data

Examples related to asp.net

Examples related to formatting

Examples related to repeater

Examples related to databinder