troubleshooting Question

data table questions

Avatar of Robb Hill
Robb HillFlag for United States of America asked on
.NET ProgrammingEditors IDEs
2 Comments1 Solution185 ViewsLast Modified:
I have a array of datarows that sometimes has length and sometimes has 0 lenght.  Do you see anything in this code segment that would make this aarray get set to 0.  Whats strange is it works sometimes and sometimes it doesnt.

Private Sub Focus(ByVal field As String, ByVal criteria As String)
                Dim expression As String
                Dim criterias As String()
                If InStr(field, "Date") Then
                    criterias = criteria.Split(",")
                    expression = field & " >= #" & criterias(0) & "#" & " AND " & field & " <= #" & criterias(1) & "#"
                Else
                    expression = field & " IN (" & criteria & ")"
                End If
                Dim adrEdit() As DataRow = dt.Select(expression)
                If UBound(adrEdit, 1) > -1 Then
                    Dim cdt As New DataTable
                    cdt = dt.Clone
                    For Each dr As DataRow In adrEdit
                        Dim cdr As DataRow
                        cdr = cdt.NewRow
                        For i As Int16 = 0 To dt.Columns.Count - 1
                            cdr(i) = dr(i)
                        Next
                        cdt.Rows.Add(cdr)
                    Next
                    dt = cdt.Copy
                Else
                    dt.Clear()
                End If
            End Sub
ASKER CERTIFIED SOLUTION
igor_alpha

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 2 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 2 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004