binary data in SQL

Give us some details about your database method. You can add .doc files to blob fields, and your blob fields can be retrieved using scalars or datareaders. To use a datareader, just use the GETBYTES method to read the blob field. I've never done INSERT without a stored procedure. I think you could just use a byte[], fill it with data, cast it as System.Object, and set the data in an INSERT Command. //reading blobs: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconobtainingblobvaluesfromdatabase.asp //writing blobs: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconwritingblobvaluestodatabase.asp

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

spgilmore22y ago
Give us some details about your database method. You can add .doc files to blob fields, and your blob fields can be retrieved using scalars or datareaders. To use a datareader, just use the GETBYTES method to read the blob field. I've never done INSERT without a stored procedure. I think you could just use a byte[], fill it with data, cast it as System.Object, and set the data in an INSERT Command. //reading blobs: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconobtainingblobvaluesfromdatabase.asp //writing blobs: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconwritingblobvaluestodatabase.asp