DataTable temp=DataSetImport.Tables[0];
foreach (DataColumn column in temp.Columns) { string sql = string.Format(@"select top 1 * from SetupImport where table_name='{0}' and excel_field=N'{1}'", tableName, column.ToString()); if (SqlDBHelper.ExecuteDataQueryDataSet(sql) != null && SqlDBHelper.ExecuteDataQueryDataSet(sql).Tables[0].Rows.Count > 0)
{
if (Convert.ToInt32(SqlDBHelper.ExecuteDataQueryDataSet(sql).Tables[0].Rows[0]["if_import"]) == 0)
{ DataSetImport.Tables[0].Columns.Remove(column);
} }
else { DataSetImport.Tables[0].Columns.Remove(column);
}
}
return DataSetImport;
foreach (DataColumn column in temp.Columns) { string sql = string.Format(@"select top 1 * from SetupImport where table_name='{0}' and excel_field=N'{1}'", tableName, column.ToString()); if (SqlDBHelper.ExecuteDataQueryDataSet(sql) != null && SqlDBHelper.ExecuteDataQueryDataSet(sql).Tables[0].Rows.Count > 0)
{
if (Convert.ToInt32(SqlDBHelper.ExecuteDataQueryDataSet(sql).Tables[0].Rows[0]["if_import"]) == 0)
{ DataSetImport.Tables[0].Columns.Remove(column);
} }
else { DataSetImport.Tables[0].Columns.Remove(column);
}
}
return DataSetImport;
“/Web”应用程序中的服务器错误。
集合已修改;可能无法执行枚举操作。