how to display an image from folder when there is no image in database

[developerit]

hi 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

<%@ WebHandler Language="C#" Class="left1" %>

using System;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;

using System.Web;

public class left1 : IHttpHandler
{

public void ProcessRequest(HttpContext context)
{
    string  branchid = "";
    
    if(context.Session\["branchid"\]!=null)
    

        branchid= context.Session\["branchid"\].ToString();
    else
        throw new ArgumentException("No parameter specified");

    context.Response.ContentType = "image/jpeg";
    Stream strm = ShowImage(branchid);
    byte\[\] buffer = new byte\[4096\];
    int byteSeq = strm.Read(buffer, 0, 4096);

    while (byteSeq > 0)
    {
        context.Response.OutputStream.Write(buffer, 0, byteSeq);
        byteSeq = strm.Read(buffer, 0, 4096);
    }
        }

public Stream ShowImage(string branchid)
{
SqlConnection con = new SqlConnection(" Data Source=.; Initial Catalog=SafaView;User ID=sa;Password=nsg_ss_0103;");
string sql = "SELECT imgleft1 FROM tblImages WHERE BranchId = @BranchId";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@BranchId", branchid);
con.Open();
object img = cmd.ExecuteScalar();
try
{
return new MemoryStream((byte[])img);
}
catch
{
return null;
}
finally
{
con.Close();
}
}

public bool IsReusable
{
    get
    {
        return false;
    }
}

}

in page load =========

string id = "";
protected void Page_Load(object sender, EventArgs e)
{
id= Session["branchid"].ToString();
if (IsPostBack == false)
{
Image1.ImageUrl = "left1.ashx?BranchId="+id;
Image2.ImageUrl = "left1old.ashx?BranchId="+id;

       }

i want to display a default image when there is no image in database can you correct my code

[Dinesh Mani]

My assumptions - * Default image is also in the database * BranchId is numeric * Default image has the least possible BranchId say 0 Alter the query like so -

SELECT top 1 imgleft1 FROM tblImages WHERE BranchId in (@BranchId, @Default) order by BranchId desc

Add this line to the code

cmd.Parameters.AddWithValue("@Default", 0);

Now if the BranchId is available then that image would be displayed, else the default image would be displayed. HTH!