473,407 Members | 2,320 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,407 software developers and data experts.

Seeking Design Advice

Hello!

I'm creating an application where users can enter their hours worked on
certain projects and have them saved to a database. Right now there are
about 60 different projects and that number can increase or decrease at
any time.

I'm looking for some advice on how to best design the windows form for
users to enter hours for the projects they worked on that week. I was
thinking about using a comboBox to list each project with a text box to
enter hours. The user would be presented with update and save buttons.
The update button would save the current project's hours to a class and
the save button would write all the saved info to the database. Is
there a better way to do this?

I apologize for posting such a trivial question. This is my first real
VB.NET application so it's still a learning process :-)

--
Jerry

Jul 14 '06 #1
4 1016
AK
Jerry,

RE: Saving to a class -

Maybe I am missing something, but wouldn't you want to add the current hours
to the project hours and save that to the database? Or better yet have the
database keep the log of the days and hours worked and the worker that
worked them, from which a query could be run at will or at run time (say in
a manegement function report module) to accumulate and report the hours.

AK
"Jerry" <je*******@gmail.comwrote in message
news:11**********************@35g2000cwc.googlegro ups.com...
Hello!

I'm creating an application where users can enter their hours worked on
certain projects and have them saved to a database. Right now there are
about 60 different projects and that number can increase or decrease at
any time.

I'm looking for some advice on how to best design the windows form for
users to enter hours for the projects they worked on that week. I was
thinking about using a comboBox to list each project with a text box to
enter hours. The user would be presented with update and save buttons.
The update button would save the current project's hours to a class and
the save button would write all the saved info to the database. Is
there a better way to do this?

I apologize for posting such a trivial question. This is my first real
VB.NET application so it's still a learning process :-)

--
Jerry

Jul 16 '06 #2
Currently they add their total hours to an Excel spreadsheet on a
weekly basis. They would like to continue on that same schedule and
process but would like to use a VB.NET application to store the data in
the database instead of the spreadsheet.

--
Jerry
AK wrote:
Jerry,

RE: Saving to a class -

Maybe I am missing something, but wouldn't you want to add the current hours
to the project hours and save that to the database? Or better yet have the
database keep the log of the days and hours worked and the worker that
worked them, from which a query could be run at will or at run time (say in
a manegement function report module) to accumulate and report the hours.

AK
"Jerry" <je*******@gmail.comwrote in message
news:11**********************@35g2000cwc.googlegro ups.com...
Hello!

I'm creating an application where users can enter their hours worked on
certain projects and have them saved to a database. Right now there are
about 60 different projects and that number can increase or decrease at
any time.

I'm looking for some advice on how to best design the windows form for
users to enter hours for the projects they worked on that week. I was
thinking about using a comboBox to list each project with a text box to
enter hours. The user would be presented with update and save buttons.
The update button would save the current project's hours to a class and
the save button would write all the saved info to the database. Is
there a better way to do this?

I apologize for posting such a trivial question. This is my first real
VB.NET application so it's still a learning process :-)

--
Jerry
Jul 17 '06 #3
You need to learn about database design.

You need to design it like a database and show it to them like an Excel
file.

If you do not do this, why bother? Just have a common spreadsheet and
still save it there. Then when the whole thing comes tumbling down,
and it will, you can say, "I told you it should be a database."

If you need help with the database design, I will help with that.
AK wrote:
Jerry,

RE: Saving to a class -

Maybe I am missing something, but wouldn't you want to add the current hours
to the project hours and save that to the database? Or better yet have the
database keep the log of the days and hours worked and the worker that
worked them, from which a query could be run at will or at run time (say in
a manegement function report module) to accumulate and report the hours.

AK
"Jerry" <je*******@gmail.comwrote in message
news:11**********************@35g2000cwc.googlegro ups.com...
Hello!
>
I'm creating an application where users can enter their hours worked on
certain projects and have them saved to a database. Right now there are
about 60 different projects and that number can increase or decrease at
any time.
>
I'm looking for some advice on how to best design the windows form for
users to enter hours for the projects they worked on that week. I was
thinking about using a comboBox to list each project with a text box to
enter hours. The user would be presented with update and save buttons.
The update button would save the current project's hours to a class and
the save button would write all the saved info to the database. Is
there a better way to do this?
>
I apologize for posting such a trivial question. This is my first real
VB.NET application so it's still a learning process :-)
>
--
Jerry
>
Jul 17 '06 #4

raibeart wrote:
You need to learn about database design.

You need to design it like a database and show it to them like an Excel
file.

If you do not do this, why bother? Just have a common spreadsheet and
still save it there. Then when the whole thing comes tumbling down,
and it will, you can say, "I told you it should be a database."

If you need help with the database design, I will help with that.
Thanks. I already know database design. The information entered in the
application will be saved to a database. I'm just looking for the best
way to design the application.

--
Jerry

Jul 18 '06 #5

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

Similar topics

42
by: Steven O. | last post by:
I am seeking some kind of tool that I can use for GUI prototyping. I know how to use Visual Basic, but since a lot of software is being coded in Java or C++, I'd like to learn a Java or C++ -based...
5
by: Qp | last post by:
Hi, I've got a generic coding architecture question about an application I'm developing. Given that I've never developed anything quite like this before (especially not in Python), I'd appreciate...
12
by: David | last post by:
I am a full-time freelance writer. I am seeking an established, professional web designer who has designed more than one successful website for freelance writers. The individual needs to be able...
3
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value the feedback that comes from this group as well. ...
2
by: Joseph Geretz | last post by:
I don't know if this is the right group for my question, but I'm seeking advice from knowledgable .NET developers. Hopefully I've come to the right place. I work with a document management...
3
by: Robert W. | last post by:
Following the advice of several of you on here (Thank You All!) I've successfully constructed a Model-View-Controller (MVC) implementation. It works great! Now, whenever the user manipulates one...
20
by: Jim | last post by:
Hi, I am hoping that someone here can help me out. I am for the first time trying to implement a page design using only CSS instead of HTML tables. I've been able to get most of the page done...
4
by: | last post by:
I am a recent college graduate and am looking for some advice on how to be a skilled C++ developer. My educational background is from a quite mediocre campus. Can anybody please explain what is...
0
by: waggledance | last post by:
I was wondering if anyone here might be able to offer me some advice for someone who can only use Macromedia Dreamweaver MX. I am (clearly!) a web design novice so apologies in advance if this is a...
0
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
0
BarryA
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...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
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...

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.