473,320 Members | 1,949 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem with date in dataset. Need help. Thanks.

Hello,

In the [pubDate] field of a dataset the content in each row has the
format:
Fri, 20 May 2005 12:30:00 GMT

When I use:
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>

the content is not being recognized as a date.
Well, at least it is not formatted as a date. It just shows the text.

Why? How can I solve this?

Thanks,
Miguel

Nov 19 '05 #1
2 800
==><%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>
to :
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:r}") %>

"Shapper" wrote:
Hello,

In the [pubDate] field of a dataset the content in each row has the
format:
Fri, 20 May 2005 12:30:00 GMT

When I use:
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>

the content is not being recognized as a date.
Well, at least it is not formatted as a date. It just shows the text.

Why? How can I solve this?

Thanks,
Miguel

Nov 19 '05 #2
Hello,

I tried that. It's still the same.
It shows the entire text.

I have no idea what is going on.

Can someone tell me what is wrong here?

Thanks,
Miguel

"cuike519" <cu******@discussions.microsoft.com> wrote in message
news:cu******@discussions.microsoft.com:
==><%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>
to :
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:r}") %>

"Shapper" wrote:

Hello,

In the [pubDate] field of a dataset the content in each row has the
format:
Fri, 20 May 2005 12:30:00 GMT

When I use:
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>

the content is not being recognized as a date.
Well, at least it is not formatted as a date. It just shows the text.

Why? How can I solve this?

Thanks,
Miguel


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Wayne Wengert | last post by:
I am using VS.NET 2003, VB.NET, ADO.NET and an Access 2000 database. I want to display a list of all tables in an Access database. I want to put that list of table names in a listbox so the user...
7
by: Andy Davis | last post by:
I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which...
6
by: Omar | last post by:
When I try to databind my comboBox (specifically field "emplcode") to a filled dataset , the contents of the comboBox displays a bunch of "System.Data.DataRowView". I assume the amount of times...
5
by: junglist | last post by:
Hi guys, I've been trying to implement an editable datagrid and i have been succesful up to the point where i can update my datagrid row by row. However what used to happen was that once i updated...
0
by: Shapper | last post by:
Hello, I have an ASP.Net Repeater where I display a date from a date field: <%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %> When the dataset is created from a database the date...
4
by: Girish | last post by:
Im trying to create a grid within a grid programmatically. Ive been successful in doing this but I need the embedded grid to fire its ItemDataBound event so I can handle it. The event does not seem...
8
by: Dave Hagerich | last post by:
I'm using a DataGrid with a DataSet and I'm trying to filter the data being displayed, using the following code as a test: DataView theView = new DataView(theDataSet.Tables); theView.RowFilter =...
6
by: Bill Nguyen | last post by:
I'm reading a CSV file with the date colum formatted as "YYMMDD" -"070310" when viewed in notepad or similar trext editor. However, in my app, using ODBCReader, the column value becomes "70310"...
0
by: webaccess | last post by:
Hi Friends ..!! I want to use datagrid/dataview control to data in tablular format,also I want to add paging and format the data of table column. Problem is data is coming from API Dom in as...
2
by: yogarajan | last post by:
hello friend i need urgent help this is my aspx page <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Reguserdetailstest.aspx.cs" Inherits="Reguserdetailstest" %> <!DOCTYPE html...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.