rengber

Member since 07/25/2006

Location: New Zealand

57 snippets

6630 profile views

2 Comment(s) Posted

their Tags

Oracle Net url event sql forms windows script security command xml database aspnet simple data filter web excel image c php html style design math extension query array c#

Profile

Achievement

You have not received any achievements.

rengber's Recent Snippets

All /

« Prev 1 2 Next »

C# Array ConvertAll with Lambda

Lambda expression to convert an array.

array
c#

0 1228 posted 12 years ago by rengber

C# Minimalist WCF Client-side Config File

Again, A-B-C. All the Behaviour garbage that "Add Service Reference" inserts for the TCP binding is unnecessary, especially if the Operation Contract is only for simple value types.

0 944 posted 12 years ago by rengber

C# Minimalist WCF Server-side Config File

ABC - Address Binding Contract Note that the Service Name and Contract must match a real live type (case Sensitive) Binding name is also case sensitive.

0 944 posted 12 years ago by rengber

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

1 992 posted 15 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 901 posted 15 years ago by rengber

C# Dump an Arbitrary Object to XML (Bypassing Default Serialization)

Useful in cases where the object author has specified their own serialization that doesn't work for you.

1 1005 posted 15 years ago by rengber

C# DataBinding an Arbitrary XML String to an ASP.Net GridViev

Definitely falls into the category of "simple thing I shoulda memorized years ago", but whatever:

0 806 posted 15 years ago by rengber

SQL SQL Server String Split Function

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

0 879 posted 15 years ago by rengber

C# Minimalist XSLT Transform Using Two Strings

0 1208 posted 15 years ago by rengber

C# DataGridView DataBind an Array of Arbitrary Objects

Stupidly simple -- just one pitfall: class to be bound must have Get/Set methods for reflection to discover. Which is annoying when it comes to client side classes auto generated from WSDL.

0 936 posted 15 years ago by rengber

C# Copy All Object Values from Another Instance of the Same Type Using Reflection

Say that you have a collection of objects empty but for IDs. You want to do a foreach loop through those objects and lookup detail one at a time. Unfortunately, in the foreach, you can't replace the references, you can only copy the new detail...

c
extension

1 1115 posted 15 years ago by rengber

C# C# Call a Constructor Overload from the Default Constructor

This is stupidly simple, but I always forget it.

c
simple

1 938 posted 15 years ago by rengber

SQL TSQL Try Catch Error Handling

This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.

database

0 879 posted 15 years ago by rengber

SQL TSQL to Start a Job Programatically

database

0 806 posted 15 years ago by rengber

SQL Basic TSQL Cursor Syntax

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

database

0 954 posted 15 years ago by rengber

C# Extracting an Int from a Little Endian or Big Endian Byte Array

Found this in some code I've been maintaining/expanding. Quite clever. Picture an array of bytes in binary 00000111 11100000 00000000 00000000 Now picture an Int32 in Binary 00000000000000000000000000000000 To grab a Little Endian I...