Storing table data for a session.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tharpa
    #1

    Storing table data for a session.

    I wish to store the data from a SQL Server table, close the
    connection, and then use the data.

    What is the best way to do this?
    Tags: None
    • Miro
      #2
      Re: Storing table data for a session.

      Create a typed dataset in your project,

      This will also have the connection...

      fill the dataset ( which opense and closes )
      the dataset now has your data from your table(s).

      Thats my simplest way.

      "tharpa" <83433ai02@snea kemail.comwrote in message
      news:b9418c21-7310-4ebf-b4e8-315286d12615@v3 9g2000pro.googl egroups.com...
      >I wish to store the data from a SQL Server table, close the
      connection, and then use the data.
      >
      What is the best way to do this?

        Comment

        • tharpa
          #3
          Re: Storing table data for a session.

          On Nov 3, 4:47 pm, "Miro" <m...@beero.com wrote:
          Create a typed dataset in your project,
          >
          This will also have the connection...
          >
          fill the dataset ( which opense and closes )
          the dataset now has your data from your table(s).
          >
          Thats my simplest way.
          >
          "tharpa" <83433a...@snea kemail.comwrote in message
          >
          news:b9418c21-7310-4ebf-b4e8-315286d12615@v3 9g2000pro.googl egroups.com...
          >
          I wish to store the data from a SQL Server table, close the
          connection, and then use the data.
          >
          What is the best way to do this?
          Thanks.

            Comment

            • Miro
              #4
              Re: Storing table data for a session.

              Make a quick temp project and once you create your typed dataset,

              drag the datagrid over to a form, and compile and run the project.

              You should see a pretty good example how 'it runs' with some simple code on
              the form that was generated.

              Miro

              "tharpa" <83433ai02@snea kemail.comwrote in message
              news:ae40568d-4031-41d3-ab2d-e1ab0f5fb24b@s9 g2000prm.google groups.com...
              On Nov 3, 4:47 pm, "Miro" <m...@beero.com wrote:
              >Create a typed dataset in your project,
              >>
              >This will also have the connection...
              >>
              >fill the dataset ( which opense and closes )
              >the dataset now has your data from your table(s).
              >>
              >Thats my simplest way.
              >>
              >"tharpa" <83433a...@snea kemail.comwrote in message
              >>
              >news:b9418c2 1-7310-4ebf-b4e8-315286d12615@v3 9g2000pro.googl egroups.com...
              >>
              >I wish to store the data from a SQL Server table, close the
              connection, and then use the data.
              >>
              What is the best way to do this?
              >
              Thanks.

                Comment

                Previous template Next
                Working...