read image from folder and database

Question

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

"_ plz help me_" - we don't appreciate begging here. Also, you have many errors in your HTML. You can't have two elements with the same id, for instance. You should also read about using the Repeater or DataList controls. — John Saunders
– John Saunders, Commented Dec 25, 2013 at 17:17

Community · Accepted Answer · 2017-05-23 11:56:47Z

2

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

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Dec 25, 2013 at 17:09

Dalorzo

20k7 gold badges57 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mohamad Over a year ago

plz more details in coding

Dalorzo Over a year ago

stackoverflow.com/questions/21877/… The sample code is there. You can use @FlySwat sample code. I did not find fair copying over their answer here.

Collectives™ on Stack Overflow

read image from folder and database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related