How can i Get image or pdf in byte array in database

Ishika Tiwari

I have saved data as a byte array in my database, but when retrieving it, the byte array is incorrect. The column in the database is of type LONG BLOB.

** please dont copy paste from the ChatGPT solution. **

3 Replies

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

Amit Mohanty2y ago

Accepted answer

Check this:

public byte[] GetByteArrayFromDataRow(DataRow dataRow, string columnName)
{
    if (dataRow.Table.Columns.Contains(columnName))
    {
        var base64String = dataRow.Field(columnName);
        return !string.IsNullOrEmpty(base64String) ? Convert.FromBase64String(base64String) : new byte[0];
    }
    return new byte[0];
}

Ishika Tiwari2y ago

In obj. TINCopies, I am storing a byte array of a PDF. I convert it to base64 to save in the database.

Now I am facing a problem retrieving this byte array.

 TINCopies = GetByteArrayFromDataRow(DataRow, "TINCopies"),

 public byte[] GetByteArrayFromDataRow(DataRow dataRow, string columnName)
        {
            if (dataRow.Table.Columns.Contains(columnName))
            {
                return dataRow.Field(columnName) ?? new byte[0];
            }
            return new byte[0]; 
        }

Thanks for your response !

Amit Mohanty2y ago
Hey Ishika, you please provide the code to save an image or PDF file to a database so that we can better understand the issue?