Insert ImageInsert TemplateAttach FileRemove AttachmentsInsert FlashInsert Windows Media
DesignHTMLPreview

Description
Server Explorer lets you upload files to your database.

If you have Microsoft SQL Server 2005 Express Edition installed on your machine, you can use the database UltimateEditorDatabase under App_Data. Otherwise, you may run the SQL query CreateTable_UltimateEditorFile under Controls\Documents\Database.

You also need to add the configurations settings from UploadDatabaseConfig.xml to your Web.config file.

UltimateEditor stores the uploaded file in your database as below:

Column Name Data Type Description
id int Identity column (primary key and auto-increment)
name varchar(256) File name
data image File content
content_type varchar(50) File content type
size int File size

Server-side API provides the FileInDatabase class with the following methods:

Method Name Description
GetFileInfoFromDatabaseByID Gets the file information from the database by given file ID.
GetFileInfoFromDatabaseByName Gets the file information from the database by given file name.
GetFileIDFromPath Gets the file ID from the query string of the path.

Please visit User Permission (Database) sample to see how you can control user access to files in your database.

Note that this feature is supported in .NET 2.0 and higher.