DataTable删除空白行

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
public DataTable clearnullrows(DataTable dt)
{
    List<DataRow> removelist = new List<DataRow>();
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        bool rowdataisnull = true;
        for (int j = 1; 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;
}