<%@ 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; } } }
|