Configure AjaxUploader to store uploaded files in SQL Server instead of the
file system. Files are stored as binary data in a database table, making them
easy to manage and back up with your database. Configure via
web.config connection strings and appSettings.
What you should see: files stored as rows in SQL Server rather than on disk. Only the server-side provider changes - the markup is the same control.
Drag & drop files here, or paste from clipboard
<%-- web.config: connection string and provider settings --%>
<connectionStrings>
<add name="UploadDb"
connectionString="Server=.;Database=MyApp;Trusted_Connection=true;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="AjaxUploader:StorageProvider" value="SqlServer" />
<add key="AjaxUploader:ConnectionStringName" value="UploadDb" />
<add key="AjaxUploader:TableName" value="UploadedFiles" />
<add key="AjaxUploader:SchemaName" value="dbo" />
<add key="AjaxUploader:AutoCreateTable" value="true" />
</appSettings>
<%-- The provider automatically creates a table like: --%>
-- CREATE TABLE [dbo].[UploadedFiles] (
-- [Id] UNIQUEIDENTIFIER PRIMARY KEY,
-- [FileName] NVARCHAR(256),
-- [ContentType] NVARCHAR(128),
-- [FileSize] BIGINT,
-- [FileData] VARBINARY(MAX),
-- [CreatedAt] DATETIME2 DEFAULT GETUTCDATE()
-- );
<%-- Retrieve a file from SQL Server in an .ashx handler --%>
public class FileHandler : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
Guid id;
if (!Guid.TryParse(context.Request.QueryString["id"], out id))
{
context.Response.StatusCode = 400;
return;
}
string connStr = ConfigurationManager
.ConnectionStrings["UploadDb"].ConnectionString;
using (var conn = new SqlConnection(connStr))
using (var cmd = new SqlCommand(
"SELECT FileName, ContentType, FileData " +
"FROM UploadedFiles WHERE Id = @Id", conn))
{
cmd.Parameters.AddWithValue("@Id", id);
conn.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
context.Response.ContentType =
reader["ContentType"].ToString();
context.Response.BinaryWrite(
(byte[])reader["FileData"]);
}
}
}
}
}