private void button1_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { TxtPath.Text = openFileDialog1.FileName; } string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+TxtPath.Text+""; DataSet ds = new DataSet(); OleDbConnection conn = new OleDbConnection(connString); OleDbCommand cmd = new OleDbCommand("SELECT AttendanceLogId,AttendanceDate,EmployeeId,InTime,InDeviceId,OutTime from AttendanceLogs ", conn); conn.Open(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds, "AttendanceLogs"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "AttendanceLogs"; conn.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)