rengber

Member since 07/25/2006

Location: New Zealand

57 snippets

6417 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# Adding another item to a databound drop-down list.

Stupidly simple, but I keep forgetting it.

simple

0 945 posted 16 years ago by rengber

C# ASP.Net Code to Get an Active Directory User Name from the Integrated Authentication Principal Name

Typically won't work if the ASP.Net service identity (in the machine.config ProcessModel section) is a local account.

1 1381 posted 16 years ago by rengber

C# Declarative Code for ASP.Net Repeater to Access CodeBehind Method.

aspnet

0 799 posted 16 years ago by rengber

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

0 760 posted 16 years ago by rengber

XML Xml Config Entry to Write out Temporary Assemblies Created for the Serializers

This persists the dynamic classes generate by the .net serialize to disk at location C:\Documents and Settings\A063913\ASPNET\Local Settings\Temp Note. This will allow you to debug into the serialized classes from VS2005

1 917 posted 16 years ago by rengber

XML Xml Config Snippet For XMLSerializer Temporary Classes

1 754 posted 17 years ago by rengber

SQL TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

This is as small as this can go: 'xs:dateTime(sql:variable("@stringDate"))' It needs to be a literal string for the Value() function. Xml Datatype http://msdn2.microsoft.com/en-us/library/ms189887.aspx Sql:Variable() Function http://ms...

0 1321 posted 17 years ago by rengber

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 1238 posted 17 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 6220 posted 17 years ago by rengber

SQL Using a BitMask in a Where Clause

0 729 posted 17 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 899 posted 17 years ago by rengber

Regular Expression Regular Expression to Grab the Content of an XML Element

If there will be multiple sets of these tags in a scanned XML string, you need the '?' after the '*' to specify a non-greedy (lazy) match.

4 1262 posted 17 years ago by rengber

C# Serializing and Deserializing a Class Created with XSD.Exe Using XML Strings

0 1507 posted 17 years ago by rengber

SQL Search Stored Procedure Code for a String

0 826 posted 17 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 986 posted 17 years ago by rengber

C# Get XML String Out of an Instance of a Class Generated from an XSD File by XSD.exe

0 1225 posted 17 years ago by rengber

C# Adding Parameters to a Command Object Using Relection Over Matching Class Properties

You could eliminate the ListDictionary if you created a simple method to map C# types to DbTypes. Although this method also lets you skip over some object properties my using the ListDictionary to contain a subset of properties. It could also be us...