using this code i want to upload image and show on page_load..
but its doing nothing please help
public void BindGridData()
{
string username=(string)(Session["UserAuthentication"]);
SqlConnection con = new SqlConnection(connstring);
SqlCommand cmd = new SqlCommand("SELECT imgname from [Image] WHERE imgname='" + username + "'", con);
SqlDataReader sdr;
con.Open();
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Image1.ImageUrl = sdr[0].ToString();
}
con.Close();
}
protected void Button2_Click1(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
int length = FileUpload1.PostedFile.ContentLength;
byte[] imgbyte = new byte[length];
HttpPostedFile img = FileUpload1.PostedFile;
img.InputStream.Read(imgbyte, 0, length);
string username=(string)(Session["UserAuthentication"]);
SqlConnection connection = new SqlConnection(connstring);
connection.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO Image (imgname,Image) VALUES (@imgname,@imagedata)", connection);
cmd.Parameters.Add("@imgname", SqlDbType.VarChar, 50).Value = username;
cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;
int count = cmd.ExecuteNonQuery();
connection.Close();
if (count == 1)
{
BindGridData();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + username + " image inserted successfully')", true);
}
}
public class ImageHandler : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
string imageid = context.Request.QueryString["ID"];
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\VAS\Desktop\Orignal Project Part 1\Inventory Management System\IMS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
conn.Open();
SqlCommand command = new SqlCommand("select Image from Image where imgname=" + imageid, conn);
SqlDataReader dr = command.ExecuteReader();
dr.Read();
context.Response.BinaryWrite((Byte[])dr[0]);
conn.Close();
context.Response.End();
}
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ID="+ Eval("imagename") %>' Height="267px"
Width="768px" />