删除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);
}
}

浙公网安备 33010602011771号