删除DataTable中的空行

/// <summary>
/// 删除DataTable中的空行
/// </summary>
/// <param name="dt"></param>
public static void DeleteEmptyRow(DataTable dt)
{
  List<DataRow> removelist = new List<DataRow>();
  for (int i = 0; i < dt.Rows.Count; i++)
  {  

    List<object> list = dt.Rows[i].ItemArray.ToList();
    bool rowdataisnull = true;
    foreach (object item in list)
    {
      if (item.ToString().Trim() !="" )
      {
        rowdataisnull = false;
        break;
      }
    }
    if (rowdataisnull)
    {
      removelist.Add(dt.Rows[i]);
    }

}
  foreach (DataRow t in removelist)
  {
    dt.Rows.Remove(t);
  }
}

posted @ 2012-09-19 12:01  超级塞亚人  阅读(252)  评论(0)    收藏  举报