image datatype

[TAREQ F ABUZUHRI]

i create new table and have feild from type image and allow null in my program i want to ck if this field is fill or empity ?? i use c# ,,,

Palestine

[T EDY]

i try this in my code and its working fine, ex : byte[] img = (searchContact["Photo"] == DBNull.Value) ? null : (byte[])searchContact["Photo"]; searchContact is my SqlDataReader, Hope this can solve u'r problems

Best Regards, Tomi

[Pete OHanlon]

I've used variants of the following public static T GetData<T>(IDataReader rdr, string column) { if (string.IsNullOrEmpty(column)) throw new ArgumentNullException("column"); if (rdr == null) throw new ArgumentNullException("rdr"); int pos = rdr.GetOrdinal(column); T returnValue = (rdr[pos] == DBNull.Value) ? default(T) : (T)rdr[pos]; return returnValue; } byte[]img = GetData<byte[]>(reader, "Photo"); string contact = GetData<string>(reader, "Contact"); My apologies if the syntax isn't 100% exact, but I'm typing this out from memory.

Deja View - the feeling that you've seen this post before.