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

Question

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. **

Amit Mohanty · 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 Tiwari · Answer

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 Mohanty · Answer

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?

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

Answers (3)