如何计算一个datagridview中每列的非空行数，并在第二个datagridview中显示行数？

// 遍历第一个DataGridView计算每列的非空行数
DataTable nonEmptyRowCountTable = new DataTable();
for (int columnIndex = 0; columnIndex < dataGridView1.Columns.Count; columnIndex++)
{
    string columnName = dataGridView1.Columns[columnIndex].Name;
    int nonEmptyRowCount = 0;

    for (int rowIndex = 0; rowIndex < dataGridView1.Rows.Count; rowIndex++)
    {
        DataGridViewCell cell = dataGridView1[columnIndex, rowIndex];
        if (cell.Value != null && !string.IsNullOrEmpty(cell.Value.ToString()))
        {
            nonEmptyRowCount++;
        }
    }

    nonEmptyRowCountTable.Columns.Add(columnName, typeof(int));
    nonEmptyRowCountTable.Rows.Add(nonEmptyRowCount);
}

// 将第二个DataGridView的数据源设置为非空行数的DataTable
dataGridView2.DataSource = nonEmptyRowCountTable;