用VB.NET 如果将任何文件以二进制形式保存在数据库,然后再从数据库读取出来

Imports System.IO
Imports System.Text
Imports System.Data.SqlClient
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim s As String = ""
        Dim FileStr As New FileStream("F:/模拟自动更新安装部署.msi", FileMode.Open, FileAccess.Read) '文件位置
        Dim TempBytes(FileStr.Length - 1) As Byte
        Dim idd As Integer = FileStr.Read(TempBytes, 0, FileStr.Length)
        FileStr.Close()

        Dim a As Integer = s.Length
        Dim connStr As String = "server=192.168.0.127;database=测试SQL;uid=sa;password="
        Dim conn As SqlConnection = DBHelp.DBConn(connStr)
        Dim ds As New DataSet()
        Dim dp As New SqlDataAdapter("SELECT * FROM 版本表 WHERE 1=0", conn)
        Dim aa As SqlCommandBuilder = New SqlCommandBuilder(dp)
        dp.Fill(ds)
        Dim DTR As DataRow = ds.Tables(0).NewRow()
        DTR("版本号") = "1.0.0.1"
        DTR("更新日期") = DateTime.Now.ToString()
        DTR("更新文件") = TempBytes
        ds.Tables(0).Rows.Add(DTR)
        dp.Update(ds)
        conn.Close()


    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim connStr As String = "server=192.168.0.127;database=测试SQL;uid=sa;password="
        Dim conn As SqlConnection = DBHelp.DBConn(connStr)
        Dim ds As New DataSet()
        Dim dp As New SqlDataAdapter("SELECT * FROM 版本表", conn)
        Dim aa As SqlCommandBuilder = New SqlCommandBuilder(dp)
        dp.Fill(ds)
        Dim TempBytes() As Byte = ds.Tables(0).Rows(0)("更新文件")
        Dim FileStr As New FileStream("F:/模拟自动更新安装部署还原.msi", FileMode.Create, FileAccess.Write)
        FileStr.Write(TempBytes, 0, TempBytes.Length)
        FileStr.Close()
    End Sub
End Class

  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值