DateTime Problem in GridView/DataList

Hi,

I am using an MS SQL Database with a table that has a DateTime column stored in it.

When I try to bind the data inside this table to a GridView and/or DataList the date shows up as (for example) '2010-03-03T00:00:00+01:00'.

In my GridView I tried to format that datetime by using the following 'BoundField' tag;

<asp:BoundField DataField="NewsDateEntered" HeaderText="Date Entered" DataFormatString = "{0:dd/MM/yyyy}" HtmlEncode="False" />

This is still wielding no results and I have tried to recreate the table and so on. Does anyone have any idea what my problem could be please?

Thanks

Mar 17 '10 #1

Subscribe Post Reply

2193

CroCrew

564

Expert 512MB

Can you show the code that you are using to bind the data so we can help. Also, in the database how is that being stored? String, dataTime, or other?

CroCrew~

Mar 24 '10 #2

CroCrew

564

Expert 512MB

Without seeing your code it is hard to help. Here is an example that might help you out a bit.

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default10.aspx.vb" Inherits="Default10" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

    <head runat="server">

        <title></title>

    </head>

    <body>

        <form id="form1" runat="server">

            <div>

                <asp:DataGrid ID="Grid" runat="server" AutoGenerateColumns="False" GridLines="None">

                    <Columns>

                        <asp:BoundColumn DataField="NewsDateEntered" HeaderText="Date Entered" DataFormatString="{0:dd/MM/yyyy}" />

                    </Columns>

                </asp:DataGrid>            

            </div>

        </form>

    </body>

</html>

Expand|Select|Wrap|Line Numbers

 
Imports System.Data
 
Partial Class Default10

    Inherits System.Web.UI.Page
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim mydatatable As New DataTable

        mydatatable.Columns.Add("NewsDateEntered", Type.GetType("System.String"))

        Dim myrow As DataRow
 
        myrow = mydatatable.NewRow

        myrow("NewsDateEntered") = DateTime.Parse("2010-03-03T00:00:00+01:00")

        mydatatable.Rows.Add(myrow)
 
        Grid.DataSource = mydatatable

        Grid.DataBind()

    End Sub

End Class

We could help out more if we could see all your code.

Happy Coding,
CroCrew~

Mar 24 '10 #3

by: s.gregory | last post by:

My page layout is like this: Page >DataList (databound using ObjectDataSource1 contained in page) >>Items >>>UserControl >>>>GridView (databound using another ObjectDataSource2 contained in...

ASP.NET

FindControl to reference nested controls in gridview/listview

by: Martin | last post by:

Hi, I have a very frustrating problem that I have researched for countless hours to no avail. There are many posts asking very similar things, however none usefull in my situation. I am using VS...

ASP.NET

Reference GridView?

by: staeri | last post by:

I want to count the rows in a GridView which is nested into a DataList but I can't find the correct syntax for this. Can someone please help me with this and also tell me how to reference a text...

ASP.NET

Gridview question

by: Bishop | last post by:

I want to find out if there is a way to use the gridview to list products simular to the listing on this page:...

ASP.NET

GridView nested in DataList - refreshing corresponding DataList row after updating GridView row

by: H5N1 | last post by:

Hi there My problem is that in when I update GridView row, which is nested into DataList control, I want to refresh also DataList in which the GridView is nested, since after update, trigger in...

ASP.NET

Cannot rebind GridView nested in DataList

by: H5N1 | last post by:

Hello everybody I'm stuck for a long time with the following problem, so I will be really gratefull if you could help me a bit: I have a GridView nested in DataList (it's located in DataList's...

ASP.NET

Nested Information (DataList + GridView) Question

by: ammar_fake | last post by:

Hello there. I need a DataList to render the Gridview by providing one of the DataList values as a query for the underlaying Gridview. This does not work: SelectCommand="select * from...

ASP.NET

gridview inside datagrid doen't raise RowCommand event

by: =?Utf-8?B?cGF0cmlja2RyZA==?= | last post by:

Hi all! I have a gridview inside a datagrid (nested) for which (gridview) the rowcommand is not raised in order to delete a row from the grid! I also tried OnRowCommand="method", didn't work...

ASP.NET

DataGridView, GridView and DataList

by: Randy | last post by:

In VS 2005, in the Windows Controls, you have the DataGridView (which has scrollbars). In the WebControls, is the GridView or the DataList synonymous with the DataGridView? Can you have...

C# / C Sharp

Gridview + Datalistview

by: OuTCasT | last post by:

Hi all. here is my dilemma. i have 4 dropdownlisboxes on my web page. you select each value from the listboxes and the results are displayed on a gridview on the same page. the gridview has a...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

DateTime Problem in GridView/DataList

Similar topics