G
Geoff Jones
Hi
I am loading a DataSet using a DataAdaptor e.g.
myDataAdaptor = New OleDb.OleDbDataAdaptor("Select * From [myTable]",
myConnection)
myDataAdaptor.Fill(myDataSet, "MyTable")
The table is very large and it takes quite a few seconds for these two steps
to complete. I do not need to write back to the table and I was wondering if
using a DataAdaptor may be a bit of overkill. I do need a DataSet to perform
some quite complicated data analysis.
I believe that a DataReader may be a way of speeding things up but I don't
have any idea of how to do the above using it. I'm sure this is a very
simple question so please forgive my ignorance - you may have gathered that
I'm new to all this database stuff!
Thanks in advance
Geoff
I am loading a DataSet using a DataAdaptor e.g.
myDataAdaptor = New OleDb.OleDbDataAdaptor("Select * From [myTable]",
myConnection)
myDataAdaptor.Fill(myDataSet, "MyTable")
The table is very large and it takes quite a few seconds for these two steps
to complete. I do not need to write back to the table and I was wondering if
using a DataAdaptor may be a bit of overkill. I do need a DataSet to perform
some quite complicated data analysis.
I believe that a DataReader may be a way of speeding things up but I don't
have any idea of how to do the above using it. I'm sure this is a very
simple question so please forgive my ignorance - you may have gathered that
I'm new to all this database stuff!
Thanks in advance
Geoff