ASP.NET

yogesh_softworld123 wrote:

how to retrive images from sql database which is already strored, and show in image componet, using asp.net with c#.

Christian Graus wrote:

it needs to exist on the file systme

<br />
Image img = new Image();<br />
img.ImageURL = "~\ImageBuilder.Aspx?staffID=1234";<br />

<br />
<br />
 Private Sub btnRetrive_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRetrive.Click<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR"))<br />
        Dim sqlcommand As New SqlCommand("select PersonImage from dbo.Person where PersonID=3", sqlconn)<br />
        Try<br />
            sqlconn.Open()<br />
            Dim SqlData As SqlDataReader<br />
            SqlData = sqlcommand.ExecuteReader(CommandBehavior.CloseConnection)<br />
            Do While (SqlData.Read())<br />
                Response.ContentType = "image/gif"<br />
                Response.BinaryWrite(SqlData.Item("PersonImage"))<br />
            Loop<br />
            sqlconn.Close()<br />
        Catch SQLex As SqlException<br />
            Response.Write("Insert Failed. Error Details are: " & SQLex.ToString())<br />
<br />
        End Try<br />
    End Sub<br />
<br />
<br />
<br />
<br />

Response.ClearHeaders()<br />
  Response.Cache.SetNoStore()<br />
  Response.ContentType = "image/gif"<br />
  Response.BinaryWrite(lImageDataset.Tables(0).Rows(0)(0))

<br />
'Using DB To Store Image IN Database<br />
 Private Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click<br />
<br />
        Dim oStrPostedFileName, oStrFileName<br />
        Dim oBinaryReader As BinaryReader<br />
        Dim fs As FileStream<br />
<br />
        intImageSize = fileUploadCTRL.PostedFile.ContentLength<br />
        strImagetype = fileUploadCTRL.PostedFile.ContentType<br />
        ImageStream = fileUploadCTRL.PostedFile.InputStream<br />
        oStrPostedFileName = System.IO.Path.GetFullPath(fileUploadCTRL.Value)<br />
<br />
        Dim ImageContent(intImageSize) As Byte<br />
        intsize = ImageStream.Read(ImageContent, 0, intsize)<br />
<br />
<br />
<br />
        fs = New FileStream(oStrPostedFileName, FileMode.Open, FileAccess.Read)<br />
        Dim MyData(fs.Length) As Byte<br />
<br />
        oBinaryReader = New BinaryReader(fs)<br />
        ImageContent = oBinaryReader.ReadBytes(CType(fs.Length, Integer))<br />
        oBinaryReader.Close()<br />
        fs.Close()<br />
<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR1"))<br />
        sqlconn.Open()<br />
<br />
        Dim sqlcommand As New SqlCommand("sp_Image", sqlconn)<br />
        sqlcommand.CommandType = CommandType.StoredProcedure<br />
        sqlcommand.Parameters.Add(New SqlParameter("@PersonImage", SqlDbType.Image))<br />
        sqlcommand.Parameters("@PersonImage").Value = ImageContent<br />
        sqlcommand.ExecuteNonQuery()<br />
        Response.Write("New Image Added Successfully")<br />
    End Sub<br />
<br />
'Reteriving From DB<br />
Private Sub btnRetrive_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRetrive.Click<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR1"))<br />
        Dim ds As New DataSet<br />
        Dim i As Integer<br />
        Dim da As New SqlDataAdapter("select PersonImage from Contacts.dbo.Person where pid in(1,2,3)", sqlconn)<br />
        Try<br />
            sqlconn.Open()<br />
            da.Fill(ds)<br />
            For i = 0 To ds.Tables(0).Rows.Count - 1<br />
<br />
                Response.ClearHeaders()<br />
                Response.Cache.SetNoStore()<br />
                Response.ContentType = "image/gif"<br />
                Response.BinaryWrite(ds.Tables(0).Rows(i).Item("PersonImage"))<br />
            Next<br />
<br />
        Catch ex As Exception<br />
            ex.Message.ToString()<br />
        Finally<br />
            sqlconn.Close()<br />
        End Try<br />
    End Sub<br />
<br />
End Class<br />