| Author: Vidhya 30 Jul 2008 | Member Level: Gold | Rating:  Points: 1 |
hi,
if (objFileUpload.PostedFile !=null)
{
if (objFileUpload.PostedFile.ContentLength > 0)
{
// Get Posted File.
HttpPostedFile objHttpPostedFile = objFileUpload.PostedFile;
// Check valid Image type. Create this function according to your need
if (CheckValidFileType(objHttpPostedFile.FileName))
{
// Find its length and convert it to byte array
int intContentlength = objHttpPostedFile.ContentLength;
// Create Byte Array
Byte[] bytImage =new Byte[intContentlength];
// Read Uploaded file in Byte Array
objHttpPostedFile.InputStream.Read(bytImage, 0,
intContentlength);
}
}
}
Fig - (1) Read Uploaded file (here Image) in Byte Array
Pass this Byte array to you DAL and use it for storing image in database. I am using Enterprise Library as DAL so my code will look like,
Database db =DatabaseFactory.CreateDatabase();
string sqlCommand =“StoredProcedureName”;
DbCommand dbCommandWrapper = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommandWrapper,“@Image”,DbType.Binary,
bytImage );
try
{
db.ExecuteNonQuery(dbCommandWrapper);
}
catch {throw; }
Fig - (2) Insert Image in to database
This is how you can store the Image in database. Retrieving the image is the same process. Write a SP which will return your image. Store this value in a Byte Array. Once you get the image in Byte array, you just have to write it on form as shown below,
Byte[] bytImage =Byte array retrieved from database.
if (bytImage !=null)
{
Response.ContentType =“image/jpeg”;
Response.Expires = 0; Response.Buffer =true;
Response.Clear();
Response.BinaryWrite(bytImage);
Response.End();
}
Fig - (3) Code to display Byte array as Image on form.
To use this at multiple places in your application, you create a page to which you can pass ID of Image and it will retrieve image from database and create image. To do this copy paste above code in aspx.cs file. Now on every page you require to show this image take <asp:Image> on that page and set its ImageURL property to the path of newly created user control. See the code below,
<asp:Image ID=”ViewImage” runat=”server” />
Fig - (4) Image control on any aspx page (Lets say Sample.aspx).
string strURL =“~/ViewImage.aspx?ID= 1 “ ;
ViewImage.ImageUrl = strURL;
Fig - (5) Set Image URL for image control on code behind (Sample.aspx.cs)
You can see the image will be displayed in your page where you had put Image tag.
Happy Programing!
plz rate this content
|