Can't Display Profile Image using asp .net

Posted by Webmasters964 under ASP.NET on 9/21/2013 | Points: 10 | Views : 3398 | Status : [Member] | Replies : 1
Hi

Can't Display Profile Image using asp .net

<asp:Image ID="Image1" runat="server" />

 protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
lb1.Text = "<b><font color=Brown>" + "Hi.." + "</font>" + "<b><font color=red>" + Session["UserName"] + "</font>";
bind();
}
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message.ToString() + "');</script>");
}

}


private void bind()
{
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand("select image from Login where UserName='" + Session["UserName"] + "'", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Image1.ImageUrl = dr[0].ToString();
}
con.Close();
}


Any Idea ..




Responses

Posted by: Bandi on: 9/21/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
protectedvoidPage_Load(objectsender,EventArgse){if(Request.QueryString["ImageID"] !=null){stringstrQuery ="select Name, ContentType, Data from tblFiles where id=@id";SqlCommandcmd =newSqlCommand(strQuery);cmd.Parameters.Add("@id",SqlDbType.Int).Value=Convert.ToInt32 (Request.QueryString["ImageID"]);DataTabledt = GetData(cmd);if(dt !=null){Byte[] bytes = (Byte[])dt.Rows[0]["Data"];Response.Buffer =true;Response.Charset ="";Response.Cache.SetCacheability(HttpCacheability.NoCache);Response.ContentType = dt.Rows[0]["ContentType"].ToString();Response.AddHeader("content-disposition","attachment;filename="+ dt.Rows[0]["Name"].ToString());Response.BinaryWrite(bytes);Response.Flush();Response.End();}}}



reference:
http://aspsnippets.com/Articles/Display-Images-from-SQL-Server-Database-using-ASP.Net.aspx
http://stackoverflow.com/questions/6987433/display-image-from-database-in-asp-net-with-c-sharp

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Webmasters964, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response