C# 去除Datatable空白行

C#去掉空白行

一丶

/// <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();
    }

二丶

 protected DataTable removeEmpty(DataTable dt)
    {
        List<DataRow> removelist = new List<DataRow>();
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            bool rowdataisnull = true;
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                if (!string.IsNullOrEmpty(dt.Rows[i][j].ToString().Trim()))
                {
 
                    rowdataisnull = false;
                }
            }
            if (rowdataisnull)
            {
                removelist.Add(dt.Rows[i]);
            }
 
        }
        for (int i = 0; i < removelist.Count; i++)
        {
            dt.Rows.Remove(removelist[i]);
        }
        return dt;
    }