How much field shoud be taken in tbl_employee _attendence in database.?? [Resolved]

Posted by Rock_Monu under ASP.NET on 8/8/2012 | Points: 10 | Views : 1089 | Status : [Member] | Replies : 7
How much field shoud be taken in tbl_employee _attendence in database.?? i want to make a employee attendence form in windows form in asp.net.
plz give me urgent Reply..??




Responses

Posted by: Ranjeet_8 on: 8/8/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
As per requirment u can create fields in a tbl_employee.
it's totally depands upon u or ur project requirment.

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rock_Monu on: 8/8/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
@Ranjeet_8 :plz sir give me a little bit idea .:)

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 8/8/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
for eg:
[PresentID] [int] IDENTITY(1,1) NOT NULL,

[EmpID] [int] NOT NULL,

[IsPresent] [char](1) NOT NULL,

[Resean] [ntext] NULL,

[PresentDate] [datetime] NOT NULL,


OR as per requirment

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rock_Monu on: 8/8/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
but sir i want for a tbl_emp_attendence fo idea. not a tbl_employee_info. thanku

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 8/8/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
@Rock_Monu
check above eg.
i hv updated same as ur req..

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rock_Monu on: 8/9/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
@Ranjeet_8 .
ok sir thankx.i have done it .now i want to one of table tbl_emp_salary.so sir plz give me little bit idea that which field will be taken in table.
thanxs sir.

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 8/9/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
@Rock_Monu
Please do'nt forgot to Mark As Answer, if my post helps u.

Refer this url.
it will help u to create table structure.
http://docs.oracle.com/cd/B14099_19/web.1012/b15900/tutorial012.htm

.

Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response