This is a mirror of official site: http://jasper-net.blogspot.com/

Saving Files Into Database Using .NET Web Services

| Sunday, October 3, 2010
Introduction

A few months ago, my boss asked me to create Outlook Add-In which can save email attachments on SQL Server database. Main problem was that users could not connect to SQL Server directly, because instance of SQL Server was behind firewall. Second problem was, users wanted to see percentage status of file transferring. So I decided to create .NET Web Service to solve this problem. In this article I will show you, how to save big files on SQL Server database by Web Service.

Background

One of the options, how to store big files into the database using .NET Web Service is to parse file into a few smaller parts and then transfer this parts separately on the server into temporary file. After upload, you can save this file into database.

Database

Our first step is creating a database. In this sample I created database called FileStorage with one table File

Read more: Codeproject

Posted via email from .NET Info

0 comments: