Exception while converting varbinary to binary array

Question

I have a SQL Server table whose Rawcontent is of type varbinary FileStream

TABLE [dbo].[DocTable]
(
    VersionId [uniqueidentifier] NOT NULL,
    RawContent [varbinary](max) FILESTREAM  NULL,

Now when I am trying to get the fileStream data using :

foreach (DataRow dtr in dataTable.Rows)
{
    docStream = (byte[])dtr["RawContent"];
}

Getting an exception, can not convert from System.String to System.Byte.

Why I am getting a string back while the content is saved as FileStream on SQL Server?

Jeffrey Easley · Accepted Answer · 2015-04-14 14:51:03Z

1

if you have docstream declared as a byte array, you need to use a FileStream object first, and then convert that into a byte array

answered Apr 14, 2015 at 14:51

Jeffrey Easley

3162 gold badges6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1