Temporary table under visual basic

[Madbull]

Hello yall.
I know when programming under Delphi that you can declare in your codesource temp table wich are stored in the memory on the local machine.You use the table then when you don't need it you remove it from memory.That's great!
My problem is that i can't find anywhere a tutorial that shows me how to declare and use temp table under vb.I don't even know if it is possible,i guess it must be but can't find infos.
If someone can help me this would be great.
Thanks in advance

 

[Sheco]

Are you talking about a temp table in the database or a data structure that you use in code? Something like an array? or more like a disconnected ADO recordset perhaps?

 

[Madbull]

I am talking about a data structure in my code.
Under delphi, you can do something like that:

dim tempTable as temp table {
field1 as string
field2 as integer
etc...
}
That way you can declare as many instance as need it (as long as memory isnt full) then drop them when you no longer need them.

 

[bjd4jc]

You will want to use a Class for this.

 

[Sheco]

Or maybe a user defined type

Type tempTable
field1 as string
field2 as integer
End Type

[...]

Dim MyUDT as tempTable
Dim FixedArrayOfUDT(10) as tempTable
Dim DynamicArrayOfUDT() as tempTable

etc..

 

[Madbull]

Is it the only solution.
I'll try this if there is no other way to do it.
Thanks for your help guys

 

[bjd4jc]

Afraid so, Madbull. I would lean toward using a class because it is more scalable than at User Defined Type. That said, you may not need more than what the UDT provides.