Table in memory

[cj]

I keep forgetting. Is there a way to create an in memory table in VB?
One that I can use like a database table. I remember recordset and
dataset and something else in VB4 but I have only used SQL Server in .Net.

[Dennis]

Not sure exactly what you mean but you can create a datatable in memory;

dim mytable as new datatable

You can then add columns, then rows and populate them with data.
--
Dennis in Houston
"cj" wrote:

I keep forgetting. Is there a way to create an in memory table in VB?
One that I can use like a database table. I remember recordset and
dataset and something else in VB4 but I have only used SQL Server in .Net.

[Kevin Yu [MSFT]]

Hi CJ,

I agree with Dennis that the DataTable is the choice. You can check the
following link for more information about ADO.NET architecture and how to
use the DataTable and DataSet.

http://msdn.microsoft.com/library/de...us/dnbda/html/
daag.asp

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)