我有一个DataTable
,我像这样进行初始化:
dataTable = new DataTable();
dataTable.Clear();
for (int i = 0; i < labels.Length; i++)
{
dataTable.Columns.Add(MyCSVReaderFinal.labels[i]);
}
return dataTable;
其中label
是一个字符串数组,格式如下:
private static string[] labels = { "FARM ID", "FARM OWNER ARABIC", "FARM NUMBER",
"FARM MOBILE", "EMAR NAME ARABIC", "EMARA ID", "AREA NAME ARABIC", "AREA ID",
"REGION NAME ARABIC", "REGION ID", "RECEIVING CENTER NAME ARABIC",
"RECEIVING CENTER ID", "KHALAS", "FARDH", "OTHER LULU", "KHENAIZI", "BOUMAAN",
"BARHI", "JESH KHARMA", "REZIZ", "JABRI", "ANBARET AL-MADINA", "SHISHI",
"DABBAS", "NABTET SAIF", "KHEDRAWI", "HILALI", "MAKTOUMY", "NAMISHI",
"SULTANAH", "BAQLAT AL-TAWAA", "BAQLAT AL-DAHLA", "BAQLAT AL-RARENJA",
"SUKARY", "SAQEI", "ABU ZEBED", "MAJDOUL", "SHABIBI", "YOUWANI", "YARDI",
"KHADI", "HATIMI", "NEGHAL", "OTHER SAYER", "TOTAL FRUCTIFEROUS",
"TOTAL UN FRUCTIFEROUS", "TOTAL AFHAL", "GENERAL TOTAL", "SENIOR SUPERVISORS",
"ASSISTANT", "DATA ENTRY", "FARM ONWER OR BEHALF" };
我想检查数据表中每个值的空字符串或null:
我尝试了以下代码:
for (int i = 0; i < dt.Rows.Count; i++) {
for (int j = 0; j < dt.Columns.Count; j++) {
if(string.IsNullOrEmpty(dt.Rows[i].)){}
}
}
但是你看,我尝试了这个:dt.Rows[i].
但我不知道如何获取值。
请问你能帮我吗?
null
还是空的?在填充表格之前还是之后?另外,为什么,你想做什么呢?基本上,你的问题可以简化为“如何通过列索引访问DataRow的字段”,这个问题经常被问到并且有很好的文档记录。 - Tim SchmelterThe given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
,并且我在这个问题https://dev59.com/BWMl5IYBdhLWcg3wyJUe中读到了这个问题,那是因为空字符串,但即使应用了下面的答案,我仍然会得到那个错误,请你帮忙吗? - Marco Dinatsoli