Query array or create a temp DB

Question

Is there any way to query an array of mine in VB.net? I just need something temporary in order to query it for a report but I do not want to make an external database just for something that's going to be temp. I just need to be able to say select * from tempTable etc etc.

Any help or links would be great!

As suggested below, look into LINQ. There are a lot of great applications for it. Really nifty tool to use. — Yatrix
– Yatrix, Commented May 14, 2012 at 17:04

Nick · Accepted Answer · 2012-05-09 04:55:43Z

1

You can use LINQ

Dim Report_Array As List(Of clsReport) = Get_Report_List


Dim Selected_Report As List(Of clsReport) = (From R As clsReport In Report_Array
                                             WHERE R.ReportName = 'ABC')

answered May 9, 2012 at 4:55

Nick

1,1287 silver badges12 bronze badges

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

Comments

Habib · Accepted Answer · 2012-05-09 04:56:24Z

1

You can use LINQ to query array in Vb.Net. Please see the article Using LINQ to Objects in Visual Basic

Dim Birds() As String = {"Indigo Bunting", "Rose Breasted Grosbeak", _ 
                             "Robin", "House Finch", "Gold Finch", _
                             "Ruby Throated Hummingbird", _
                             "Rufous Hummingbird", "Downy Woodpecker"}




Dim list = From b In Birds _
           Where b.StartsWith("R") _
           Select b

answered May 9, 2012 at 4:56

Habib

224k30 gold badges420 silver badges446 bronze badges

Collectives™ on Stack Overflow

Query array or create a temp DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related