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" <83*******@sneakemail.comwrote in message
news:b9**********************************@v39g2000 pro.googlegroups.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?

[tharpa]

On Nov 3, 4:47 pm, "Miro" <[e-mail]:

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" <[e-mail] in message

news:b9**********************************@v39g2000 pro.googlegroups.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.

[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

"tharpa" <83*******@sneakemail.comwrote in message
news:ae**********************************@s9g2000p rm.googlegroups.com...

On Nov 3, 4:47 pm, "Miro" <[e-mail]:

>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" <[e-mail] in message

news:b9**********************************@v39g200 0pro.googlegroups.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.