Good afternoon every one,
Sir I m fresher . I m trying to insert image in data base . so I copied that code but My image not show
This is Databse:-
-------------------------
colum Name datatype
ImageId Int(set identity property=true)
ImageName Varchar(50)
Image image
---------------------------
.cs Code:
protected void btnUpload_Click(object sender, EventArgs e)
{
if (imageUpload.HasFile)
{
int length = imageUpload.PostedFile.ContentLength;
byte[] imgbyte = new byte[length];
HttpPostedFile img = imageUpload.PostedFile;
img.InputStream.Read(imgbyte, 0, length);
string imagename = txtImageName.Text;
SqlConnection con = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand("insert into Table_1(u_id,user_name,email,image,image_name) values ('3','yawar','yawr@gmail.com','"+img +"','"+imagename+"')", con);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
--------------------------------
grid view:-
</asp:TemplateField>
<asp:TemplateField HeaderText="Photo">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("u_id")%>' Height="200px" Width="200px"/>
</ItemTemplate>
</asp:TemplateField>
---------------------
<%@ WebHandler Language="C#" Class="ImageHandler" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.IO;
public class ImageHandler : IHttpHandler
{
string strcon = "Server=UNIAYUR-PC\\YAWAR; User Id=sa; Password=uniayur123; Database=Gridview_data";
public void ProcessRequest (HttpContext context)
{
string imageid = context.Request.QueryString["ImID"];
SqlConnection con = new SqlConnection(strcon);
con.Open();
SqlCommand cmd = new SqlCommand(" Select image from Table_1 where u_id='" + imageid + "'", con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
context.Response.BinaryWrite((Byte[])dr[0]);
context.Response.End();
con.Close();
}
public bool IsReusable
{
get
{
return false;
}
}
}