You should switch to stored procedures if possible. One thing I see is this 'ByteBuffer.ToString()', this is going to return System.Byte[] -- thats all I see from here, the problem is probably a datatype. Copy the myText to your clipboard during an execution and try to run that query exactly as it was copied into SQL Query Analyzer, or use SQL Profiler to see whats happening.

Empires

I have been looking for a site like this for a long time, great job!

Err or you could imagine the threat of impending doom if you lose your job and are unable to buy caffeine. :/

If it is motivation you seek, you need only to obtain a few gallons of caffeine. I could fuel my development for days with enough caffeine :)

You could also maintain the font and do it like this: if (e.KeyCode == Keys.B && e.Control) { richTextBox1.SelectionFont = new Font( richTextBox1.SelectionFont, richTextBox1.SelectionFont.Style ^ FontStyle.Bold ); e.Handled = true; }

Michael Francik Empireland, Inc.

You could use a CultureInfo instance for formatting as shown below: DateTime dt = DateTime.Parse("08/01/2006"); // Use the machines current culture. Console.WriteLine("Current Culture: {0}.", dt.ToString(CultureInfo.CurrentCulture)); // If you want to use another culture without switching your current culture you could try. Console.WriteLine("English (US) Formatted Date: {0}.", dt.ToString(new CultureInfo("en-US"))); Console.WriteLine("English (GB) Formatted Date: {0}.", dt.ToString(new CultureInfo("en-GB"))); // Output English (US) Formatted Date: 8/1/2006 12:00:00 AM. English (GB) Formatted Date: 01/08/2006 00:00:00.

you could use interop to use the user32 dll example here http://www.codeproject.com/vb/net/ActivateSingleAppInstance.asp

(In .NET) You are right about the <> Nothing part, but if the array has been initialized then this will not work. You could try If (Array.Length > 0 Then), this will tell you if anything is in the array if it has already been initialized.