Here we feature a few methods for loading files into an Oracle or SQL Server database. There are many methods for accomplishing this, but over the past few projects, and after implementing most of the methods discussed, I documented some of my experiences. Here I focus on developing an application or process to load data […]
About Steve Shantz
Steve Shantz is the chief programmer and a founding member of Data Warehouse Consultants. He is the primary technical lead on many projects and manages internal software development for the firm. In addition to being an expert programmer in many languages, Steve has an extensive prior background in training and project management as an Infantry Officer in the United States Marine Corps.
Entries by Steve Shantz
This article features some methods that I have used to load data within a C# application. The methods discussed are an Insert Loop (with bind parameters), the DataAdapter.Update() method, and a custom method of passing the table to a stored procedure. For this article, a simple website demo was setup that accepted a 6-column CSV […]