Inserting and retrieving images from Database

[Ainsley]

Can you help me to load and insert the images into database through programming in ASP.NET and I am using SQLServer as a backend.
I have a problem while loading and retrieving an image from database.
I have loaded an image in the database as of type Image. I have retrieved the data from database and passed to stream. How can I load this to a picture box or to a report viewer?

[MindSpace]

Before inserting the image into database,we will go through steps-

PersonImage, an object and one of the HTMLInputFile control. Before doing anything we need to get the size of that particular image that we are going to insert using -

intImageSize = PersonImage.PostedFile.ContentLength

Now,we will ready to retrieve image but before that the most important thing is that we need to get the Image Stream using-

ImageStream = PersonImage.PostedFile.InputStream
we are having an array of bytes ,imagecontent that will hold the image content and it would be done using the method Read(),it takes 3 parameters-

Target Location,Starting position,Number of bytes that requires to read.

intStatus = ImageStream.Read(ImageContent, 0, intImageSize)

After all of reading and getting the image from client side,and now you need to insert this image into a sql table.Create a stored procedure and insert easily this image into table.

[Modifier]

If you want to retrieve the data from database and you are using front end as a C# and back end as a SQLServer .Absolutely,You can do this and I don't think any problem should be occur.

private void button2_Click(object sender, EventArgs e)

{
const string conString = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;";

const string firequery = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000";


using (SqlConnection sqlconn = new SqlConnection(conString))

{

sqlconn.Open();
using (SqlCommand comnd = new SqlCommand(firequery, sqlconn))

{

using (SqlDataReader rdr = comnd.ExecuteReader())

{

using (DataTable tbdata = new DataTable())

{

tbdata.Load(rdr);
File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);

}

}

}

}

}

[Praetor]

An easily way to access the data from database,but its very primary and it's like introduction for you how would we get access to images from database.

In your database,your images are stored in form of bytes and if you need to access them, you have to use fromstream method to covert it again into image.

1. System.IO.MemoryStream memstream = new
System.IO.MemoryStream(byte array of the image);

and you would convert it into image to show on the screen

2. System.Drawing.Image img =
System.Drawing.Image.FromStream(memstream);