Run CMD Shell with TSQL
Note: By default XP_CMDSHELL is turned off, to enable XP_CMDSHELL run the following on the database server…
Author
Visual Studio All Packages Yellow Triangle Warning
Issues: All Packages show the Yellow Warning icon. Fix: Got to Package Manager Settings and click on "Clear All NuGet Cache(s)" Go to Package Manager Console… Sources: http://pratikvasani.github.io/archive/2016/02/24/Nuget-package-reference-issues/ https://stackoverflow.com/questions/46833402/what-do-yellow-warning-triangles-mean-on-dependencies-in-visual-studio-2017
Custom Grid Command Button
Example Icons https://blazor.syncfusion.com/documentation/appearance/icons/
SSRS and Large Datasets
Note: Do not attempt to select more than 1 million rows into the resulting Excel Spreadsheet or the data selection process may run out of memory. Large reports present certain processing challenges and require certain configurations if they are to run properly. Large reports should not be run on demand unless they are configured to... » read more
Setup Receipt Printing with Neodynamic JSPrintManager
Download and install JSPrintManager (JSPM) App from Neodynamic. JSPrintManager (JSPM) App is the client-side part of JSPrintManager Solution. It can be installed on any number of client machines without paying any fees. https://www.neodynamic.com/downloads/jspm/
How to print raw ESC/POS commands from Javascript
Sources: https://www.neodynamic.com/articles/How-to-print-raw-ESC-POS-commands-from-Javascript/ https://www.neodynamic.com/products/printing/js-print-manager/download/
NeoDynamic JSPrintManager
JSPrintManager (JSPM) App is the client-side part of JSPrintManager Solution. It can be installed on any number of client machines without paying any fees. Download JSPM and read System Requirements for each available platform: https://jsprintmanager.azurewebsites.net/ https://www.neodynamic.com/downloads/jspm/ Windows Authenticode Certificate The installer package is digitally-signed with a Windows Authenticode Certificate issued by DigiCert, Inc. Install the package only if the Publisher is Neodynamic; otherwise contact us.... » read more
Using Receipt Printer on Remote Desktop Service by disabling Terminal Services Easy Print
Issue: Unable to use receipt printer on remote desktop service. Fix: Disabling Terminal Services Easy Print with the following group policy option will avoid this limitation: Computer Configuration\Administrative Templates\Windows Components\Remote Desktop Services\Remote Desktop Session Host\Printer Redirection\Use Terminal Services Easy Print printer driver first Set “Use Retmote Desktop Easy Print printer driver first” to “Disabled”. Sources:... » read more
Execute Dynamic SQL with sp_executesql
Sources: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver15
Raw/Text Commands for Receipt Printer
Example: Test: https://webclientprint.azurewebsites.net/DemoPrintCommands.aspx https://jsprintmanager.azurewebsites.net/ Raw POS Command