How to count the NULL or balnk line of column

Question

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();

Vulpes · Answer

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.

Mfwamba Tshimanga · Answer

What I want? Its should read the blank column row and says how many are...

Mfwamba Tshimanga · Answer

@Pranay See what I do. Curiosly your codes DOESNT WORKS. int sum = 0; for (int i = 0; i { String.IsNullOrEmpty(Convert.ToString( dvgDatas .Rows[i].Cells[9].Value)); lblResult.Text =   + sum.ToString();

Pranay Rana · Answer

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))