我有一个DataGridView，它包含要转换为CSV文件的表 [英] I have a DataGridView it contain table to convert into CSV file

问题描述

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

         

        }
    }

推荐答案

选中此链接
将DataGridView导出为CSV [

Check this link
Export DataGridView to CSV[^]

这篇关于我有一个DataGridView，它包含要转换为CSV文件的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！