dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
 

Tip: Turn Off the Index Maintenance of DataTable when you Load Data

Learn how to turn indexing on and off when loading data.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


A Dataset maintains an index, or many indexes, to facilitate the high performance when it is traversed for data. An example of such a situation is when you use the Find or a Select option looking to filter for DataRows on a condition.

So, when you are loading rows into the DataTable with the DataAdapter.Fill or AddRow or Merger, you should indicate to the DataTable that it should switch off this index maintenance when rows are loaded.

You can do this by using the "BeginLoadData" method of the datatable.

dataTable.BeginLoadData()
dataSet.Tables[0].BeginLoadData()

However, you also need to turn it on at the end of loading the data. You can do it by using the following code:

EndLoadData method of the DataTable.
dataTable.EndLoadData();
dataTable.Tables[0].EndLoadData()

 

Visit the DevX Tip Bank

 





   
Srinath M. S. says: "I would love to leave a footprint in this flat world."
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date