if not exists (select * from sysobjects where id = object_id(N'Indoo_template_0105') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN create table Indoo_template_0105 (ID bigint PRIMARY KEY IDENTITY(1, 1), Title nvarchar (MAX) NULL, FileContent image NULL, FileDate Datetime NULL, FileMimeType nvarchar (MAX) NULL, UserID bigint NULL, FileName nvarchar(MAX), FileSize bigint NULL ) END gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0105 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 moduleHeader moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createtable.addcreatestatement on gridViewColumn.1.Visible on gridViewColumn.1.allowExport gridViewColumn.1.allowEdit gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort gridViewColumn.1.allowImport gridViewColumn.1.columnName ID gridViewColumn.1.caption Picture 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 2 gridViewColumn.1.isBinary on gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.binaryData.columnName FileContent gridViewColumn.1.binaryData.showType 1 gridViewColumn.1.binaryData.FilenameSource 2 gridViewColumn.1.binaryData.mimeTypeSource 2 gridViewColumn.1.binaryData.allowExport gridViewColumn.1.binaryData.allowImport gridViewColumn.1.binaryData.target _blank altertable.addalterstatement on gridViewColumn.1.binaryData.thumbnailWidth 80 gridViewColumn.1.binaryData.thumbnailHeight 80 gridViewColumn.1.binaryData.mimeTypeColumnName FileMimeType gridViewColumn.1.binaryData.FilenameColumnName FileName gridViewColumn.1.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 0 gridEditColumn.0.binaryData.saveLengthToColumnName FileSize gridEditColumn.0.binaryData.target _blank gridEditColumn.0.binaryData.showType 3 gridEditColumn.0.binaryData.FilenameSource 2 gridEditColumn.0.binaryData.mimeTypeSource 2 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.0.Visible on gridViewColumn.0.allowExport gridViewColumn.0.allowEdit gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort gridViewColumn.0.allowImport gridViewColumn.0.columnName FileDate gridViewColumn.0.caption 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 0 gridViewColumn.0.isBinary gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.2.Visible on gridViewColumn.2.allowExport gridViewColumn.2.allowEdit gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort gridViewColumn.2.allowImport gridViewColumn.2.columnName FileName 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 Title gridViewColumn.3.caption 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 gridViewColumn.3.isHtmlAttributes gridViewColumn.4.Visible on gridViewColumn.4.allowExport gridViewColumn.4.allowEdit gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort gridViewColumn.4.allowImport gridViewColumn.4.columnName UserID gridViewColumn.4.caption gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isOther 0 gridViewColumn.4.isBinary gridViewColumn.4.isJoin on gridViewColumn.4.isHtmlAttributes gridViewColumn.4.navigateUrlTarget _blank gridViewColumn.4.joinTableName Users gridViewColumn.4.joinTableIdColumnName UserID gridViewColumn.4.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 gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 1 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.columnName FileSize gridViewColumn.5.caption gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isOther 0 gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes notskipsqlonimport on showGridView on showGridEdit on sqlOnUpdateFinishRecord gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.1.binaryData.isBinaryIdFromColumn gridViewColumn.1.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 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> gridViewColumn.1.regExClient on gridViewColumn.0.regExClient on gridViewColumn.2.regExClient on gridViewColumn.3.regExClient on gridViewColumn.4.regExClient on gridViewColumn.5.regExClient on alternateTablename alternateConnectionString gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0105 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 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 1 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 2 gridViewColumn.0.binaryData.mimeTypeSource 2 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 0 gridEditColumn.0.binaryData.saveLengthToColumnName FileSize gridEditColumn.0.binaryData.target _blank gridEditColumn.0.binaryData.showType 3 gridEditColumn.0.binaryData.FilenameSource 2 gridEditColumn.0.binaryData.mimeTypeSource 2 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 FileName 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 Title gridViewColumn.3.caption 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 gridViewColumn.3.isHtmlAttributes gridViewColumn.4.Visible on gridViewColumn.4.allowExport gridViewColumn.4.allowEdit gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort gridViewColumn.4.allowImport gridViewColumn.4.columnName UserID gridViewColumn.4.caption gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isOther 0 gridViewColumn.4.isBinary gridViewColumn.4.isJoin on gridViewColumn.4.isHtmlAttributes gridViewColumn.4.navigateUrlTarget _blank gridViewColumn.4.joinTableName Users gridViewColumn.4.joinTableIdColumnName UserID gridViewColumn.4.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 gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 1 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.columnName FileSize gridViewColumn.5.caption gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isOther 0 gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes notskipsqlonimport on showGridView on showGridEdit on sqlOnUpdateFinishRecord gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.0.binaryData.isBinaryIdFromColumn 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 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> gridViewColumn.0.regExClient on gridViewColumn.1.regExClient on gridViewColumn.2.regExClient on gridViewColumn.3.regExClient on gridViewColumn.4.regExClient on gridViewColumn.5.regExClient on alternateTablename alternateConnectionString