Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
100000 records in txt file, need fast way to upload to database
Your sample show that you are building this table in memory. Your problem could be creating a lot of garbage collections or swaping. If you can try writing batches of data to the database and clear out the data service table. If you're using SQL Server 2000 I would have your data service call...- fellthor
- Post #2
- Forum: Visual Basic (Classic)
-
Database CRUD Design Pattern (using .NET)
I haven't seen any design patterns that are specific to this problem. However, ADO.Net classes are a great tool for this type of work. The hardest thing you would have to do is set up the structure for strongly typed DataSets. It's actually pretty easy, it just takes a little work. Using the...- fellthor
- Post #2
- Forum: Object-Oriented Analysis & Design
-
ADO.Net Update Question
No you don't have to do anything with the table (Unless you like to write a lot of code). MSDN says -- "When RejectChanges is called, any DataRow objects that are still in edit-mode cancel their edits. New rows are removed. Rows with the DataRowState set to Modified or Deleted return...- fellthor
- Post #2
- Forum: Visual Basic (Classic)
-
basic (?) file copying question
You can only move or copy one file at a time with this object.method. You could create an array of file name and loop through it passing the string to a FileInfo object. The Common Dialog classes also have a FileNames property that allow the user to select a number of files. File class is...- fellthor
- Post #2
- Forum: C# (C sharp): Microsoft
