Posting data to a file then doing a bulk insert to a database

347 100+

I am relatively new to .net and have created a page that is using a file input control and an upload button. What I would like this page to do is load the file to a directory on the server (saving a copy of the file) then executing a bulk insert to a sql database after the file has been submitted. I have 2 problems

1. I can't get the file to save to the server.
2. I have no idea how to fire the bulk insert script off after that.

Here is my code thus far:

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>File Upload</title>

    <style type="text/css">

        #form1

        {

            height: 60px;

            width: 832px;

            top: 56px;

            left: 5px;

            position: absolute;

        }

        #Submit1

        {

            text-align: center;

            width: 69px;

            top: 93px;

            left: 632px;

            position: absolute;

            height: 26px;

        }

        .style1

        {

            text-align: center;

            height: 1px;

        }

    </style>

   </head>

<body>

    <form id="form1" runat="server">

 <p class="style1">&nbsp;Please Upload your File Here:</p>

    <p class="style1">

        <asp:FileUpload ID="FileUpload1" runat="server" 

            style="z-index: 1; left: 512px; top: -2px; position: absolute" />

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

    </p>

    <asp:Button ID="Button1" runat="server" 
 
     style="z-index: 1; left: 619px; top: 92px; position: absolute; height: 26px;" 

     Text="Upload" SaveAs="C:\Inetpub\Sandbox\Files" />
 
     <% Dim ConnectionString

ConnectionString="Driver={10.2.1.40};Server=10.2.1.40;" &_

"Database=IVRDialer;Uid=xxx;Pwd=xxx;"
 
ALTER TABLE dialerresults

(phonenumber VARCHAR(20),

patientname VARCHAR(20),

drname VARCHAR(30),

apptdate TEXT (16),

appttime TEXT (16)

GO

BULK

INSERT dialerresults

FROM 'C:\IVR test\csvtest.txt'

WITH

(

FIELDTERMINATOR = ',',

ROWTERMINATOR = '\n'

)

GO

--Check the content of the table.

SELECT *

FROM dialerresults

GO

--Drop the table to clean up database.

SELECT *

FROM dialerresults

GO %>
 
<style type="text/css">

.style1 {

    text-align: center;

}

</style>
 
</form>

</body>

</html>

Can anyone please offer some suggestions.

Thank you

Doug

Apr 19 '10 #1

Subscribe Post Reply

932

Frinavale

9,735

Expert Mod 8TB

Why can't you get the file to the server?

Check out the documentation for the FileUpload control for information about how to use this control.

-Frinny

Apr 27 '10 #2

Similar topics

Bulk loading data

by: cmars | last post by:

Hi, I want to insert massive amounts of data in near real-time into a MySQL database. The data is in a structured binary format, and I have code that parses the data into logical data structures. ...

MySQL Database

Indexes on Bulk Insert data

by: Chris | last post by:

Any help would be appreciated. I am running a script that does the following in succession. 1-Drop existing database and create new database 2-Defines tables, stored procedures and functions...

Microsoft SQL Server

.exe to insert data in SQLServer database

by: Santo Santis | last post by:

How can I make an .exe file that can insert data automatically in a SQLServer database, I can do it in C, but how can I connect to SQLServer and execute a query. All data that I have to insert...

Microsoft SQL Server

Is it possible to write a format file that skips a few bytes of header in data file?

by: Bob | last post by:

Hi, I am trying to use BULK INSERT with format file. All of our data has few bytes of header in the data file which I would like to skip before doing BULK INSERT. Is it possible to write...

Microsoft SQL Server

Heavy Data-Import to Access

by: Innuendo | last post by:

Hello, I'm not a specialist with Access - so I hope that you can give me some input. I've to import xml data (about 15 different data fields) into an access-database each night. As scripting...

Microsoft Access / VBA

Bulk delete on operational data

by: Zarrin | last post by:

Hello, I read several articles of newsgroup about the bulk delete, and I found one way is to: -create a temporary table with all constraints of original table -insert rows to be retained into...

Microsoft SQL Server

Copying Data from Access to SQL Server

by: TC | last post by:

I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...

Microsoft Access / VBA

USING BULK INSERT to add data to existing tables

by: tezza98 | last post by:

HI i am using BULK INSERT to copy data from a text file into a table that already exists BULK INSERT dbo.TRANStemp FROM 'D:\MSSQL\Data\TRANS.csv' WHERE dbo.TRANStemp.DateTime <> ...

Microsoft SQL Server

import this data into SQL Server

by: =?Utf-8?B?Ym9iYnk=?= | last post by:

Could you please help me in this project. I have aTab delemeted file. It has 20 columns and some data. I have to import this data into SQL Server. I am using sql express edition. I am using...

C# / C Sharp

Saving data quickly to a database

by: Jon | last post by:

Hi, I plan to import some data from an old DOS-based programme. The data file format that this programme produced appears to be proprietary, but I've managed to reverse engineer the format and...

C# / C Sharp

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp