Skip to content

Instantly share code, notes, and snippets.

View mdnmdn's full-sized avatar

Marco mdnmdn

17 followers · 24 following
View GitHub Profile
@mdnmdn
mdnmdn / gist:2821211
Created May 28, 2012 21:03
Http Client for SqlServer CLR
using System;
using System.Data.SqlTypes;
public partial class NetClient
{
/*
ALTER DATABASE db-name SET TRUSTWORTHY ON
ALTER ASSEMBLY [assembly-name] WITH PERMISSION_SET = external_Access
@mdnmdn
mdnmdn / gist:4001758
Created November 2, 2012 14:42
ASP.NET: Get Windows identity from browser despite the auth mode
IServiceProvider service = (IServiceProvider)this.Context;
HttpWorkerRequest request = (HttpWorkerRequest)service.GetService(typeof(HttpWorkerRequest));
var identity = new System.Security.Principal.WindowsIdentity(request.GetUserToken());
@mdnmdn
mdnmdn / config notes
Last active November 14, 2018 21:53
Configure IISExpress on Win7 to listen on every interface (loopback and public)
1. authorize on http.sys: from cmd as admin:
netsh http add urlacl url=http://*:8080/ user=everyone listen=yes
2. open fw port/IISexpress
3. change applicationhost.config:
...
<binding protocol="http" bindingInformation="*:8080:" />
...
4. Run IISExpress
"c:\Program Files (x86)\IIS Express\iisexpress.exe" /config:applicationhost.config
@mdnmdn
mdnmdn / proto.autoresizable.body.js
Created December 14, 2012 16:19
// requires prototype.js
function setBodyFiller(resizableBody,footer){
var body = $(resizableBody);
var footer = $(footer);
if (!body) return;
function resizeMethod(){
@mdnmdn
mdnmdn / gist:4623396
Last active December 11, 2015 15:49
NSLog / initWithFormat / variadic method wrapper
- (void)log:(NSString *)text, ...
{
va_list args;
va_start(args, text);
id logText = [[NSString alloc] initWithFormat:text arguments:args];
va_end(args);
NSLog(@"%@",logText);
@mdnmdn
mdnmdn / SyncRequest.m
Last active December 11, 2015 17:18
URL Connection
-(void) syncRequest{
id urlString = @"http://www.google.com";
NSURL * url = [NSURL URLWithString:urlString];
NSURLRequest * request = [NSURLRequest requestWithURL:url];
NSURLResponse * response = nil;
NSError * error = nil;
NSLog(@"loading: %@",url);
NSData * responseData = [NSURLConnection sendSynchronousRequest:request returningResponse:&response error:&error ];
@mdnmdn
mdnmdn / oracle_linked_server
Created January 31, 2013 15:17
Oracle linked server for MSSql SERVER 2008 R2
EXEC master.dbo.sp_addlinkedserver
@server = N'LINKEDSERVERNAME', -- name of the linked server to create
@srvproduct=N'ORA9', -- descriptive
@provider=N'OraOLEDB.Oracle', -- Driver
@datasrc=N'DBTEST' -- TNS name
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LINKEDSERVERNAME' -- name of the linked server just created
,@useself=N'False',@locallogin=NULL,
@rmtuser='USERNAME', -- username
@mdnmdn
mdnmdn / xml_structure.sql
Created March 8, 2013 15:13
generate an xml representation of tables and columns
SELECT
t.TABLE_NAME AS '@name',
--sv.docID AS 'docID'
(SELECT
cols.COLUMN_NAME AS '@field',
case when exists(select 1 from INFORMATION_SCHEMA.KEY_COLUMN_USAGE ku
where ku.TABLE_NAME = t.TABLE_NAME
and ku.TABLE_SCHEMA = t.TABLE_SCHEMA
and ku.COLUMN_NAME = cols.COLUMN_NAME
@mdnmdn
mdnmdn / ReportingServicePage.aspx
Last active December 16, 2015 10:29
Reporting service report from asp.net
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportingServicePage.aspx.cs" Inherits="ReportingServicePage" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rs" %>
<html>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
@mdnmdn
mdnmdn / OledLogger.cs
Created May 12, 2013 14:42
Text Log on Gadgeteer Seeed Oled Display
using System;
using System.Collections;
using Microsoft.SPOT;
using Gadgeteer.Modules.Seeed;
using Gadgeteer;
// GHI.OSHW.Hardware // on OSHW
using GHI.Premium.System; // on Premium
namespace Common.Libs
{