Sql File Provider Notes
The following guide shows the steps to config MSSQL Server file provider in RichTextEditor.
1. Add Provider code to project
Copy SqlFileProvider.cs file to your application App_Code folder.
2. Create file storage items table in database
Execute fsitems.sql against your existing database or create a new database.
3. Set sql connection string to SqlFileProvider
Update SqlFileProvider.cs to use your custom connection string.
static public string ConnectionString
{
get
{
return "server=(local);database=rtedb;trusted_connection=false;uid=test;pwd=test;";
}
}
{
get
{
return "server=(local);database=rtedb;trusted_connection=false;uid=test;pwd=test;";
}
}
4. Set FileProviderType of RichTextEditor and copy download.ashx to your application
Copy SqlFileProvider/download.ashx to your website folder, you can rename it.
Use SetSecurity method to set the FileProviderType.
Editor1.SetSecurity("*", "*", "FileProviderType", typeof(SqlFileProvider).AssemblyQualifiedName);
Editor1.SetSecurity("*", "*", "StoragePath", "/");
Editor1.SetSecurity("*", "*", "FileProviderArg0", "download.ashx?file=");
Editor1.SetSecurity("*", "*", "StoragePath", "/");
Editor1.SetSecurity("*", "*", "FileProviderArg0", "download.ashx?file=");