Save Files to a Database in ASP.NET by using FileUpload Control
We can easily save the files in SQL Server database by using FileUpload control(to browse the files) in Asp.Net. For that first create table FIleInfo in SQL Server by using following SQL script.
USE [test]
GO
/****** Object: Table [dbo].[FileInfo] Script Date: 03/04/2012 20:22:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FileInfo](
[Id] [int] IDENTITY(1,1) NOT NULL,
[FileName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileContent] [varbinary](max) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Create asp.net web site and add below code for .aspx file and .aspx.cs file.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" 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>Save Files in Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lbl1" runat="server" Text="Select File: "></asp:Label>
<asp:FileUpload ID="fu1" runat="server" /><br /><br />
<asp:Button Text="Save File" runat="server" ID="btn1" OnClick="btn1_Click"/>
<asp:SqlDataSource id="srcFiles" ConnectionString="Server=localhost;Integrated Security=True;Initial Catalog=test"
InsertCommand="INSERT FileInfo(FileName,FileContent) VALUES(@FileName,@FileContent)" Runat="server">
<InsertParameters>
<asp:ControlParameter Name="FileName" ControlID="fu1" PropertyName="FileName" />
<asp:ControlParameter Name="FileContent" ControlID="fu1" PropertyName="FileBytes" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
using System;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btn1_Click(object sender, EventArgs e)
{
if (fu1.HasFile)
{
srcFiles.Insert();
}
}
}
When you click the button, the btn1_Click() method executes. This method executes the the SqlDataSource control’s Insert() method and it insert the values of the FileUpload control’s FileName and FileBytes properties into a SQL database test, FileInfo table.
FileUpload control FileName property provides the name of the file and FileBytes property provides content of the file in binary format.
