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 : 1946 | Status : [Member] | Replies : 7

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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..??

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	@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

0	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

0	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

0	@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

0	@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

0	@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

Latest Posts