rengber

Member since 07/25/2006

Location: New Zealand

57 snippets

7848 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 1070 posted 17 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 1567 posted 17 years ago by rengber

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

aspnet

0 939 posted 17 years ago by rengber

SQL Add a Constant Value to a RecordSet

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

0 873 posted 17 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 1045 posted 17 years ago by rengber

XML Xml Config Snippet For XMLSerializer Temporary Classes

1 873 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 1466 posted 17 years ago by rengber

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 1382 posted 17 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 6449 posted 17 years ago by rengber

SQL Using a BitMask in a Where Clause

0 852 posted 17 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 1027 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 1406 posted 17 years ago by rengber

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

0 1687 posted 17 years ago by rengber

SQL Search Stored Procedure Code for a String

0 917 posted 17 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 1120 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 1400 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...