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); } }

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