Skip to content

Instantly share code, notes, and snippets.

@bungard
bungard / ldap_bind.rb
Last active August 29, 2015 14:11
LDAP Bind/Authenticate
require 'ldap'
LDAP_S ={
:use_ssl => true,
:ldap_host => "domain.com",
:domain => "domain.com",
:start_tls => false,
:ldap_version => 3
}
SELECT model
FROM
(SELECT model, price FROM PC)
UNION
(SELECT model, price FROM Laptop)
UNION
(SELECT model, price FROM PC) model_price
WHERE
price >= ALL (SELECT price FROM model_price);
@bungard
bungard / gist:de321995a418bbd0f479
Last active August 29, 2015 14:04
C# to fill PDF form from a Given DataTable
/*
This is utilizing iTextSharp for the PdfReader, PdfStamper and AcroFields classes.
*/
DataTable dt = new DataTable();/* fill the DT however you please */
String pdfTemplate = "PATH_TO_PDF_FORM";
System.IO.MemoryStream m = new System.IO.MemoryStream();
PdfReader pdfReader = new PdfReader(pdfTemplate);
PdfStamper pdfStamper = new PdfStamper(pdfReader, m);