DymoAddInClass – Set Label Template

Setting Label Template for Dymo printers. using Dymo; private DymoAddInClass _dymoAddin = new DymoAddInClass(); dymoAddin.OpenURL("https://account01.blob.core.windows.net/label01.label") dymoAddin.Open(System.IO.Path.Combine(System.IO.Directory.GetCurrentDirectory(), @"C:\Label01.label")); labelFileNamelbl.Text = _dymoAddin.FileName; Sources: http://developers.dymo.com/tag/dls-sdk/

How to save CSV file as UTF-8 with Notepad

The steps are as given below: Open the CSV file with Notepad. Navigate to File > Save As option. A screenshot of the menu is as shown below:Notepad File Menu Next, select the location to the file. The Save As window appears as shown below:Save As option in Notepad Select the Save as type option as All Files(*.*). Specify the file name with .csv extension. From Encoding drop-down list, select UTF-8 option.... » read more

Convert DataTable to CSV Download

private void WriteDelimitedData(DataTable dt, string fileName, string delimiter) { //prepare the output stream Response.Clear(); Response.ContentType = "text/csv"; Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}", fileName)); Response.ContentEncoding = System.Text.Encoding.UTF8; //write the csv column headers for (int i = 0; i < dt.Columns.Count; i++) { Response.Write(dt.Columns[i].ColumnName); Response.Write((i < dt.Columns.Count - 1) ? delimiter : Environment.NewLine); } //write the data foreach (DataRow... » read more

VisualSVN Server

VisualSVN Server allows you to easily install and manage a fully-functional Subversion server on the Windows platform. Thanks to its robustness, unbeatable usability and unique enterprise-grade features, VisualSVN Server is useful both for small business and corporate users. https://www.visualsvn.com/server/


ALLOW_PAGE_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether page locks are allowed. The default is ON. ONPage locks are allowed when accessing the index. The Database Engine determines when page locks are used. OFFPage locks are not used.


ALLOW_ROW_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether row locks are allowed. The default is ON. ONRow locks are allowed when accessing the index. The Database Engine determines when row locks are used. OFFRow locks are not used.


IGNORE_DUP_KEY = { ON | OFF }Specifies the response type when an insert operation attempts to insert duplicate key values into a unique index. The IGNORE_DUP_KEY option applies only to insert operations after the index is created or rebuilt. The option has no effect when executing CREATE INDEX, ALTER INDEX, or UPDATE. The default is OFF. ONA warning message occurs when duplicate... » read more


STATISTICS_NORECOMPUTE = { ON | OFF }Specifies whether statistics are recomputed. The default is OFF. ONOut-of-date statistics are not automatically recomputed. OFFAutomatic statistics updating are enabled. The general recommendation to leave auto-update stats turned on (STATISTICS_NORECOMPUTE = OFF, which is the default) is for safety reasons, because if this is turned off and nothing is manually updating the stats,... » read more


From MSDN: PAD_INDEX = { ON | OFF } Specifies index padding. The default is OFF. ON: The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index. OFF or fillfactor is not specified: The intermediate-level pages are filled to near capacity, leaving sufficient space for at least... » read more