Convert DataGridView containing table into CSV

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • PsychoCoder
    replied
    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 :)

    Leave a comment:


  • 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();
    
             
    
            }
    Last edited by PsychoCoder; Nov 22 '12, 07:14 AM. Reason: Formatted code with code tags </CODE>
Working...