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

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

SyncXpress Update

April 3, 2007

Ladies and Gentlemen! I have put up for public download the first alpha release of SyncXpress. It is still in VERY early production, and not ready for prime time, so use at your own risk. You will need .NET 2.0 to run this application. I also hope to have a forum up soon for feedback [...]

0

Images in SQL

February 9, 2007
Tags: , ,

So I was presented with a task today of extracting images that were stored in a Microsoft SQL Server 2000 database and save them as JPEG files. Here is a bit of code that will do this. In this code sample I am assuming domain authenticated SQL login. The table name here will be called [...]

0

Logical Drives and WMI

February 1, 2007
Tags: ,

In an effort to support removable media devices in SyncXpress I’ve had to do a bit of learning about WMI in .NET. It is actually quite cool how much information you can get from WMI about ANY piece of hardware attached to your system, and even INSIDE your system. So in my case I want [...]

0

SyncXpress

January 31, 2007

Long under development, and not due to complexity, has my program SyncXpress been. I am happy to state that it is nearly done with the first beta. I’ve got most all the interface elements built. Package management is working, allowing you to create, modify, and delete packages and their respective targets. I finished writing and [...]

0