Convert DataGridView containing table into CSV
Collapse
X
-
Sure would help us if you explained what issues or errors you're having with the code you provided, along with a detailed explanation of what you're trying to accomplish :) -
Convert DataGridView containing table into CSV
Code: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(); }Tags: None
Leave a comment: