if not exists (select * from sysobjects where id = object_id(N'Indoo_template_0104') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN create table Indoo_template_0104 (ID bigint PRIMARY KEY IDENTITY(1, 1), Title nvarchar (MAX) NULL, FileContent image NULL, FileDate Datetime NULL, UserID bigint NULL, ModuleID int NULL) END GO IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = N'idx_Indoo_template_0104_mid') CREATE INDEX idx_Indoo_template_0104_mid ON Indoo_template_0104 (ModuleID) GO IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = N'idx_Indoo_template_0104_uid') CREATE INDEX idx_Indoo_template_0104_uid ON Indoo_template_0104 (UserID) gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0104 tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord on gridview.deleterecord on gridview.viewrecord on hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on binaryData.fileSytemDBPath networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere ModuleID=[indoogrid:moduleID] moduleHeader moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createtable.addcreatestatement on gridViewColumn.0.Visible on gridViewColumn.0.allowExport gridViewColumn.0.allowEdit gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort gridViewColumn.0.allowImport gridViewColumn.0.columnName ID gridViewColumn.0.caption Picture gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther 2 gridViewColumn.0.isBinary on gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.binaryData.columnName FileContent gridViewColumn.0.binaryData.showType 1 gridViewColumn.0.binaryData.FilenameSource 1 gridViewColumn.0.binaryData.mimeTypeSource 1 gridViewColumn.0.binaryData.allowExport gridViewColumn.0.binaryData.allowImport gridViewColumn.0.binaryData.target _blank altertable.addalterstatement on gridViewColumn.0.binaryData.thumbnailWidth 80 gridViewColumn.0.binaryData.thumbnailHeight 80 gridViewColumn.0.binaryData.mimeTypeColumnName FileMimeType gridViewColumn.0.binaryData.FilenameColumnName FileName gridViewColumn.0.binaryData.defaultImageUrl gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridEditColumn.0.columnName FileContent gridEditColumn.0.caption gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.Readonly gridEditColumn.0.isHtmlAttributes gridEditColumn.0.binaryLocation 1 gridEditColumn.0.binaryData.saveLengthToColumnName gridEditColumn.0.binaryData.target _blank gridEditColumn.0.binaryData.showType 3 gridEditColumn.0.binaryData.FilenameSource 1 gridEditColumn.0.binaryData.mimeTypeSource 1 gridEditColumn.0.binaryData.thumbnailWidth 120 gridEditColumn.0.binaryData.thumbnailHeight 120 gridEditColumn.0.binaryData.mimeTypeColumnName FileMimeType gridEditColumn.0.binaryData.defaultImageUrl gridEditColumn.0.binaryData.uploadLimit 2000000 gridEditColumn.0.binaryData.extensionAllowedList gridEditColumn.0.binaryData.extensionDeniedList gridViewColumn.1.Visible on gridViewColumn.1.allowExport gridViewColumn.1.allowEdit gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort gridViewColumn.1.allowImport gridViewColumn.1.columnName FileDate gridViewColumn.1.caption gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.2.Visible on gridViewColumn.2.allowExport gridViewColumn.2.allowEdit gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort gridViewColumn.2.allowImport gridViewColumn.2.columnName Title gridViewColumn.2.caption gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.3.Visible on gridViewColumn.3.allowExport gridViewColumn.3.allowEdit gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort gridViewColumn.3.allowImport gridViewColumn.3.columnName UserID gridViewColumn.3.caption UserName gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary gridViewColumn.3.isJoin on gridViewColumn.3.isHtmlAttributes gridViewColumn.3.navigateUrlTarget _blank gridViewColumn.3.joinTableName Users gridViewColumn.3.joinTableIdColumnName UserID gridViewColumn.3.joinTableColumnName Username gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridEditColumn.1.columnName Title gridEditColumn.1.caption gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText gridEditColumn.1.multipageConditions gridEditColumn.1.Readonly gridEditColumn.1.isHtmlAttributes gridEditColumn.1.fieldValue gridEditColumn.1.textBoxWidth gridEditColumn.1.allowUrlInput gridEditColumn.1.fieldValueAsInsert gridEditColumn.1.DropDownList gridEditColumn.1.CustomValidator gridEditColumn.1.regExClient on gridEditColumn.1.password gridEditColumn.1.multiline gridEditColumn.1.editor gridEditColumn.1.isBoolean gridEditColumn.2.Visible gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridEditColumn.2.columnName FileDate gridEditColumn.2.caption gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.Readonly gridEditColumn.2.isHtmlAttributes gridEditColumn.2.dateTimePicker gridEditColumn.2.fieldValue [indoogrid:currentDate:G] gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput gridEditColumn.3.Visible gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.columnName UserID gridEditColumn.3.caption gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.Readonly gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue [User:userID] gridEditColumn.3.fieldFormat gridEditColumn.3.textBoxWidth gridEditColumn.3.allowUrlInput gridEditColumn.0.binaryData.FilenameColumnName FileName notSkipSqlOnImport on showGridView on showGridEdit on sqlOnUpdateFinishRecord gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.0.binaryData.isBinaryIdFromColumn gridViewColumn.0.binaryData.mimeType gridViewColumn.0.binaryData.Filename grideditcolumn.0.binarydata.isforcedownload gridEditColumn.0.binaryData.mimeType gridEditColumn.0.binaryData.Filename gridEditColumn.4.Visible gridEditColumn.4.multiplePage 1 gridEditColumn.4.Autovalidator on gridEditColumn.4.columnName ModuleID gridEditColumn.4.caption gridEditColumn.4.separator gridEditColumn.4.trCssClass gridEditColumn.4.helpText gridEditColumn.4.multipageConditions gridEditColumn.4.Readonly gridEditColumn.4.isHtmlAttributes gridEditColumn.4.fieldValue [indoogrid:moduleID] gridEditColumn.4.fieldFormat gridEditColumn.4.textBoxWidth gridEditColumn.4.allowUrlInput gridEditColumn.4.fieldValueAsInsert gridEditColumn.4.DropDownList gridViewColumn.0.customHTMLForm <CENTER> <DIV><IMG style="VISIBILITY: hidden; POSITION: absolute" onerror="this.width='1px';this.height='1px'" src="[indoogrid:moduleFolder]images/preload.gif"><IMG style="DISPLAY: none; VISIBILITY: hidden; POSITION: absolute" onclick="this.style.display ='none'" onmouseout="this.style.display ='none'" onload="this.style.marginLeft=-((this.width/2)-(this.nextSibling.width/2));this.style.marginTop=-((this.height/2)-(this.nextSibling.height/2));this.style.visibility='visible';this.previousSibling.style.display='none'"><IMG onerror="this.width='1px';this.height='1px'" onmouseover="img2=this.previousSibling;if (img2.src==''){img2.src='[indooGrid:binaryLink]'};img2.style.display='block'; this.previousSibling.previousSibling.style.visibility='visible'" src="[indooGrid:binaryLinkThumbnail]"></DIV><STRONG>[columnField:Title]</STRONG> </CENTER> alternateTablename alternateConnectionString gridviewcolumn.1.binarydata.isforcedownload gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0104 tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord on gridview.deleterecord on gridview.viewrecord on hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on binaryData.fileSytemDBPath |DataDirectory|indooGrid\ networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere ModuleID=[indoogrid:moduleID] moduleHeader moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createtable.addcreatestatement on gridViewColumn.0.Visible on gridViewColumn.0.allowExport gridViewColumn.0.allowEdit gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort gridViewColumn.0.allowImport gridViewColumn.0.columnName ID gridViewColumn.0.caption Picture gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther 2 gridViewColumn.0.isBinary on gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.binaryData.columnName FileContent gridViewColumn.0.binaryData.showType 1 gridViewColumn.0.binaryData.FilenameSource 1 gridViewColumn.0.binaryData.mimeTypeSource 1 gridViewColumn.0.binaryData.allowExport gridViewColumn.0.binaryData.allowImport gridViewColumn.0.binaryData.target _blank altertable.addalterstatement on gridViewColumn.0.binaryData.thumbnailWidth 80 gridViewColumn.0.binaryData.thumbnailHeight 80 gridViewColumn.0.binaryData.mimeTypeColumnName FileMimeType gridViewColumn.0.binaryData.FilenameColumnName FileName gridViewColumn.0.binaryData.defaultImageUrl gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridEditColumn.0.columnName FileContent gridEditColumn.0.caption gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.Readonly gridEditColumn.0.isHtmlAttributes gridEditColumn.0.binaryLocation 1 gridEditColumn.0.binaryData.saveLengthToColumnName gridEditColumn.0.binaryData.target _blank gridEditColumn.0.binaryData.showType 3 gridEditColumn.0.binaryData.FilenameSource 1 gridEditColumn.0.binaryData.mimeTypeSource 1 gridEditColumn.0.binaryData.thumbnailWidth 120 gridEditColumn.0.binaryData.thumbnailHeight 120 gridEditColumn.0.binaryData.mimeTypeColumnName FileMimeType gridEditColumn.0.binaryData.defaultImageUrl gridEditColumn.0.binaryData.uploadLimit 2000000 gridEditColumn.0.binaryData.extensionAllowedList gridEditColumn.0.binaryData.extensionDeniedList gridViewColumn.1.Visible on gridViewColumn.1.allowExport gridViewColumn.1.allowEdit gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort gridViewColumn.1.allowImport gridViewColumn.1.columnName FileDate gridViewColumn.1.caption gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.2.Visible on gridViewColumn.2.allowExport gridViewColumn.2.allowEdit gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort gridViewColumn.2.allowImport gridViewColumn.2.columnName Title gridViewColumn.2.caption gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.3.Visible on gridViewColumn.3.allowExport gridViewColumn.3.allowEdit gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort gridViewColumn.3.allowImport gridViewColumn.3.columnName UserID gridViewColumn.3.caption UserName gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary gridViewColumn.3.isJoin on gridViewColumn.3.isHtmlAttributes gridViewColumn.3.navigateUrlTarget _blank gridViewColumn.3.joinTableName Users gridViewColumn.3.joinTableIdColumnName UserID gridViewColumn.3.joinTableColumnName Username gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridEditColumn.1.columnName Title gridEditColumn.1.caption gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText gridEditColumn.1.multipageConditions gridEditColumn.1.Readonly gridEditColumn.1.isHtmlAttributes gridEditColumn.1.fieldValue gridEditColumn.1.textBoxWidth gridEditColumn.1.allowUrlInput gridEditColumn.1.fieldValueAsInsert gridEditColumn.1.DropDownList gridEditColumn.1.CustomValidator gridEditColumn.1.regExClient on gridEditColumn.1.password gridEditColumn.1.multiline gridEditColumn.1.editor gridEditColumn.1.isBoolean gridEditColumn.2.Visible gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridEditColumn.2.columnName FileDate gridEditColumn.2.caption gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.Readonly gridEditColumn.2.isHtmlAttributes gridEditColumn.2.dateTimePicker gridEditColumn.2.fieldValue [indoogrid:currentDate:G] gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput gridEditColumn.3.Visible gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.columnName UserID gridEditColumn.3.caption gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.Readonly gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue [User:userID] gridEditColumn.3.fieldFormat gridEditColumn.3.textBoxWidth gridEditColumn.3.allowUrlInput gridEditColumn.0.binaryData.FilenameColumnName FileName notSkipSqlOnImport on showGridView on showGridEdit on sqlOnUpdateFinishRecord gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.0.binaryData.isBinaryIdFromColumn gridViewColumn.0.binaryData.mimeType gridViewColumn.0.binaryData.Filename grideditcolumn.0.binarydata.isforcedownload gridEditColumn.0.binaryData.mimeType gridEditColumn.0.binaryData.Filename gridEditColumn.4.Visible gridEditColumn.4.multiplePage 1 gridEditColumn.4.Autovalidator on gridEditColumn.4.columnName ModuleID gridEditColumn.4.caption gridEditColumn.4.separator gridEditColumn.4.trCssClass gridEditColumn.4.helpText gridEditColumn.4.multipageConditions gridEditColumn.4.Readonly gridEditColumn.4.isHtmlAttributes gridEditColumn.4.fieldValue [indoogrid:moduleID] gridEditColumn.4.fieldFormat gridEditColumn.4.textBoxWidth gridEditColumn.4.allowUrlInput gridEditColumn.4.fieldValueAsInsert gridEditColumn.4.DropDownList gridViewColumn.0.customHTMLForm <CENTER> <DIV><IMG style="VISIBILITY: hidden; POSITION: absolute" onerror="this.width='1px';this.height='1px'" src="[indoogrid:moduleFolder]images/preload.gif"><IMG style="DISPLAY: none; VISIBILITY: hidden; POSITION: absolute" onclick="this.style.display ='none'" onmouseout="this.style.display ='none'" onload="this.style.marginLeft=-((this.width/2)-(this.nextSibling.width/2));this.style.marginTop=-((this.height/2)-(this.nextSibling.height/2));this.style.visibility='visible';this.previousSibling.style.display='none'"><IMG onerror="this.width='1px';this.height='1px'" onmouseover="img2=this.previousSibling;if (img2.src==''){img2.src='[indooGrid:binaryLink]'};img2.style.display='block'; this.previousSibling.previousSibling.style.visibility='visible'" src="[indooGrid:binaryLinkThumbnail]"></DIV><STRONG>[columnField:Title]</STRONG> </CENTER> alternateTablename alternateConnectionString gridviewcolumn.1.binarydata.isforcedownload