Convert DataGridView containing table into CSV

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • praveenkadimi
    New Member
    • Nov 2012
    • 2

    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>
  • PsychoCoder
    Recognized Expert Contributor
    • Jul 2010
    • 465

    #2
    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 :)

    Comment

    Working...