attendance project

Question

1.00/5 (1 vote)

See more:

This is a attendance project.

I want to store data like these

Table has 4 field srno , name, date, attendance

srno name 1 2 3 4 5 6 7 8 9 10 11 12.... to 31

1 abcd P P A P A P
2 cccc A P A P P P
3 dddd P P P P A P

The problem is that, how can I search data from table like that?
I want these data month wise in <code>DataGridView</code>.

Posted 28-Dec-10 1:45am

Bhatt Aniruddh

Updated 28-Dec-10 1:52am

Henry Minute

v2

Add a Solution

3 solutions

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)

Sandeep Mewara · Answer 1 · 2010-12-28T01:52:00

Solution 1

how can i search data from table like that, I want these data month wise in datagridview.
By preparing a proper Query.
If needed, you can use stored procedure, table valued function in order to get the desired format.

Posted 28-Dec-10 1:52am

Sandeep Mewara

vivekse · Answer 2 · 2010-12-28T01:52:00

Solution 2

Hi,

My suggestion is to design the table like this

SrlNo Date StudentID AttFlag
1 28/12/2010 1 P
1 28/12/2010 2 A

Posted 28-Dec-10 1:52am

vivekse

Comments

myu981987 10-Mar-12 15:05pm

i have to do the same but data of student table n attendance table are shown together but i cant store attflag value on attendance table please help me out

thatraja · Answer 3 · 2010-12-28T05:23:00

Make your Table structure like this

S.No

Name

Year

Month

D1

D2

D3

D4

D5

D6

D7

D8

D9

D10

D11

D12

D13

D14

D15

D16

D17

D18

D19

D20

D21

D22

D23

D24

D25

D26

D27

D28

D29

D30

D31

1

CG

2010

12

P

A

P

A

P

A

P

2

JSOP

2010

12

P

A

P

A

P

A

P

3

Pete

2010

12

P

A

P

A

P

A

P

4

Nish

2010

12

P

A

P

A

P

A

P

5

Luc

2010

12

P

A

P

A

P

A

P

6

Sacha

2010

12

P

A

P

A

P

A

P

7

Dave

2010

12

P

A

P

A

P

A

P

8

DD

2010

12

P

A

P

A

P

A

P

9

Marc

2010

12

P

A

P

A

P

A

P

10

Chris

2010

12

P

A

P

A

P

A

P

Now you can bring the things in front end by using Gridview control with templates.

Dynamically Templated GridView with Edit, Delete and Insert Options[^]

You can use checkbox control in Grid view Item template for mark the the person whether Present or absent. Also Make S.No, Name, columns read only because you don't need to enter things in those fields. Also you can put the year & month in dropdownlist in Item template. Anyway Go ahead.

BTW check the things like Feb month total days(28 or 29 based on leap year).