how to store attendance in Ms access database using c#.

Question

hi how to store attendance in ms access database using c#.i have create column in ms access table . column name :-> id name date time123456789........31 column how to save present and absent in date wise in ms access table using c#.when user click on radio button and save today date attendance present/absent in database.

amol · Answer

sir i have create database and save employee name id time and date . i have create column in database to save employee attendance in present and absent how to save this p/a in database using c#. like this format using ms access database empid | empname |empdesignation |time |1| 2| 3| 4|.......................|31 |. 123 | amol |developer |12:00 |p| A| P| P|.......................|P |. and i want to calculate half day and full day of employee using time

Bhushan Gawale · Answer

You might want to start with creation of your access database first i.e. create mentioned columns and schema and save the access database file. Once you are done refer following link which explains how you can talk to the access database in C# by using OleDb providers http://msdn.microsoft.com/en-in/library/aa288452(v=vs.71).aspx http://www.codeproject.com/Articles/8269/How-to-link-to-an-Access-Database-in-a-C-Applicati