路径中存在非法字符- C#，正在读取xml

Question

我正在尝试将xml读入SQL，但在"ds.ReadXml("C:\test.xml");“行出现错误，有什么问题的提示吗？谢谢

tring connectionString = "Data Source=MyServer\\SQLEXPRESS;Initial Catalog=MyCatalog;Password=xxx;Persist Security Info=True;User ID=xxx";
        DataSet ds = new DataSet();
        DataTable sourcedata = new DataTable();
        ds.ReadXml("C:\test.xml");

        sourcedata = ds.Tables[0];

        using (SqlConnection sqlconn = new SqlConnection(connectionString))
        {
            sqlconn.Open();
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn))
            {
                bulkCopy.ColumnMappings.Add("ID", "ID");
                bulkCopy.ColumnMappings.Add("user_id", "user_id");
                bulkCopy.ColumnMappings.Add("upload_date", "upload_date");
                bulkCopy.ColumnMappings.Add("userAddr", "userAddr");
                bulkCopy.ColumnMappings.Add("serial_no", "serial_no");
                bulkCopy.ColumnMappings.Add("Mfgr", "Mfgr");
                bulkCopy.ColumnMappings.Add("model", "model");
                bulkCopy.ColumnMappings.Add("description", "description");
                bulkCopy.ColumnMappings.Add("type", "type");
                bulkCopy.ColumnMappings.Add("code", "code");
                bulkCopy.ColumnMappings.Add("comments", "comments");
                bulkCopy.ColumnMappings.Add("qty", "qty");
                bulkCopy.ColumnMappings.Add("condition", "condition");
                bulkCopy.ColumnMappings.Add("location", "location");
                bulkCopy.ColumnMappings.Add("price", "price");
                bulkCopy.DestinationTableName = "Upload";
                bulkCopy.WriteToServer(sourcedata);
            }
        }
    }

Answer 1

您的C:\test.xml将被读取为C:(tab character)est.xml。在字符串前面放一个@：@"C:\test.xml"，或者用"C:\\test.xml"对其进行转义。

十次中有九次，当你犯这个错误时，你会得到一条类似“非法转义字符”的错误消息，错误的地方会更明显，但在这种情况下，它只是碰巧是合法的。

Answer 2

尝试转义'\‘符号：

ds.ReadXml("C:\\test.xml");

Answer 3

尝试：

ds.ReadXml(@"C:\test.xml");

\t被视为水平制表符，除非您对其进行转义。