c# 去掉DataTable空白行
/// <summary>
/// 过滤空白行
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable FilterBlankLines(this DataTable dt)
{
DataView dv = dt.DefaultView;
string filterRule = "";
foreach (DataColumn col in dt.Columns)
{
filterRule += $"{col.ColumnName} <> '' or ";
}
filterRule = filterRule.Substring(0, filterRule.LastIndexOf("or"));
dv.RowFilter = $"({filterRule})";
return dv.ToTable();
}