Counting the numbers of record inserted to a database in a particular year using c# winform

Question

0.00/5 (No votes)

See more:

Hi codeproject
i want to design a winform application which has two buttons known as deathcount and deathcountAfter10years button and are set to invisible. Now i want that by the end of the year the deathcount button should become visible then if the user clicks on it, the total number of record inerted into the death record table in the database for that year is displayed. Now the deathcount button should stay visible for atleast one week, after which the button is made invisible again, and the same process continues. Then after 10 years, the deathcountAfter10years button becomes visible which onclick of the button displays all the record inserted into the deathRecord table in the database for the past 10 years. Is just like birth and death rate.
thanks guys for you help

Posted 16-Sep-12 23:26pm

Ese ochuko

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Andrei Straut** · Answer 1 · 2012-09-16T23:39:00

I do not find this question clear at all, could you please rephrase it?

If I understand correctly, basically you want to:
- have two buttons, deathcount and deathcountAfter10years (both invisible)
- At the end of the year, deathcount button becomes visible
- User clicks on deathcount button - deaths recorded for the present year are displayed
- After a week, deathcount button becomes invisible

Same thing goes with code>deathcountAfter10years button, the difference being that it is displayed at the end of a 10-year period, instead of each year.

Am I right? And if I am, what's the problem?
Check the date at the beginning of each day - if it's last week of the year, display your first button. If it's the last week of the 10 years, display the other one as well.
If any button is clicked, just query your database for records with date (I'm assuming you do save it) in your needed range and display the records.

Also, you are unlikely to get any code to solve your problem. We do not usually provide code, we do however provide you with ideas as how to write your own code.