Xamrin android form upload images to sql server

umesh maurya 1

any idea is to implement that.

Leon Lu (Shanghai Wicresoft Co,.Ltd.) 68,661 Reputation points Microsoft Vendor

2022-02-07T09:11:24.317+00:00

Based on my research, uploading images to SQL server directly is not a good way. If you Images size is over 1M, store it to FILESTREAM (SQL Server). If your pictures are typically below 256KB in size, storing them in a database VARBINARY column is more efficient. You need to read the image to Stream, then convert stream to byte array, save byte array to VARBINARY column

Please see To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem
umesh maurya 1 Reputation point

2022-02-07T13:52:28.827+00:00

Actually, I had tried it but there is an error of (ImageFormat, I had also installed package of System. Imaging.
Leon Lu (Shanghai Wicresoft Co,.Ltd.) 68,661 Reputation points Microsoft Vendor

2022-02-08T06:37:37.227+00:00
I had tried it but there is an error of (ImageFormat, I had also installed package of System. Imaging.

You can not read the image to byte[], am I right? If so, you can use following ways.

private byte[] GetImageStreamAsBytes(Stream input) { var buffer = new byte[16 * 1024]; using (MemoryStream ms = new MemoryStream()) { int read; while ((read = input.Read(buffer, 0, buffer.Length)) > 0) { ms.Write(buffer, 0, read); } return ms.ToArray(); } }

If you still cannot save it successfully, You can convert your Image to Base64 string, save Base64 string to sql server, when you need to show this image, convert Base64 string to Image.

1 answer