我已成功将CSV文件导入以下类中:
[DelimitedRecord(",")]
[IgnoreFirst(1)] // ignores first line of file, since it's a header
public class Employee {
public string EmployeeId;
public string FirstName;
public string LastName;
// etc.
}
我需要基于该类创建一个 DataTable,以便使用 SqlBulkCopy。我找到了一些示例,但以下方法对我无效:
private static DataTable createEmptyDataTable(Type myType) {
DataTable dt = new DataTable();
foreach (PropertyInfo info in myType.GetProperties()) {
dt.Columns.Add(new DataColumn(info.Name, info.PropertyType));
}
return dt;
}
问题出在myType.GetProperties()函数上。它没有抛出错误,但是返回了空值。应该返回的PropertyInfo数组为空。我已经尝试了很久也没能找到问题的原因…
编辑:我也尝试了这个变量,但是还是不成功:
private static DataTable createEmptyDataTable(Type myType) {
DataTable dt = new DataTable();
PropertyInfo[] infoArray = myType.GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.Static);
foreach (PropertyInfo info in infoArray) {
dt.Columns.Add(new DataColumn(info.Name, info.PropertyType));
}
return dt;
}