How to create a employee attendence

Question

Hi, Please help me with the how to create a attendance form. can you help me with the example of small coding?

Vivek Kumar · Answer

Hi Yuvi, You can take help from below link. http://vedpathak.blogspot.in/2011/11/employee-attendance-system-module-using.html

Panna Chatterjee · Answer

You can bring your employee attendence Excel sheet inside your gridview //code using System.Data.OleDb; //we have to create OleDb connection for excel using System.Data.SqlClient; private void btnBrowse_Click(object sender, EventArgs e) { try { string strNewPath ="C:\MonthlyStatus_BasicReport JUNE 2012.xls"; string strFileName=""; OpenFileDialog dlgPhotograph = new OpenFileDialog(); dlgPhotograph.Filter = "All files (*.*)|*.*|All files (*.*)|*.*"; dlgPhotograph.FilterIndex = 6; dlgPhotograph.Multiselect = false; dlgPhotograph.ShowReadOnly = false; dlgPhotograph.Title = "Please select an Excel file"; dlgPhotograph.ValidateNames = true; // if (dlgPhotograph.ShowDialog(this) == DialogResult.OK) { System.IO.FileInfo fileObj = new System.IO.FileInfo(dlgPhotograph.FileName); string path = "C:\MonthlyStatus_BasicReport JUNE 2012.xls"; strNewPath = "C:\MonthlyStatus_BasicReport JUNE 2012.xls"; //String strFileName = Server.MapPath("INZAXIS/") + DateTime.Now.ToString("dd_MMM_yyyy_HH_mm_ss_tt"); String strFileType = System.IO.Path.GetExtension(dlgPhotograph.FileName).ToString().ToLower(); if (strFileType == ".xls" || strFileType == ".xlsx") { string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strNewPath + ";Extended Properties="Excel 8.0;HDR=Yes;IMEX=2""; OleDbDataAdapter adap = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connString); DataSet ds = new DataSet(); adap.Fill(ds, "MonthlyStatus_BasicReport JUNE 2012"); dataGridView1.DataSource = ds.Tables["MonthlyStatus_BasicReport JUNE 2012"].DefaultView; MessageBox.Show("Upload excel file successfull"); } } } catch (Exception ee) { //bslLogErrors.CreateLogErrorFile("frmEmployeePhoto", "btnSelect_Click", ee); } }

Deepak Sharma · Answer

sir it is a windows application using c# language. and want to create a employee attendance in which I want total days of presents and absent of the employee and also want total days in a month

Khaja Moizuddin · Answer

In which technology or language you want to create it.