Word doc in a database, you can do it with the
following VB.net code:
Dim vStream As New FileStream("C:\Alex.doc", FileMode.Open)
Dim vLen As Integer = New FileInfo("C:\Alex.doc").Length
Dim vBlob(vLen) As Byte
Dim n As Integer = vStream.Read(vBlob, 0, vLen)
Dim vSql As String = "INSERT INTO tBlobTable (vId,vBlob) VALUES (1,@vBlob)"
Dim sql As New SqlCommand(vSql, vConn)
Dim sqlPar As New SqlParameter("@vBlob", SqlDbType.Image)
sqlPar.Value = vBlob
sql.Parameters.Add(sqlPar)
I hope you would find it useful.
No comments:
Post a Comment