what to use

[chris]

Hi,
I am working on an online timesheet system. Where users will enter hours
they worked from and how long they worked on a oparticular project.

Which datatype would be the best one to use for handling this type of
information? Is it DateTime or is there something better?

Thanks Chris

[Robbe Morris [C# MVP]]

Based on what you've stated, you'll probably want
to use a float, numeric, or decimal data type. Read
up on the precision in SQL Server help (assuming
that is your database).

Definitely don't use an integer and datetime probably
isn't a good fit if your people aren't clocking in and out
on a project.

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

"chris" <ch***@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...

Hi,
I am working on an online timesheet system. Where users will enter hours
they worked from and how long they worked on a oparticular project.

Which datatype would be the best one to use for handling this type of
information? Is it DateTime or is there something better?

Thanks Chris

[chris]

Thanks Robbe. I forgot to mention that the data they are entering hast to be
in this format:

08:30 or 17:30

Thanks again

Chris

"Robbe Morris [C# MVP]" wrote:

Based on what you've stated, you'll probably want
to use a float, numeric, or decimal data type. Read
up on the precision in SQL Server help (assuming
that is your database).

Definitely don't use an integer and datetime probably
isn't a good fit if your people aren't clocking in and out
on a project.

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

"chris" <ch***@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...

Hi,
I am working on an online timesheet system. Where users will enter hours
they worked from and how long they worked on a oparticular project.

Which datatype would be the best one to use for handling this type of
information? Is it DateTime or is there something better?

Thanks Chris

[Bob Powell [MVP]]

In that case use a DateTime.

--
Bob Powell [MVP]
Visual C#, System.Drawing

Ramuseco Limited .NET consulting
http://www.ramuseco.com

Find great Windows Forms articles in Windows Forms Tips and Tricks
http://www.bobpowell.net/tipstricks.htm

Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/faqmain.htm

All new articles provide code in C# and VB.NET.
Subscribe to the RSS feeds provided and never miss a new article.

"chris" <ch***@discussions.microsoft.com> wrote in message
news:11**********************************@microsof t.com...

Thanks Robbe. I forgot to mention that the data they are entering hast to
be
in this format:

08:30 or 17:30

Thanks again

Chris

"Robbe Morris [C# MVP]" wrote:

Based on what you've stated, you'll probably want
to use a float, numeric, or decimal data type. Read
up on the precision in SQL Server help (assuming
that is your database).

Definitely don't use an integer and datetime probably
isn't a good fit if your people aren't clocking in and out
on a project.

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

"chris" <ch***@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...

> Hi,
> I am working on an online timesheet system. Where users will enter
> hours
> they worked from and how long they worked on a oparticular project.
>
> Which datatype would be the best one to use for handling this type of
> information? Is it DateTime or is there something better?
>
> Thanks Chris