Storing table data for a session.

[tharpa]

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?

 

[Miro]

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]

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.

Thanks.

 

[Miro]

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