CODEWITHSUNDEEP
asp.netsql-servervb.net
Mohamad
Mohamad

Reputation: 608

read image from folder and database

How can i read images from folder "images" and her name in the database using asp.net vb code this is the code i use.

   Dim conn As SqlConnection
   Dim cmd As SqlCommand
   Dim cmdString As String = ("select TOP 20 * from tbl_news order by db_id desc ")
   conn = New SqlConnection("Data Source=.\sqlexpress;AttachDbFilename=C:\Users\m7md\Documents\Visual Studio 2008\Projects\AlAkhbar\AlAkhbar\App_Data\Database1.mdf;Integrated Security=True;User Instance=True")
   cmd = New SqlCommand(cmdString, conn)
   conn.Open()
   Dim dr As SqlDataReader = cmd.ExecuteReader

   While (dr.Read)
       Response.Write("<div id=title>")
       Response.Write("<img src='images/db_img')  />")
       Response.Write("</div>")
       Response.Write("<div id=title>")
       Response.Write(dr("db_title"))
       Response.Write("<br/>")
       Response.Write("<br/>")
       Response.Write("</div>")
       Response.Write("<div id=sumury>")
       Response.Write(dr("db_sumury"))
       Response.Write("</div>")
       Response.Write("<div id=readmore>")
       Response.Write("<a href=readmore.aspx?id=" & dr("db_id").ToString & "> Readmore</a>")
       Response.Write("</div>")
       Response.Write("<hr/>")

   End While

Upvotes: 0

Views: 412

Answers (1)

Dalorzo
Dalorzo

Reputation: 20024

You need to create an image handler. You can find more information here:

Upvotes: 2

Related Questions