Remove the Time from a DateTime column
DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
This jQuery script will allow a select all checkbox in the header to toggle the check boxes in an editable grid. Rename NotifySelectAll to the toggle checkbox id and NotifyChk to the id of the check boxes in the grid. Note: the jQuery select is looking for ID’s that end with specified id. So if there
Read More »
I like using table (Data Source) generated menus in my CCS apps but they don’t work when using Artisteer designs. So I’ve come up with a workaround so the CCS menu builder control will display properly with Artisteer designs. I’m using the ASP.Net VB InMotion templates and don’t know if it will work with any other templates. Also, my
Read More »
Sometimes after a CCS5 upgrade the app will have bugs or crash. Yes recommends uninstalling the CCS, deleting the following registry entries, and reinstalling the app. Be sure to turn off UAC, Windows Defender and are logged in as an Administrator. HKEY_CURRENT_USER\Software\YesSoftware\CodeChargeStudio5HKEY_LOCAL_MACHINE\SOFTWARE\YesSoftware\CodeChargeStudio5 In Windows 8 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\YesSoftware\CodeChargeStudio5
When creating a master page with Artisteer 4.2.0.60483 (Beta) for CCS 5.1 Release Preview, the radio button text is appearing before the radio button instead of after. CCS support said to add float: left; to .art-radiobutton>input[type=”radio”]. So I added the following to the CSS Export options: .art-radiobutton>input[type="radio"]{ float: left; vertical-align: baseline; margin: 0 5px 0 0;} The same thing can
Read More »
Add NPOI.dll and NPOIHelper.dll to the bin folder of the website. In the After Execute Select event of the report or grid add the following code: If Request.QueryString("Export") = "Excel" Then Dim SS As New NPOIHelper.Spreadsheet() SS.AddSheet(DirectCast(e.OperationResult,System.Data.DataView)) SS.WebDownload(Response, "DownloadFilename") End If Add an Export to Excel link to the page with an Expression parameter of Export=Excel.
Create the User Control in Visual Studio. In my example it was a simple DropDownList that had AutoPostBack set to True and redirected to another page on postback with a value from the grid. Register the control on the HTML page just after the Begin Panel Head. <%@ register tagprefix=”uc1″ tagname=”MyUserControl” src=”/dnn/Portals/9/my_user_control.ascx” %> Add the
Read More »
This is a work around to setting the FileFolder property on the FileUpload component at runtime. It is specific to .Net InMotion and was done in CCS5. I wanted to set the FileFolder property at runtime from an AppSettings value. The problem was setting it in the BeforeShow event of the control was too late
Read More »
Craig, Not sure if you already got this, but be careful of the menu builder. Below if how I got it done after contacting support. Underlying tone was I needed to read the directions better because this was in the directions and a departure from previous CCS technique…. You need to make an includable page
Read More »
Per Yes Software support… To retrieve the value of a recordset field, or a field that is part of the datasource query but not assigned to a control in your grid or record. Grid BeforeShowRow:DirectCast(sender, InMotion.Web.Controls.Grid).DataItem("event_id").ToString() Record BeforeShow:DirectCast(sender,InMotion.Web.Controls.Record).DataItem("event_id").ToString() Grid, Record AfterExecuteSelect:DirectCast(e.OperationResult,System.Data.DataView).Table.Rows(0)("event_id").ToString()