C# 文件名、目录名或卷标语法不正确。

2020-06-16 15:15发布

问题:

{"文件名、目录名或卷标语法不正确。 : 'D:\\visual studio\\TestApp\\bin\\Debug\\netcoreapp3.1\\‪D:\\test.csv'"}
            using System.Data;

namespace TestApp
{
    class Program
    {
        public static void Main(string[] args)
        {
            string openPath = "‪D:/test.csv";
            DataTable data = CSVFileHelper.OpenCSV(openPath);
        }    
    }
}
public static DataTable OpenCSV(string filePath)
    {
        Encoding encoding = Encoding.UTF8; //Encoding.ASCII;//
        DataTable dt = new DataTable();
        FileStream fs = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read);

        StreamReader sr = new StreamReader(fs, encoding);
        //string fileContent = sr.ReadToEnd();
        //encoding = sr.CurrentEncoding;
        //记录每次读取的一行记录
        string strLine = "";
        //记录每行记录中的各字段内容
        string[] aryLine = null;
        string[] tableHead = null;
        //标示列数
        int columnCount = 0;
        //标示是否是读取的第一行
        bool IsFirst = true;
        //逐行读取CSV中的数据
        while ((strLine = sr.ReadLine()) != null)
        {
            //strLine = Common.ConvertStringUTF8(strLine, encoding);
            //strLine = Common.ConvertStringUTF8(strLine);

            if (IsFirst == true)
            {
                tableHead = strLine.Split(',');
                IsFirst = false;
                columnCount = tableHead.Length;
                //创建列
                for (int i = 0; i < columnCount; i++)
                {
                    DataColumn dc = new DataColumn(tableHead[i]);
                    dt.Columns.Add(dc);
                }
            }
            else
            {
                aryLine = strLine.Split(',');
                DataRow dr = dt.NewRow();
                for (int j = 0; j < columnCount; j++)
                {
                    dr[j] = aryLine[j];
                }
                dt.Rows.Add(dr);
            }
        }
        if (aryLine != null && aryLine.Length > 0)
        {
            dt.DefaultView.Sort = tableHead[0] + " " + "asc";
        }

        sr.Close();
        fs.Close();
        return dt;
    }

为什么会在我的路径前面加上项目路径?

回答1:

CSVFileHelper.OpenCSV 是什么鬼?



回答2:

把路径用Server.MapPath()这个转换下试试



回答3:

string openPath = "‪D:\\test.csv";

这样也报错?你的文件是在哪儿?