Hallo all,
I have the following problem. I'm trying to fill a DataTable in a DataSet
with data from an SQL server 2000 database.
I create a SqlConnection, SqlCommand and finally an SqlDataAdapter with
which I fill a table in my DataSet with the
following code:
dt.BeginLoadData();
da.Fill(dt);
dt.EndloadData();
This statement alone takes about 4.7 secs of execution time, which I think
is way too much for a table containing only
6 rows of data containing 4 columns. Does anyone have some advice on how to
speed this up?
(have also tried the .Fill() without the BeginLoadData and EndLoadData
methods, same result)
Extra information: I'm using Visual Studio 2005 and when I run my query in
the Query Analyser it takes about 0.01 secs.