thank you very much
"Steve C. Orr, MCSD" <St***@Orr.ne t> wrote in message
news:#G******** ******@TK2MSFTN GP09.phx.gbl...
Assuming a user is uploading the file, this code will save it into a
database:
Private Sub btnAttach_Click (ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles btnAttach.Click
Dim iLength As Integer = _ CType(File1.Pos tedFile.InputSt ream.Length,
Integer)
If iLength = 0 Then Exit Sub 'not a valid file
Dim sContentType As String = File1.PostedFil e.ContentType
Dim sFileName As String, i As Integer
Dim bytContent As Byte()
ReDim bytContent(iLen gth) 'byte array, set to file size
'strip the path off the filename
i = InStrRev(File1. PostedFile.File Name.Trim, "\")
If i = 0 Then
sFileName = File1.PostedFil e.FileName.Trim
Else
sFileName = Right(File1.Pos tedFile.FileNam e.Trim,
Len(File1.Poste dFile.FileName. Trim) - i)
End If
Try
File1.PostedFil e.InputStream.R ead(bytContent, 0, iLength)
With cmdInsertAttach ment
.Parameters("@F ileName").Value = sFileName
.Parameters("@F ileSize").Value = iLength
.Parameters("@F ileData").Value = bytContent
.Parameters("@C ontentType").Va lue = sContentType
.ExecuteNonQuer y()
End With
Catch ex As Exception
'Handle your database error here
dbConn.Close()
End Try
Response.Redire ct(Request.Url. ToString) 'Refresh page
End Sub
Here's the SQL Query that the above code uses:
INSERT INTO tblAttachments
(FileName, FileSize, FileData, ContentType)
VALUES (@FileName, @FileSize, @FileData, @ContentType)
(Use an field type of Image for your SQL Server data field.)
Here's more info:
http://www.aspnetpro.com/features/20...200307so_f.asp
--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net
"Duy Nguyen" <it*****@hotmai l.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
how can I save an image file to database?