VB .NET Multi Dimension array or Collection Question

  • Thread starter Thread starter scott.loomis
  • Start date Start date
S

scott.loomis

I am looking for a collection or a way to solve the following problem,
any insight would be greatly appreciated.

I am developing a VB .NET application that reads values from SQL server
and stores them in memory, I am doing this because of the frequency of
their use. The individual values alone are not unique, but as a trio
they are.

For example my collection may look like the following:
ID, DOC, SCAC
1,XX, XXX
1,YY,XXX
2,XX,XXX

Now I am looking for a good way to search the collection, so that i can
pass a specific ID, Doc, and SCAC and see if those values exist as a
trio. I need to do this as efficiently as possible.

Thanks.
 
I am looking for a collection or a way to solve the following problem,
any insight would be greatly appreciated.

I am developing a VB .NET application that reads values from SQL server
and stores them in memory, I am doing this because of the frequency of
their use. The individual values alone are not unique, but as a trio
they are.

For example my collection may look like the following:
ID, DOC, SCAC
1,XX, XXX
1,YY,XXX
2,XX,XXX

Now I am looking for a good way to search the collection, so that i can
pass a specific ID, Doc, and SCAC and see if those values exist as a
trio. I need to do this as efficiently as possible.

Thanks.
Click to expand...
If you don't have an astronomical amount of data, a datatable with the
three columns as the index works pretty well. What quantity of records
are you talking about here?

T
 
The amount of data could be anywhere from a couple of records to a
hundred or so records per person.
 
Disregard that, each time the data is retrieved it will contain roughly
100 records. I also am wondering how to search the dataset once i have
it. Say I want to find a certain row, is that possible?
 
Back
Top