
图片中的4个datagridview控件的数据分别需要导出保存到CSV文件中,目前就第一个datagridview控件能导出,但都出数据不完整。剩下3个datagridview的数据导出全部为空。
程序如下:
private void BtExportCSV_PTData1_Click(object sender, EventArgs e)
{
SaveCSVFile(dataGridView1);
}
private void SaveCSVFile(DataGridView dgv)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.DefaultExt = "csv";
DialogResult result = saveFileDialog.ShowDialog();
if (result == DialogResult.OK)
{
System.IO.Stream fs = saveFileDialog.OpenFile();
System.IO.StreamWriter sw = new System.IO.StreamWriter(fs);
if (dgv.Rows.Count > 0)
{
foreach (DataGridViewColumn col in dgv.Columns)
{
sw.Write(col.HeaderText + ",");
}
sw.Write(Environment.NewLine);
foreach (DataGridViewRow row in dgv.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.Value != null)
{
sw.Write(cell.Value.ToString() + ",");
}
}
sw.Write(Environment.NewLine);
}
fs.Flush();
fs.Close();
}
}
}