ASP.NET

<add assembly="Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89B483F429C47342"/>

<assemblies>
       <add assembly="Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
     </assemblies>

<asp:GridView ID="GridView1" runat="server">
   <Columns>
   <asp:TemplateField>
   <ItemTemplate>
   <asp:Image ID="img1" runat="server" ImageUrl='<%#Eval("imageUrlFielName") %>' />
   </ItemTemplate>
   </asp:TemplateField>
   </Columns>
   </asp:GridView>

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

 

using System;

using System.Web;

using System.Data.SqlClient;

using System.Data;

using System.IO;

using System.Collections.Specialized;

 

public class showpic: IHttpHandler {

 

    public string GetConnectionString()

    {

        //sets the connection string from your web config file "ConnString" is the name of your Connection String

        return System.Configuration.ConfigurationManager.ConnectionStrings["b4mConnectionString"].ConnectionString;

    }

    public void ProcessRequest(HttpContext context)

    {

        string id = context.Request.QueryString["id"]; //get the querystring value that was pass on the ImageURL (see GridView MarkUp in Page1.aspx)
        string img = context.Request.QueryString["img"];
        if (id != null)

        {


            try
            {
                MemoryStream memoryStream = new MemoryStream();

                SqlConnection connection = new SqlConnection(GetConnectionString());

                string sql = "SELECT " + img + " FROM useraccount WHERE userid= @id";



                SqlCommand cmd = new SqlCommand(sql, connection);


                cmd.Parameters.AddWithValue("@id", id);

                connection.Open();



                SqlDataReader reader = cmd.ExecuteReader();

                reader.Read();


                byte[] file = (byte[])reader[0];



                reader.Close();

                connection.Close();

                memoryStream.Write(file, 0, file.Length);

                context.Response.Buffer = true;

                context.Response.BinaryWrite(file);

                memoryStream.Dispose();
            }
            catch
            { 
            
            }
 

        }

    }

 

    public bool IsReusable {

        get {

            return false;

        }

    }

}

'<%# "generics/showpic.ashx?id="+Eval("userid")+"&img=picture" %>'

vanikanc wrote:

a file which I need to post to a remote client server

vanikanc wrote:

I keep getting "Remote Server returned error - 401 UnAuthorized Error".