Writing C# Functions for SQL Server and CLR Integration

September 15, 2009
Tags: , ,

An interested problem was presented to me today where a database table in SQL Server 2005 (now moved to 2008) had a trigger attached to a table that would encrypt a credit card number on insert or update. The encryption routine used the sp_OACreate stored procedure to make use of an older Microsoft cryptography library [...]

0

Consuming Web Services in .NET 3.5 – Web References

February 10, 2009
Tags: ,

I have to admit I feel a little bit behind the curve. I’ve not goofed too much with the .NET 3.5 specific stuff much lately, and much of my experience has been in .NET 2.0. But today I packed up the laptop and headed to Starbucks to get out of the office so I could [...]

2

New Article: Encoding files as base64 strings

May 8, 2008

Check out my new article on encoding files as base64 strings. Useful for sending binary data across the wire where sending such binary data may be difficult. Especially useful for webservices and sending files.

0

Tutorial: .NET XML Into A DataSet

April 8, 2008

New tutorial for C# about using XML data in a DataSet object for manipulating the data like it came from a database. See the Software Development section, or go straight to it here. Cheers, and happy coding!

0

Beep on the Enter Key

August 22, 2007
Tags: ,

One of the applications that I wrote and maintain here for use at my job is a C# Windows application. A couple of revisions ago I set it up so that the user could press the Enter key to submit the login instead of having to click the actual login button. For the longest time [...]

0