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.