Bitmap Image is not showing in iageView android?

Question

0.00/5 (No votes)

See more:

The Image is stored in Microsoft SQL Server and I am easily able to retrieve it andriod as string but can't display it in imageVuew
The Image String Which I get is 0x433A5C55736572735C4D616E736F6F725C50696374757265732E436170747572652E4A5047

Java

//This is the image string I get from db and it dispalys fine in text view
imageString= resultString.getProperty(7).toString();
//This is how I try to show it in imageview
ImageView iv= (ImageView) findViewById(R.id.ivProfilePic);
byte[] imgBytes = Base64.decode(imagestring, Base64.DEFAULT);
                final Bitmap bitmap = BitmapFactory.decodeByteArray(imgBytes, 0, imgBytes.length);
                iv.setImageBitmap(bitmap);

Posted 16-Dec-15 19:23pm

Member 10528646

Updated 17-Dec-15 3:21am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ridoy · Answer 1 · 2015-12-17T05:08:00

Need to see your image insertion code. While creating table do you code like:

SQL

CREATE TABLE [dbo].[ImgTbl2](
    ..........
    [ImgName] [nvarchar](50) NULL,
    [Img] [nvarchar](max) NULL
)

And then before insert your image:

C#

ByteArrayOutputStream stream = new ByteArrayOutputStream();
originBitmap.compress(Bitmap.CompressFormat.PNG, 100, stream);
byteArray = stream.toByteArray();
encodedImage = Base64.encodeToString(byteArray, Base64.DEFAULT);

While inserting:

C#

String commands = "Insert into ImgTbl2 (ImgName,Img) values ('"
                    + imageName.getText().toString() + "','" + encodedImage
                    + "')";

If all of them are correct, you code will work good.
More:
Android Storing Images in MS SQL Server[^]
How to store/retrieve image to/from SQLServer[^]