Accessing image store in sql server “image” data type from android studio in imageview

Question

0.00/5 (No votes)

See more:

I am very new to android studio , i want to show the images from SQL server "image" data type in android studio. My web site is already running in production and which is working fine in asp.net hence it is not feasible to convert the images in other data type as it will require large testing . Pls help.

What I have tried:

I have checked on net , but not found any post on this.

Posted 6-Mar-16 18:16pm

Member 4772857

Updated 7-Mar-16 5:04am

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)

Kashif-Sohail · Answer 1 · 2016-03-07T05:04:00

Images are sent in the form of bytes array. you can access them by using a RestFUll api from sql server to your android application.
image will be retrieved in json and then converted to image from bytes array.

C#

JSONArray jsonArray = new JSONArray(jsonString);
for (int i = 0; i < jsonArray.length(); i++) {
    JSONObject jsonObject = (JSONObject) jsonArray.get(i);


    byte[] byteArray =  Base64.decode(jsonObject.getString("image"), Base64.DEFAULT) ;
    Bitmap bmp1 = BitmapFactory.decodeByteArray(byteArray, 0, byteArray.length);

   
}

bmp1 is the image, you can use it according to your needs