读取.csv文件数据

using System.IO;

 

private void UploadFile()
    {
        try
        {
            if (!FileUpload1.HasFile)
            {
                Response.Write("文件不存在");
                return;
            }

            string fileExtension = Path.GetExtension(FileUpload1.FileName).ToLower();//获得文件后缀

            if (!fileExtension.Equals(".csv"))
            {
                Response.Write("文件不是.csv文件");
                return;
            }

            Stream stream = FileUpload1.FileContent;
            StreamReader read = new StreamReader(stream, System.Text.Encoding.GetEncoding("gb2312"));
            System.Data.DataTable dt = new System.Data.DataTable();
            int cnt = 0;
            //循环读取流数据
            while (true)
            {
                st