Well, the problem is when i run the application 1st time, it takes time fill
the dataset, whereas if i run the application second time, it fills dataset
faster.

How do I make it faster on the 1st time ?

This is probably due initialization of first physicall connection. You can't
do much there (you might initialize one during application loading - in
worker thread perhaps (just open a connection))

Show quoteHide quote

Just as with any operation, the server can't cache the connection or the
data until it's been told to open or load it beforehand. The trick is to
make the job so easy that the length of time you wait is insignificant. You
can also set the minimum size of the cache in ASP applications so the next
time a connection is requested, it's already there are ready to go.

Show quoteHide quote

Saving DateTime to Sql Server 2005
Parameter has no default value
Locking an Access table
Getting AutoNum field from updated db table via data adapter
new error - Column is read only