dannylloyd

query user /server:computername

dannylloyd

using (var pck = new OfficeOpenXml.ExcelPackage())
{
  var ws = pck.Workbook.Worksheets.Add("Sheet1");
  ws.Cells.LoadFromCollection(mrns);
  pck.SaveAs(new FileInfo(@"C:\Temp\Output.xlsx"));
}

dannylloyd

	var path = @"C:\Temp\Path-To-File.xlsx";
	using (var pck = new OfficeOpenXml.ExcelPackage())
	{
		using (var stream = File.OpenRead(path))
		{
			pck.Load(stream);
		}
		var ws = pck.Workbook.Worksheets.First();

		for (int rowNum = 1; rowNum <= ws.Dimension.End.Row; rowNum++)

jchandra74

PowerShell GUID Generator

From time to time, I need to generate GUID to be used as Unique Id for whatever reason. When I have Visual Studio opened, I usually use the GUID tool that comes with it.

But sometimes I am developing in VS Code and opening Visual Studio just to get access to the GUID tool is a pain.

So why not add the functionality to PowerShell instead? You can have PowerShell available from inside VS Code Terminal. It's the perfect thing to add.

So how do we go about that?

dannylloyd

PING -A xxx.xxx.xxx.xxx 

dannylloyd

declare @TableName sysname;
set @TableName  = 'TABLENAME';
declare @Namespace varchar(50);
set @Namespace = 'NAMESPACE';
declare @prop varchar(8000);
DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)
PRINT 'using System; '
PRINT 'using NPoco; '
PRINT ''
PRINT 'namespace ' + @Namespace + ' {'

fushnisoft

# Using the beta version of WinSCP http://winscp.net/eng/download.php
# Call this script to upload a file via FTP with progress feedback
# e.g. 
# .\fileupload.ps1 -username "myusername" -password "mypassword" -localfile "C:\files\MyFile.exe" -remotefile "/public_html/files/MyFile.exe"
# NOTE: This script assumes the WinSCP binaries are in a sub directory to the script. You can probably pass that as a parameter to be more flexible.

param (
  [string]$username,
  [string]$password,
  [string]$localFile,

aroberts

#!/bin/bash

# usage: $0 source_dir [source_dir] ...
# where source_dir args are directories containing git repositories

red="\033[00;31m"
green="\033[00;32m"
yellow="\033[00;33m"
blue="\033[00;34m"
purple="\033[00;35m"

dannylloyd

            Context.Response.ContentType = "application/pdf; name=" & filename
            Context.Response.AddHeader("content-disposition", "inline; filename=" & filename)
            Context.Response.AddHeader("content-length", pdfBytes.Length.ToString())
            Context.Response.BinaryWrite(pdfBytes)
            Context.Response.End()

dannylloyd

var gridView = '#<%= gridViewId.ClientID%>';
var checkAll = '#checkBoxId';

$(checkAll).click(function (i, v) {
    $('input[type=checkbox]', gridView).prop('checked', this.checked);
});

var checkCount = $('input[type=checkbox]', gridView).length;
$('input[type=checkbox]', gridView).click(function (i, v) {
    $(checkAll).prop('checked', $('input:checked', gridView).length == checkCount);