How to create a employee attendence

Hi Yuvi,

You can take help from below link.

 

http://vedpathak.blogspot.in/2011/11/employee-attendance-system-module-using.html 

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

}

}

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