How to count the NULL or balnk line of column

Mfwamba Tshimanga

Hi!

I write these code to filter some data. Then on the 11th column there the value "1" to make counter and show it on this value" lblAusenteTotal.Text".
What I need to learn?
How can I make it to counter blank or NULL line of the 11th column.

int sum = 0;

for (int i = 0; i < dvgDatas.Rows.Count; ++i)

{

sum += Convert.ToInt32(dvgDatas.Rows[i].Cells[11].Value);

lblResult.Text = " " + sum.ToString();

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
This is a very similar question to one I've just replied to:

http://www.c-sharpcorner.com/Forums/Thread/284737/need-to-count-my-row.aspx

If you only want to count rows where the 12th column (index == 11) is blank i.e. null or empty, then try this:

int count = 0;

foreach (DataGridViewRow row in dvgDatas.Rows)
{
if (row.IsNewRow) break;

object value = row.Cells[10].Value;
if (value == null || Convert.IsDBNull(value) || value.ToString().Trim().Length == 0)
{
count++;
}
}

lblResult.Text = count.ToString();

Note that this code doesn't count the row at the bottom of the grid for adding new records.
0
Mfwamba Tshimanga11y ago
What I want? Its should read the blank column row and says how many are...
0
Mfwamba Tshimanga11y ago
@Pranay

See what I do. Curiosly, your codes DOESNT WORKS.

int sum = 0;
for (int i = 0; i < dvgDatas.Rows.Count; ++i)
{ String.IsNullOrEmpty(Convert.ToString(dvgDatas.Rows[i].Cells[9].Value));
lblResult.Text = " " + sum.ToString();
0
Pranay Rana11y ago
Not actually getting your problem but if you want to check null and blank value than you can do like this

String.IsNullOrEmpty(Convert.ToString(dvgDatas.Rows[i].Cells[11].Value))
0