How add image from SQLServer database to Asp.Net

Display image from Database to Asp.net page.

                            Today website  with image, video or text are dynamically change everyday. Most trainer don't how to add image from database. Most try to store image in database binary, there are some disadvantage in that slow response or wastage of memory etc.

In design page try this tag.

 <asp:Image id="gvimg" runat="server" ImageUrl='<%#Eval("image_url")%>'  Width ="60px" Height ="40px" /> 

in Code behind page vb.net code. if want c# code convert this code using convert tool.

Imports System.Data

Imports System.Data.SqlClient

Dim ds As New DataSet

        Dim dadp As SqlDataAdapter

        Dim i, j As Integer

        str2 = ConfigurationManager.ConnectionStrings("DefaultConnection").ConnectionString

        Dim con1 As SqlConnection = New SqlConnection(str2)

        dadp = New SqlDataAdapter("SELECT   *   FROM [job_info] where jobid=1", con1)

        dadp.Fill(ds, "temp1")
i = ds.Tables("temp1").Rows.Count
        For j = 0 To i - 1 Step j + 1

                  gvimg.ImageUrl = ds.Tables("temp1").Rows(j)("image_url").ToString()
Next

Through image id gvimg we set image location. Next post we see how to upload image and how store imageurl.