Geeks Talk

Prepare for your Next Interview




Storing data in db without iterating

This is a discussion on Storing data in db without iterating within the C# forums, part of the Software Development category; I have a method in C# which writes data to MS-Access tables.Data is present in an array of objects,which has to be read into the tables.Is ...


Go Back   Geeks Talk > Software Development > C#

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 04-01-2007
Junior Member
 
Join Date: Dec 2006
Location: India
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Samudyatha is on a distinguished road
Storing data in db without iterating

I have a method in C# which writes data to MS-Access tables.Data is present in an array of objects,which has to be read into the tables.Is there any way to store the data in the db without having to iterate thru the objects individually and calling the insert statements thru ADO.Net for every iteration?Any suggestions regarding this would be of great help...
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-31-2007
Junior Member
 
Join Date: Feb 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
rajinder.sidhu is on a distinguished road
Re: Storing data in db without iterating

You can use Bulk Copy Paste facility. It is used to import or export from databases
Reply With Quote
Reply

  Geeks Talk > Software Development > C#


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Get the data into data file while uploading JobHelper Oracle Apps 1 03-03-2007 10:38 PM
Path for storing JSP or servlet files JobHelper JSP 1 01-05-2007 12:48 PM
Data generator sutnarcha Testing Issues 0 12-27-2006 04:15 AM
data conversion jaindharmendrakumar SQL 0 11-21-2006 05:57 AM
Data type in SQL blenda Oracle 2 06-29-2006 02:16 PM


All times are GMT -4. The time now is 01:39 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved