T tharpa Nov 3, 2008 #1 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?
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?
M Miro Nov 3, 2008 #2 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.
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.
T tharpa Nov 4, 2008 #3 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. Click to expand... Thanks.
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. Click to expand... Thanks.
M Miro Nov 4, 2008 #4 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
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
