if not exists (select * from sysobjects where id = object_id(N'Indoo_template_0101') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN create table Indoo_template_0101 (ID bigint PRIMARY KEY IDENTITY(1, 1), Title nvarchar (200) NULL, YouTubeEmbededLink nvarchar (1000) NULL, UserID bigint NULL, ModuleID int NULL,) END GO IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = N'idx_Indoo_template_0101_mid') CREATE INDEX idx_Indoo_template_0101_mid ON Indoo_template_0101 (ModuleID) GO IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = N'idx_Indoo_template_0101_uid') CREATE INDEX idx_Indoo_template_0101_uid ON Indoo_template_0101 (UserID) gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0101 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 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 <script> function Indoo_template_0101_f1_(iframe,text){ iframe.contentWindow.document.write(text) vid=text.substring(text.indexOf('http://www.youtube.com/v/')+25,text.indexOf('&')) imgv=iframe.parentNode.childNodes[1];imgv.src="http://img.youtube.com/vi/" + vid + "/default.jpg" if (vid==''){imgv.width='1px';imgv.height='1px'} } </script> startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createtable.addcreatestatement on altertable.addalterstatement on gridViewColumn.0.customHTMLForm <CENTER> <DIV><STRONG>[columnField:Title]</STRONG> <SCRIPT>var Indoo_template_0101_v1_[columnField:ID]='[columnField:YouTubeEmbededLink]'</SCRIPT> <DIV><IFRAME style="MARGIN-TOP: -100px; DISPLAY: none; MARGIN-LEFT: -120px; WIDTH: 425px; POSITION: absolute; HEIGHT: 355px" onmouseout="this.style.display ='none';" marginWidth=0 src="" frameBorder=0 scrolling=no onload=Indoo_template_0101_f1_(this,Indoo_template_0101_v1_[columnField:ID])> </IFRAME><IMG onmouseover="this.parentNode.childNodes[0].style.display='block';"> </DIV></DIV></CENTER> skipsqlonimport gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.columnName ID gridViewColumn.0.caption Video 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 gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.htmlAttributesname.1 gridViewColumn.0.htmlAttributesvalue.1 gridViewColumn.0.htmlAttributesname.2 gridViewColumn.0.htmlAttributesvalue.2 gridViewColumn.0.htmlAttributesname.3 gridViewColumn.0.htmlAttributesvalue.3 gridViewColumn.0.htmlAttributesname.4 gridViewColumn.0.htmlAttributesvalue.4 gridViewColumn.0.htmlAttributesname.5 gridViewColumn.0.htmlAttributesvalue.5 gridViewColumn.0.htmlAttributesname.6 gridViewColumn.0.htmlAttributesvalue.6 gridViewColumn.0.htmlAttributesname.7 gridViewColumn.0.htmlAttributesvalue.7 gridViewColumn.0.htmlAttributesname.8 gridViewColumn.0.htmlAttributesvalue.8 gridViewColumn.0.htmlAttributesname.9 gridViewColumn.0.htmlAttributesvalue.9 gridViewColumn.0.htmlAttributesname.10 gridViewColumn.0.htmlAttributesvalue.10 gridViewColumn.1.columnName Title gridViewColumn.1.Visible on gridViewColumn.1.allowExport gridViewColumn.1.allowEdit gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort gridViewColumn.1.allowImport gridEditColumn.0.columnName Title gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.2.columnName YouTubeEmbededLink gridViewColumn.2.Visible gridViewColumn.2.allowExport gridViewColumn.2.allowEdit gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort gridViewColumn.2.allowImport gridEditColumn.1.columnName YouTubeEmbededLink gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.3.columnName UserID gridViewColumn.3.Visible gridViewColumn.3.allowExport gridViewColumn.3.allowEdit gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort gridViewColumn.3.allowImport gridEditColumn.2.columnName UserID gridEditColumn.2.Visible gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption UserName gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption gridEditColumn.2.Readonly gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText Insert You tube embeded link (not url) gridEditColumn.1.multipageConditions gridEditColumn.1.isHtmlAttributes gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.isHtmlAttributes gridEditColumn.2.fieldValue [User:userID] gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput 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 notSkipSqlOnImport on showGridView on showGridEdit on sqlOnUpdateFinishRecord addcreatestatement gridEditColumn.3.Visible gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.columnName ModuleID gridEditColumn.3.caption gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.Readonly gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue [indoogrid:moduleID] gridEditColumn.3.fieldFormat gridEditColumn.3.textBoxWidth gridEditColumn.3.allowUrlInput gridEditColumn.3.fieldValueAsInsert alternateTablename alternateConnectionString gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tablename Indoo_template_0101 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 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 <script> function Indoo_template_0101_f1_(iframe,text){ iframe.contentWindow.document.write(text) vid=text.substring(text.indexOf('http://www.youtube.com/v/')+25,text.indexOf('&')) imgv=iframe.parentNode.childNodes[1];imgv.src="http://img.youtube.com/vi/" + vid + "/default.jpg" if (vid==''){imgv.width='1px';imgv.height='1px'} } </script> startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createtable.addcreatestatement on altertable.addalterstatement on gridViewColumn.0.customHTMLForm <CENTER> <DIV><STRONG>[columnField:Title]</STRONG> <SCRIPT>var Indoo_template_0101_v1_[columnField:ID]='[columnField:YouTubeEmbededLink]'</SCRIPT> <DIV><IFRAME style="MARGIN-TOP: -100px; DISPLAY: none; MARGIN-LEFT: -120px; WIDTH: 425px; POSITION: absolute; HEIGHT: 355px" onmouseout="this.style.display ='none';" marginWidth=0 src="" frameBorder=0 scrolling=no onload=Indoo_template_0101_f1_(this,Indoo_template_0101_v1_[columnField:ID])> </IFRAME><IMG onmouseover="this.parentNode.childNodes[0].style.display='block';"> </DIV></DIV></CENTER> skipsqlonimport gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.columnName ID gridViewColumn.0.caption Video 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 gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.htmlAttributesname.1 gridViewColumn.0.htmlAttributesvalue.1 gridViewColumn.0.htmlAttributesname.2 gridViewColumn.0.htmlAttributesvalue.2 gridViewColumn.0.htmlAttributesname.3 gridViewColumn.0.htmlAttributesvalue.3 gridViewColumn.0.htmlAttributesname.4 gridViewColumn.0.htmlAttributesvalue.4 gridViewColumn.0.htmlAttributesname.5 gridViewColumn.0.htmlAttributesvalue.5 gridViewColumn.0.htmlAttributesname.6 gridViewColumn.0.htmlAttributesvalue.6 gridViewColumn.0.htmlAttributesname.7 gridViewColumn.0.htmlAttributesvalue.7 gridViewColumn.0.htmlAttributesname.8 gridViewColumn.0.htmlAttributesvalue.8 gridViewColumn.0.htmlAttributesname.9 gridViewColumn.0.htmlAttributesvalue.9 gridViewColumn.0.htmlAttributesname.10 gridViewColumn.0.htmlAttributesvalue.10 gridViewColumn.1.columnName Title gridViewColumn.1.Visible on gridViewColumn.1.allowExport gridViewColumn.1.allowEdit gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort gridViewColumn.1.allowImport gridEditColumn.0.columnName Title gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.2.columnName YouTubeEmbededLink gridViewColumn.2.Visible gridViewColumn.2.allowExport gridViewColumn.2.allowEdit gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort gridViewColumn.2.allowImport gridEditColumn.1.columnName YouTubeEmbededLink gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.3.columnName UserID gridViewColumn.3.Visible gridViewColumn.3.allowExport gridViewColumn.3.allowEdit gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort gridViewColumn.3.allowImport gridEditColumn.2.columnName UserID gridEditColumn.2.Visible gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption UserName gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption gridEditColumn.2.Readonly gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText Insert You tube embeded link (not url) gridEditColumn.1.multipageConditions gridEditColumn.1.isHtmlAttributes gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.isHtmlAttributes gridEditColumn.2.fieldValue [User:userID] gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput 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 notSkipSqlOnImport on showGridView on showGridEdit on sqlOnUpdateFinishRecord addcreatestatement gridEditColumn.3.Visible gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.columnName ModuleID gridEditColumn.3.caption gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.Readonly gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue [indoogrid:moduleID] gridEditColumn.3.fieldFormat gridEditColumn.3.textBoxWidth gridEditColumn.3.allowUrlInput gridEditColumn.3.fieldValueAsInsert alternateTablename alternateConnectionString