Count specific datatable columns

Question

How to count datatable columns (created dynamically) that has the same first two characters in the header? Here's my code so far but is not working.

    For col As Integer = 3 To dt.Columns.Count - 1
        Dim cntLE, cntUE As Integer
        If dt.Columns(col).ColumnName.Substring(0, 2) = "LE" Then
            cntLE = dt.Columns.Count
        ElseIf dt.Columns(col).ColumnName.Substring(0, 2) = "UE" Then
            cntUE = dt.Columns.Count
        End If
    Next

See my answer below. Also, why are you starting at 3, instead of at 0 in the For loop? — Shiva
– Shiva, Commented Oct 22, 2014 at 1:14

Shiva · Accepted Answer · 2014-10-22 01:12:41Z

2

It's because you are assigning the entire column count (i.e. dt.Columns.Count ) to the counters, instead of increment them by 1 if found.

Try this.

For col As Integer = 3 To dt.Columns.Count - 1
    Dim cntLE, cntUE As Integer
    If dt.Columns(col).ColumnName.Substring(0, 2) = "LE" Then
        cntLE = cntLE + 1
    ElseIf dt.Columns(col).ColumnName.Substring(0, 2) = "UE" Then
        cntUE = cntUE + 1
    End If
Next

answered Oct 22, 2014 at 1:12

Shiva

21.1k15 gold badges88 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

eirishainjel Over a year ago

Ah.. I see :) Thank you. Columns index 0 to 2 are static columns, only Column(3) up are created dynamically that's why the loop starts on 3.

Collectives™ on Stack Overflow

Count specific datatable columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related