C# CSV文件读取

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace _06_CSV文件读取
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog()==DialogResult.OK)
            {
                FileStream fs = new FileStream(openFileDialog1.FileName, FileMode.Open);
                StreamReader sr = new StreamReader(fs,Encoding.Default);
                DataTable dataTable = new DataTable();
                string data;//将读取到的一行数据存储到里面
                string[] lines; 
                bool isFirst=true;
                //字符串==>DataTable==>DataSource
          
                while ((data=sr.ReadLine())!=null)
                {
                    lines = data.Split(',');//将data里面的数据以,分割存储lines数组中

                    if (isFirst)
                    {
                        //判断是否是第一次读,如果是第一次读,就是读取每一列的第一个数据
                        for (int i = 0; i < lines.Length; i++)
                        {
                            dataTable.Columns.Add(lines[i]);
                        }
                        isFirst = false;
                    }
                    else
                    {

                        //如果不是第一次读取,就新增一行
                      DataRow dataRow=  dataTable.NewRow();

                        for (int i = 0; i < lines.Length; i++)
                        {
                            dataRow[i] = lines[i];
                        }
                        dataTable.Rows.Add(dataRow);

                    }
                }
                if (dataTable.Rows.Count==0)
                {
                    MessageBox.Show("没有数据");
                }
                else
                {
                    dataGridView1.ColumnCount=dataTable.Columns.Count;
                    for (int i = 0; i < dataTable.Columns.Count; i++)
                    {
                        dataGridView1.Columns[i].HeaderText = dataTable.Columns[i].ColumnName;
                    }
                    for (int i = 0; i < dataTable.Rows.Count; i++)
                    {
                        dataGridView1.Rows.Add(dataTable.Rows[i].ItemArray);
                    }
                }
                sr.Close();
                fs.Close();

            }
        }

        private void button2_Click(object sender, EventArgs e)
        {

            //DataSource==>DataTable==>字符串

            DataTable dataTable = new DataTable();
            for (int i = 0; i < dataGridView1.Columns.Count; i++)
            {
                dataTable.Columns.Add(dataGridView1.Columns[i].HeaderText);
            }
            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                DataRow dr=   dataTable.NewRow();
                for (int j = 0; j < dataGridView1.Columns.Count; j++)
                {
                    //将datagridView组件中某一个单元格的值传给dataTable
                    dr[j] = dataGridView1[j, i].Value;

                }
                dataTable.Rows.Add(dr);
            }

            saveFileDialog1.Filter = "CSV files (*.csv)|*.csv";
            if (saveFileDialog1.ShowDialog()==DialogResult.OK)
            {

                FileStream fs = new FileStream(saveFileDialog1.FileName, FileMode.Create);
                StreamWriter sw = new StreamWriter(fs,Encoding.Default);

                string data = null;

                for (int i = 0; i < dataTable.Columns.Count; i++)
                {

                    data += dataTable.Columns[i].ColumnName.ToString();
                    if (i<dataTable.Columns.Count-1)
                    {
                        data += ",";

                    }
                }
                sw.WriteLine(data);
                data = null;
                for (int i = 0; i < dataTable.Rows.Count; i++)
                {
                    for (int j = 0; j < dataTable.Columns.Count; j++)
                    {
                        data += dataTable.Rows[i][j].ToString();

                        if (j < dataTable.Columns.Count - 1)
                        {
                            data += ",";

                        }
                    }
                    sw.WriteLine(data);
                    data = null;
                }
                sw.Close();
                fs.Close();
            }
        }
    }
}