Connecting Tech Pros Worldwide Help | Site Map

Seeking Design Advice

Jerry
Guest
 
Posts: n/a
#1: Jul 14 '06
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

AK
Guest
 
Posts: n/a
#2: Jul 16 '06

re: Seeking Design Advice


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" <jerryalan@gmail.comwrote in message
news:1152885559.549401.190660@35g2000cwc.googlegro ups.com...
Quote:
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
>

Jerry
Guest
 
Posts: n/a
#3: Jul 17 '06

re: Seeking Design Advice


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:
Quote:
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" <jerryalan@gmail.comwrote in message
news:1152885559.549401.190660@35g2000cwc.googlegro ups.com...
Quote:
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
raibeart
Guest
 
Posts: n/a
#4: Jul 17 '06

re: Seeking Design Advice


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.
Quote:
AK wrote:
Quote:
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" <jerryalan@gmail.comwrote in message
news:1152885559.549401.190660@35g2000cwc.googlegro ups.com...
Quote:
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
>
Jerry
Guest
 
Posts: n/a
#5: Jul 18 '06

re: Seeking Design Advice



raibeart wrote:
Quote:
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

Closed Thread