Table in memory

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cj

    #1

    Table in memory

    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

    #2
    RE: Table in memory

    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.
    >

    Comment

    • Kevin Yu [MSFT]

      #3
      RE: Table in memory

      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.)

      Comment

      Working...