CODEWITHSUNDEEP
asp.netsqlimage
btevfik
btevfik

Reputation: 3431

direct link to image in database in asp.net

How can we retrieve an image from database with direct link?

I understand that we can get the image as /getImage.aspx?id=1 for instance.

But how can we create a direct link like /image1.jpg ?

Upvotes: 0

Views: 623

Answers (2)

Luv
Luv

Reputation: 51

YOU SHOULD TRY THIS

 <asp:GridView ID="GridView1" runat="server" EnableViewState="false"
    AutoGenerateColumns="false"> 
   <Columns> 
    <asp:BoundField HeaderText="AutoId" DataField="AutoId" /> 
     <asp:BoundField HeaderText="File Name" DataField="FileName" />  
      <asp:TemplateField HeaderText="File"> 
      <ItemTemplate> <img src="ShowImage.ashx?autoId=<%# Eval("AutoId") %>" alt="<%# 
       Eval("FileName") %>" /> 
       </ItemTemplate> 
      </asp:TemplateField> 
      <asp:TemplateField HeaderText="IsActive"> 
    <ItemTemplate> <%# Eval("Active").ToString().Equals("True") ? "Yes" : "No" %> 
     </ItemTemplate> 
      </asp:TemplateField> 
    </Columns> 
     </asp:GridView> 

   Behind Code: 
   string _connStr =
   ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; 
    protected void Page_Load(object sender, EventArgs e) 
  { 
     if (!IsPostBack) 
       { 
           BindFiles(); 
       } 
   } 

        private void BindFiles() 
        { 
          DataTable table = new DataTable(); 

         using (SqlConnection conn = new SqlConnection(_connStr)) 
             { 

                string sql = "SELECT AutoId, FileName, FileContent, Active FROM Files
                Order By AutoID ASC"; 

            using (SqlCommand cmd = new SqlCommand(sql, conn)) 
                { 

               using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) 
                      { 
                          ad.Fill(table); 
                      } 

                 } 
                } 
           GridView1.DataSource = table; 
            GridView1.DataBind(); 
           }

Upvotes: 0

Amit Khanna
Amit Khanna

Reputation: 489

you can use URL Rewrite to solve your problem

Upvotes: 1

Related Questions