PC Review


Reply
Thread Tools Rate Thread

DataTable Fill

 
 
chiragc@gmail.com
Guest
Posts: n/a
 
      23rd Jun 2006
I am running into a little problem in filling my datatable from an
access DB.

driverVehicleComb is a DataTable

driverVehicleComb .Clear();
oleDbDataAdapter1.SelectCommand.CommandText = "SELECT ID,Name from
Vehicles";
oleDbDataAdapter1.Fill(driverVehicleComb);

So the first time I run the command above (I left out a few lines but
it works) it runs very quickly. But the second
time I run the same method, on the DataAdapter fill method, it takes
more than 300 milliseconds to fill the table again.

Anybody know why?

I solved the problem by setting the driverVehicleComb to a new
DataTable instead of clearing it, but I was just wondering why this
happens....

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataTable has now rows in it after fill =?Utf-8?B?QW5kcmU=?= Microsoft ASP .NET 4 10th May 2006 09:45 PM
How to fill a datatable with data from another datatable =?Utf-8?B?Q29lbg==?= Microsoft ADO .NET 2 28th Feb 2006 07:57 AM
Fill datatable ruca Microsoft ASP .NET 3 4th Oct 2005 12:19 PM
Fill datatable ruca Microsoft VB .NET 3 4th Oct 2005 12:19 PM
Fill a datatable from a datareader? Tom Microsoft ADO .NET 2 30th Jan 2004 03:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:18 PM.