How Do I Show Chart From Access Database In Vb 10 ?

Question

0.00/5 (No votes)

See more:

NIK |Tanggal |Nama |Jabatan| Dept |Mulai | Sampai | SM |Selisih | Waktu |
2222|6/10/2015| akbar | eee | poo | 9:59AM|10:59AM |60mnt |0 mnt | 480mnt|
123 |6/10/2015| ahaha |wakwak | ssp |8:04 AM|11:04AM |180mnt |120mnt | 60mnt |
5555|6/10/2015| hhhh |oooo |LLLL |11:04AM|3:04 PM |240mnt |180mnt |300mnt |

that's my access data, i want to make a chart in vb 10, that showing frequency how often "Dept" appear in 5 days, what should i do ?? help me please

Posted 29-Jun-15 17:41pm

Akbar Giffary

Add a Solution

Comments

Ralf Meier 30-Jun-15 0:23am

Could you show me, how does it should look like ?
The Entry "Dept" contains data like "poo" or "ssp". Do you want to use these "Names" as a kind of index and count them ?

Akbar Giffary 30-Jun-15 0:48am

the entry "Dept" contains poo, ssp, lll, lll, lll
so the result in 5 days :
poo = 1
ssp = 1
lll = 3

and i want to show it on column chart

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)

Ralf Meier · Answer 1 · 2015-06-29T19:32:00

Solution 1

I suggest the following :

1. Create a class (myClass), which represents the Entry :
Identifier as string
CountOfAppearance as integer
2. Create a List (of myClass) ' means the custom class from top 1
3. scan your source-data for all entries
by each entry compare, if it is still existing in your List.
- if Yes then increase the Count
- if No then create a new Entry with the Identifier-Name and the Count = 1
3a. you could combine the the function of top 3 in a customized collection, which does the needed function for you.
4. after this you have the Information to fill your Chart.
- I hope, you know how to handle a Chart ...

Could you solve the top's 1..3 by yourself or do you need further Information ?
Is top 3a interesting for you ?

Posted 29-Jun-15 19:32pm

Ralf Meier

Comments

Akbar Giffary 30-Jun-15 3:15am

Thanks for suggest me, but sorry i can't understand how make it programmaticaly

Ralf Meier 30-Jun-15 3:33am

Which part of it ?
I think, the creation of the ItemClass should be clear - isn't it ?
You never before worked with a List or a (customized) collection ...?

Akbar Giffary 30-Jun-15 4:10am

i'm just new in here, so i still learn
yes, i never worked with a List or a (customized) collection before
can you guide me step by step ?

Ralf Meier 30-Jun-15 4:40am

OK ... I would teach you ... but there is still a Little bit of work, which could be done by you BEFORE.

At first :
Create an ItemClass as descibed by me
Then :
Create a method which iterates through your DGV to find the different Identifier-Names
Then :
Improve your Thread with this Information

After this, we could do the next step(s) ...