C# 一些代码小结--datGirdView 保存到csv文件
2024-10-19 02:19:04
if (dataGridView1.Rows.Count == 0)
{
MessageBox.Show("No data available!", "Prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "CSV files (*.csv)|*.csv";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.FileName = null;
saveFileDialog.Title = "Save path of the file to be exported";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
Stream myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
string strLine = "";
try
{
//Write in the headers of the columns.
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
if (i > 0)
strLine += ",";
strLine += dataGridView1.Columns[i].HeaderText;
}
strLine.Remove(strLine.Length - 1);
sw.WriteLine(strLine);
strLine = "";
//Write in the content of the columns.
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
strLine = "";
for (int k = 0; k < dataGridView1.Columns.Count; k++)
{
if (k > 0)
strLine += ",";
if (dataGridView1.Rows[j].Cells[k].Value == null)
strLine += "";
else
{
string m = dataGridView1.Rows[j].Cells[k].Value.ToString().Trim();
strLine += m.Replace(",", ",");
}
}
strLine.Remove(strLine.Length - 1);
sw.WriteLine(strLine);
//Update the Progess Bar.
// toolStripProgressBar1.Value = 100 * (j + 1) / dataGridView1.Rows.Count;
}
sw.Close();
myStream.Close();
MessageBox.Show("Data has been exported to:" + saveFileDialog.FileName.ToString(), "Exporting Completed", MessageBoxButtons.OK, MessageBoxIcon.Information);
// toolStripProgressBar1.Value = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exporting Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
最新文章
- 如何在Microsoft Edge浏览器中添加一个Hello World插件
- app的同源和域的问题
- HDOJ 1870
- Genymotion常见问题整合与解决方案
- WebView重定向新开界面问题-b
- NGINX开篇
- iOS开发——数据持久化Swift篇&;iCloud云存储
- 转:JMeter 参数化之利用JDBC Connection Configuration从数据库读取数据并关联变量
- linux 备份 文件+sql
- python 发起HTTP请求
- Eclipse的调试功能的10个小窍门[转]
- PHP二维数组排序(感谢滔哥)
- 《Android插件化开发指南》面世
- bzoj2018年5月赛
- gym101808 E
- Jenkins系列之一——初识
- enum-枚举当做key-value业务使用
- 官方sakila测试库
- Spark的启动进程详解
- 手脱UPX v0.89.6 - v1.02