I have saved an image on the database and want to display it to the user.
The table the image is stored in looks like this:
Images
------
ImageData Byte
ImageName String
ContentType String
What should I do to load and show it in my View?
I have a script for infinie paging data where one of the items i return is an image, not text. Right now I am returning as text. return as the html or asp image? The line I need to fix and can use the logic for other is ==$(".msgpic", table).html(customer.find("MsgPicture").text()); == See code...
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
var pageIndex = 1;
var pageCount;
[Code].....
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;
}
Have a look at below link. In that page if you mouse over on any thumbnail image a div opens with that image details with larger size. But there is a point to notice usually when an image gets downloaded in the browser we see that the image loads in parts from top to bottom. In this case the whole is loaded but in blurred state and gets cleared after fully downloaded.
Sample
Link
I just wanted to know how this is achived? Does it require to code something or it is any javascript or dhtml?
using vb.net/asp.net 2005
I've been tasked with creating a page where the user can do the following in this order:
1. browse to and select a jpg image
2. preview the image that the user just selected
3. if the user is happy with the preview then click the GO button to load the image to the Image folder.Does anyone have any good examples or sample code of how to do this?
image control doesn't seem to load image? Path name is set in db to a picture on my desktop.
OdbcCommand cmd = new OdbcCommand("SELECT User.FirstName, User.SecondName, User.Aboutme, User.DOB, Pictures.picturepath FROM User LEFT JOIN Pictures ON User.UserID = Pictures.UserID WHERE User.UserID=1", cn);
OdbcDataReader reader = cmd.ExecuteReader();
[Code].....
i have used filestream of sql server 2008 for storing images. i want to retrive that image and bind to image control.but not getting the correct path.
View 2 RepliesI have div In my page that in this div I put image control
<div id="DLogos">
<asp:Image ID="imglogo" runat="server" CssClass="ILogos" /> </div>
according to below code
<div id="Dart1_I1" visible='<%# !string.IsNullOrEmpty(Eval("image1").ToString())%>'>
If in database was image it show div and if there wasn't any image it didn't show div but above code is for div that I put in datalistnow I want do some thing like that for Div that I don't put it in datalist I should write code for that in behindecode page but I don't know How I can do it?behind code
SqlCommand _cmd = new SqlCommand("storeinfo1", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@behcode", data);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
[code]....
I have to insert default image into databse..when no image is selected from fileupload control.. Here is code...not working for default image...
if (FileUpload1.HasFile){string FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(Server.MapPath("~/UPLOADEDFILES/" + FileName));
feedBack.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileName));
} else {
string filename="~/images/"+ "sun.gif";filename.pPropertyImage = filename;FileUpload1.SaveAs(MapPath(filename));}
I have filed image type varbinary
I want upload image and show then with click button save
store in db
I know this might sound like a simple quesiton, but I am having problems allowing me to upload images along with other information (name, image, biography, wbsite links) to a sql server database, as well as showing images from the database using a drop list control feature. I am using [URL] for hosintg. VB language.
View 2 Replieshow to retrieve database image to the image control?
in the database, i have a column in database that store the url for the images. and how am i going to retrieve it to the form?
[Code]....
the "dtrSelect["Food_Pic].ToString()" is the url for the image.
I used below code for uploading image with fileupload control
string path = Server.MapPath(".") + "../image/estate/image";
string filename = System.IO.Path.GetFileName(fup3.PostedFile.FileName);
string[] validext = { ".jpg"};
string ext = System.IO.Path.GetExtension(fup3.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
{
Label21.Text = "insert .jpg format";
[code]....
I want if users don't select any image from fileupload control in database it save this image name 'default.jpg'
this is my code in page
<asp:DataList ID="DDLC" runat="server">
<ItemTemplate>
<div id="Dmainart">
<div id="Dart1_12">
<div id="Dart1_I1"><asp:Image ID="asp:Image" runat="server" CssClass="TPH" ImageUrl='<%#Eval("image","image/house/article/image/{0}")%>' Width="90px" Height="64px"/>
[code]...
i want if there wasnot any image in image column in database this div <div id="Dart1_I1"> display="none".
This code retrieve image from SQL database i want to add code if image is not exist retrieve another image in null value
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
string connectionString = WebConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
[Code] ....
I need displaying my image file stored from my database into the image control. I've had read some articles and watch video tutorial which there were perfectly working and I followed it but I wasn't able to make it work. The image control just displayed blank. I used Generic Handler to retrieve the image file from my database based on the articles and tutorials I've got. here are my codes below:
Generic Handler:
Code:
<%@ WebHandler Language="C#" Class="ShowImage" %>
using System;
using System.Configuration;
using System.Drawing;
using System.Drawing.Imaging;
[Code] ....
Asp.Net Code for the Image control:
HTML Code:
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ShowImage.ashx?ID=" + Eval("ID") %>' Height="128px" />
<asp:ImageField DataImageUrlField="photo" > <ItemStyle Width="50px" Height ="50px"
HorizontalAlign="Center" VerticalAlign="Middle" ></ItemStyle>
</asp:ImageField>
i need to display image from database in gridview. i have the above html and a select query executed from code behind which displays the image.
i am storing the image path in the database table and image in a folder.
Queries related to above
1. image size not able to set
2. the gridview image column will display image if the column data is not blank. but if its blank i have 2 default images male image and female image
so if the field is blank i need to display one of the default images depending on the gender selected
3. if the image is clicked it should show enlarged image as popup
how can i store image into database and view it in grid view?
View 3 RepliesHow to show defalut image in datalist untill large image fully loaded in same datalist ?
View 1 RepliesI am working on a website, using C# with a SQL backend. I'm using the Varbinary data type to store my images because the Image data type is eventually going away. I got the images into the DB and can pull them back out to display on the website. My question is how can I put the images from the DB into an Image control on the website? The images will be different sizes, so I need to keep them confined in one space on the site. I also need to randomly display the images, one at a time, on the website. The user needs to be able to hit the Next button to see the next image when they are ready. The user will only view the images, not make any changes and send data back to the DB.
Since the image will be confined within the image control, how can I allow the user to click on the image and open in a new window? The image needs to be bigger to allow the user to see more detail. Or would it be easier to allow the user to zoom in on the image within the current window?I am using VWD Express, C# 2010 Express & SQL 2005 Express.
I have 1 image & 1 label in page
I bind lable from database that show my users website address i want if user insert their website address in database and it show in lable image1.visible=true
and if in website column users don't insert any data image1.visible=false
I Have a Image Tags In My Web Application. I Upload The Image Path and stored In Database. How To Retrieve the Image Path Into Images Tags Using Database in Asp.Net..
View 1 RepliesI am attaching an image to a listview from code behind, the image depends on a value from the database and there are 5 different images.It sometimes works fine and then will randomly come up with an error, when nothing has changed, the error is:[Code]....
It doesn't seem to make sense to me because ImageUrl IS a member of image. Here is my code:
[Code]....
And code behind: [Code]....
I'm still a basic user of ASP.NET and i'm trying to figure out how can i use the FileUpload control to give an uploaded image to the Image control.
The FileUpload control doesn't have an OnClick() event so when i hit Upload i don't know what happens with the uploaded file in the back.
what i'm trying to do is choose a file with the FileUpload control, preview it in the Image control and then save it in an SQL Server 2008 database in an "image" field.
iam using asp.net with c#
i want to display an default image from my website folder when there is no image in database , can you correct my code
[Code]....
and in page load
[Code]....