Datagrid date problem from db..

[Andi03]

Hi.

 

I use a datagrid to present my info from my db. In my db (Access) I have a filed name RegDate (datatype Date/time). I use this SQL to get the date.

"SELECT RegDate As Registration FROM tblMembers"

 

The I present the info from db into the datagrid. But The date is formated like this:

 

2003-09-15 00:00:00

 

But in the database the date is this: 2003-09-15...

 

Why does the datagrid add 00:00:00 (it just zeroes)???

 

Plz...help me...

 

//Andi

[Robby]

look here http://ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpcondatetimeformatstrings.htm

[Andi03]

I cant view/open it....

[Robby]

Do you have the .NET help files installed?

[Andi03]

I don't have VS.NEt installed but I have .NEt framework 1.1 SDk

[Robby]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp

[andrewsc]

PMJI, it is preferable to jump in rather than starting a new thread with an identical question. Yes, I can see the local help file, but the problem comes at an earlier point in the design. Perhaps the original question also come from this angle.

 

I've created a datagrid at design time, and now I need to specify something like:

 

- the format for column 2 is "dd-MMM-yyyy HH:mm:ss"

- the format for column 7 is "dd-MM-yy"

 

The point is not whether the formats above are correct, or whether I identify a column by name or by number. From VB6 practice, I've expected a Columns collection hanging off the datagrid or the OleDbAdapter. Could not find such thing.

 

How do I access properties for individual columns in a datagrid ?

 

Andrew

[Robby]

If you are doing this at design time then add a property to the 'asp:BoundColumn'... something like this...

 

DataFormatString="{0:g}"