How to get image from binary to my image control in ASP.NET using C#

Question

1.00/5 (2 votes)

See more:

C#

Byte[] bytes = null;
                string text = this.lblId.Text;
                string str18 = this.FileUploadFrontImageR.FileName;
                if (this.FileUploadFrontImageR.HasFile)
                {
                    string filename = FileUploadFrontImageR.PostedFile.FileName;
                    string str20 = text + str18;
                    string filePath = Path.GetFileName(filename);
                    Stream fs = FileUploadFrontImageR.PostedFile.InputStream;
                    BinaryReader br = new BinaryReader(fs);
                    bytes = br.ReadBytes((Int32)fs.Length);
                    ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
                    connection3 = new SqlConnection(this.strConnectionstring);
                    connection3.Open();
                    SqlCommand cmdddd = new SqlCommand("Update TBL_PRODUCTDETAILS Set Picfront = @Picfront where ID = '" + text + "' ", connection3);
                    cmdddd.Parameters.Add("@Picfront", SqlDbType.Binary).Value = bytes;
                    cmdddd.ExecuteNonQuery();
                }

What I have tried:

i have doing all things as per my knowledge but not getting the image in my image control

Posted 22-Mar-17 1:01am

Shahbaz435

Updated 22-Mar-17 1:47am

v2

Add a Solution

Comments

F-ES Sitecore 22-Mar-17 7:11am

There is nothing in your code that is trying to show the image.

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)

OriginalGriff · Accepted Answer · 2017-03-22T01:47:00

Solution 1

There is nothing in your code that has anything to do with images, and the data stored in SQL is just raw byte data. You can read the data from SQL in the usual way and convert it to an image:

C#

MemoryStream ms = new MemoryStream(bytes);
Image myImage = Image.FromStream(ms);

You can them use the Image in any way you deem necessary.

Posted 22-Mar-17 1:47am

OriginalGriff

Comments

Shahbaz435 22-Mar-17 7:49am

I had added this in my code but its getting me error

OriginalGriff 22-Mar-17 7:53am

And I'm supposed to know what error it gives you? Presumably, you did make the appropriate changes to make it work in your existing framework?

Shahbaz435 22-Mar-17 7:57am

Byte[] bytes = null;
string text2 = this.FileUploadFullR.FileName;
string str7 = this.Session["ProductIDA"].ToString();
this.Ade = this.Session["ProductIDA"].ToString();
if (this.FileUploadFullR.HasFile)
{
string filename = FileUploadFullR.PostedFile.FileName;
string str9 = str6 + str4;
string filePath = Path.GetFileName(filename);
Stream fs = FileUploadFullR.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
bytes = br.ReadBytes((Int32)fs.Length);
MemoryStream ms = new MemoryStream(bytes);
Image myImage = Image.FromStream(ms);
ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
connection = new SqlConnection(this.strConnectionstring);
connection.Open();
SqlCommand cmdddd = new SqlCommand("Update TBL_PRODUCTDETAILS Set Picfront = @Picfront where ID = '" + str6 + "' ", connection);
cmdddd.Parameters.Add("@Picfront", SqlDbType.Binary).Value = bytes;
cmdddd.ExecuteNonQuery();
}

Shahbaz435 22-Mar-17 7:57am

it gives me error on fromstream