Question

Closed 11 years ago.

我得到了错误:

InvalidCastException was unhandled by user code

Conversion from string "UNITID, INSTNM, ADDR, CITY, STAB" to type  Integer  is not valid.

jcolebrand edited to link to a gist because the code is REALLY long, feel free to fork: https://gist.github.com/2788975

文件是进入 SQL 数据库的.csv 。

Answer 1

我从错误信息和你的代码中注意到了几件事我希望这能帮助你

Use parameters. Here is a link to some resources
The specific error you re receiving is tangentially related to #1. The error says that you re attempting to coerce incompatible data types. Specifically, it tells you that you re trying to cram the specific string, "UNITID, INSTNM, ADDR, CITY, STAB" into an Integer column.

根据我从你的计划中推断出来的,这些其实是柱子,所以你沿途遗漏了几个逗号。如果你使用参数,它将(a) 清除代码,(b) 降低安全风险,(c) 迫使你清楚地理解你正在处理的数据类型。