DaniWeb Forum Index > Software Development > C#

C# RSS

problem getting short time from an MS access database

Please support our C# advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2009

Posts: 20

Reputation: ejazmusavi is an unknown quantity at this point

Solved Threads: 0

ejazmusavi ejazmusavi is offline

Offline

Newbie Poster

problem getting short time from an MS access database

Jun 19th, 2009

Hi
Every one.
I have an MS access database table in which i have stored a data type of date/time in short time format.
When i access the table from c# and diplay it into a data grid view the column in short time format diplay as long time format
i.e, i have stored (10:10) in data base table but in c# it display like (16/06/2009.10:10:00 AM) in data gridview
how i can get the only short time from this table?
Please any one to help me.......

•

Join Date: Mar 2008

Posts: 268

Reputation: Traicey is an unknown quantity at this point

Solved Threads: 19

Traicey

Offline

Posting Whiz in Training

Re: problem getting short time from an MS access database

Jun 19th, 2009

I think you might wana consider having something like this txtDate.Text = DateTime.Today.ToShortTimeString();
in ur code, its hard to tell coz u havent post any code to see where u might be going wrong

the code above will display in a text box "12:00 AM", u can also omit AM if u want to

Last edited by Traicey; Jun 19th, 2009 at 5:42 am.

Some people get so rich they lose all respect for humanity. That's how rich I want to be.

•

Join Date: Oct 2008

Posts: 2,612

Reputation: adatapost has much to be proud of

Solved Threads: 464

adatapost

Offline

Posting Maven

Re: problem getting short time from an MS access database

Jun 19th, 2009

Use DefaultCellStyle.Format property.
I presume that the column number 3rd is of date datatype.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 dataGridView1.Columns[2].DefaultCellStyle.Format = "HH:mm:ss";
 dataGridView1.Columns[2].DefaultCellStyle.Format = "HH:mm:ss";