The DBNull value is converted to a string, so you are actually trying to put the string returned by DBNull.ToString() (which is an empty string) into the field. Specify the data type for the parameter: cmd.Parameters.Add("@ItemPicture", SqlDbType.Image).Value = System.DBNull.Value; Experience is the sum of all the mistakes you have done.

No code... Just by running your query on the Enterprise Manager and on the Query Analizer apps. Maybe it's a version thing. Danny

Okay, so maybe my approach is wrong.. Situation: The user opened an image file, and I load it to a Bitmap, but I don't know if the image has some transparent regions. Now, regardless to the original user's image file's format, I want to save the image to disk, Image.Save (String, ImageFormat). So if the original image had some transparent regions, I would want to use an ImageFormat that has support for transparency (png/gif), and if there were no transparent regions, I would use Jpeg. Questions: Does this requirement make sense? How can I handle this kind of situation? Thanks, Danny

You're welcome. Luc Pattyn [Forum Guidelines] [My Articles] Sorry for any delays in replying, I currently don't always get e-mail notifications.

You may be able to authenticate to your isp's smtp server by passing it your user credentials. Alteratively, consider using the windows server SMTP service. "You're very clever, young man, very clever," said the old lady. "But it's turtles all the way down!"

Have you tried using a parameterized query? DateTime dt = DateTime.Parse("01/08/2006"); // be careful about the current culture here, may want to specify OledbCommand cmd = new OleDbCommand "DELETE FROM EventLog WHERE EL_TimeStamp < ?;", connection); cmd.Parameters.Add("@p1", OledbType.Date,dt); cmd.Execute();

DannyAdler wrote: So you're saying that it can't be done? No! I'm saying that the server wants a username and password before you can use it! DannyAdler wrote: So how are the SMTP based apps work? I think you better read up on SMTP before going any further with that app. Also, you might want to read up on why that server is asking you to authenticate before you use it. SMTP Reference[^] RFC2821: Simple Mail Transfer Protocol (Replacing the older SMTP standards)[^] EMail Spoofing[^] RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome