Uploading And Retrieving Images From A SQL Database For Display In An .Net Datagrid
Jul 28, 2010
I'am Developing a commercial website using vs2005 and sql 2005,where my users will download and upload wallpapers and ringtones,so my issue is,i got the coding for uploading ,ut the problem is it is storing the files two times, the code i have used is in the following link,http://www.beansoftware.com/asp.net-tutorials/images-database.aspx
i am looking for some sample code in order to upload and/or retrieve images stored in a database.even the web is full of samples, i was not able to find one without using blobs as i would like to save only the directory of an image when it comes to the place of storing. the reason behind is that i do want to have my database small for some reason and therefore only want to save links to my images inside.
I have a picture that i would like to upload to a database. I am really new to this so i am not sure what to do. I have been using the following code below to upload and retrieve the picture, looks like its uploading ok, but i cant retrieve it. The code i am using comes from this site,
i am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
I am sorry to ask this general question. But I could not find any comments sharing about real world experience when it comes to uploading photos. I knows a little bit about uploading photos to SQL database. One is uploading the photos insidea folder and the link to the photos will be stored inside the imagemap (not sure about this datatype??) column and perhaps the other way is to store the photos inside the database itself. Which one is the common and best practice?Any links that I can refer to?
post the C# source code for uploading images to a database, and then showing it to the user?? I have tried now for 3 weeks with no luck... Maybe we should recommend to Microsoft to add a file upload html helper method to MVC 3?
i am creating a page that will display multiple images from the database. i can do it if i will only display one image, by using a page to be rendered as image. something like this...
using (SqlDataReader reader = comm.ExecuteReader()) { Byte[] images = new Byte[](); while (reader.Read()) { Response.BinaryWrite(images); } }
and in the aspx file i have: <asp:Image ID="imgPhoto" runat="server" ImageUrl="~/ShowImages/LoadImages.aspx" Height="100px" Width="100px" BorderWidth="1px" /> what i want to achieve is to display multiple images from the database without making a page to be rendered as image...
I want to create a product sale page. The sale page will have images of products generated from sql server database with their price and name. When a user clicks on a specific image, it should navigate to another page with more images and details of that particular product. I just dunno which control to use to display images on the sale page. Also the admin can add products with images, therfore when they add new product , that product should come the first on the sale page. I can acheive that just by writing a simple query , but i dont know what should i use to display images. I cant use image buttons coz the images can be more than 50 depends, nor i can use grid view for images. I am using asp.net and sql server 2008.
Here's my situation. I have a table called Inspections, and another table called Images. The Images table takes the ID of the Inspections table as a foreign key, so the Images tables contains multiple images with the same foreign key value.I'd like to be able to enter an integer of the ID number from the Inspections table and have it return all the records from the Images table with the foreign key that matches this ID, and then load them into a gridview. When I tried using the .ashx Handler approach that I found at this link
How to display images in crystal report from database am inserting address (image folder) of images into the database, not inserting images into the database...
i want to display the image either from a database or through file upload control but in case of database i had seen your article but what binary data i can store as you had in data column table and when i save a file somewhere through file upload but it is not displaying the image.
i have encountered a problem on how to load the database images to be display in the Image content in the web pages. I am currently using an Access database with a table "Images" and there are 4 columns in it. "ImageID", "ImageDescription","ImageofPicture","Description". Below is my code: Words highlighted in bold is where the problem occurs. No image is display in the Image box but theres a red cross at the top left. Image description is displaying fine in the textboxes
int MaxRows = 0; int inc = 0; int inc1 = 1; int inc2 = 2; int inc3 = 3; System.Data.OleDb.OleDbConnection cs; System.Data.OleDb.OleDbDataAdapter dta; DataSet ds1; byte[] photo_array; protected void Page_Load(object sender, EventArgs e) { cs = new System.Data.OleDb.OleDbConnection(); //tell the program where the database is located cs.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Users\Admin\Desktop\Website1\App_Data\Database.mdb"; ds1 = new DataSet(); string sql = "SELECT * From Images ORDER BY ImageDescription ASC"; dta = new System.Data.OleDb.OleDbDataAdapter(sql, cs); cs.Open(); dta.Fill(ds1, "Images"); Navigation(); //MaxRows equals to the total amount of records from the database MaxRows = ds1.Tables["Images"].Rows.Count; } private void Navigation() { //get the first records from the database DataRow dtaRow = ds1.Tables["Images"].Rows[inc]; //get column values in the row TextBox3.Text = dtaRow.ItemArray.GetValue(1).ToString(); TextBox7.Text = dtaRow.ItemArray.GetValue(3).ToString(); DataRow dtaRow1 = ds1.Tables["Images"].Rows[inc1]; TextBox4.Text = dtaRow1.ItemArray.GetValue(1).ToString(); TextBox2.Text = dtaRow1.ItemArray.GetValue(3).ToString(); DataRow dtaRow2 = ds1.Tables["Images"].Rows[inc2]; TextBox5.Text = dtaRow2.ItemArray.GetValue(1).ToString(); TextBox8.Text = dtaRow2.ItemArray.GetValue(3).ToString(); DataRow dtaRow3 = ds1.Tables["Images"].Rows[inc3]; TextBox6.Text = dtaRow3.ItemArray.GetValue(1).ToString(); TextBox9.Text = dtaRow3.ItemArray.GetValue(3).ToString(); //if 3rd column value is not null if (ds1.Tables[0].Rows[inc][2] != System.DBNull.Value) { Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox3.Text; } if (ds1.Tables[0].Rows[inc1][2] != System.DBNull.Value) { Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox4.Text; } if (ds1.Tables[0].Rows[inc2][2] != System.DBNull.Value) { Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox5.Text; } if (ds1.Tables[0].Rows[inc3][2] != System.DBNull.Value) { Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox6.Text; } } } Code for ImageHandler.ashx: using System; using System.Web; using System.Data.OleDb; public class ImageHandler : IHttpHandler { public void ProcessRequest (HttpContext context) { string qry = "SELECT ImageofPicture FROM Images WHERE ImageDescription = ?"; string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Users\Admin\Desktop\Website1\App_Data\Database.mdb"; using (OleDbConnection conn = new OleDbConnection(connect)) { if (context.Request.QueryString["id"] != null) { OleDbCommand cmd = new OleDbCommand(qry, conn); cmd.Parameters.AddWithValue("", context.Request.QueryString["id"]); conn.Open(); using (OleDbDataReader rdr = cmd.ExecuteReader()) { if (rdr.HasRows) { rdr.Read(); context.Response.ContentType = "image/jpeg"; context.Response.BinaryWrite((byte[])rdr["ImageofPicture"]); } } } } } public bool IsReusable { get { return false; }
I have two columns in database name of the image(varchar) and image(BLOB) and i have inserted images into database.now i need to display on grid-view control. am banging my head since one day by searching and i have used handler but no use.
If in one form upload image form we enter ID in textbox againts ID label and upload an image file using fileuploadcontrol when we click on upload button image save in DB and in next form view image when we enter ID in textbox againts label enter ID. Images show in GRIDVIEW having columns (ID,images) ...
I have an application that uses an Asynchronous HttpHandler for retrieving images from a fileshare It appears the performance of this is quite poor. I have two questions:1. Does it make sense to use an IHttpAsyncHandler for this or will an IHttpHandler work fine? I have four images on a page that need to be loaded this way and it seems that they all load sequentially instead of in parallel. Since we have some JavaScript in the body onload event, it doesn't get excuted until all four images are finished loadingy bearing on this.