• C# 一些代码小结--datGirdView 保存到csv文件


     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);
            }
        }
    }
    
  • 相关阅读:
    unix文件权限
    jira部署,主机迁移,数据库迁移,jira
    c函数习记
    常用软介质下载
    Matlab interpgui
    LightOJ 1422
    【CODEFORCES】 A. Keyboard
    leetcode 230: Kth Smallest Element in a BST
    Vertica7 Native Connection Load Balance
    vlc模块间共享变量
  • 原文地址:https://www.cnblogs.com/memorypro/p/10589003.html
Copyright © 2020-2023  润新知