Default Values for Search Fields
In the “After table initialized” event for the table, add the following code. Note, this code is for a DateTime column and sets it to a BETWEEN search type for the current day.
Pre-Populate Fields on Add from Search
To pre-populate fields from extended search parameters when adding a new record, use the following code in the row_rendering event. If the field is a table lookup: If the field is a regular edit field:
Server Variables in ASP.Net Core
var username = Microsoft.AspNetCore.Http.HttpContextServerVariableExtensions.GetServerVariable(HttpContext, "eduPersonPrincipalName");if (!string.IsNullOrWhiteSpace(username))username = username.Split('@')[0];
Remove the Time from a DateTime column
DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
Select All Checkbox Jquery
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 »
Using Menu Builder with Designs
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 »
CCS Registry Keys
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
RadioButtonList placing text before radio button
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 »
Adding Excel Export to a Report or Grid
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.