文件存取

  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("D:\1024R整机标签.BTW", FileMode.Open, FileAccess.Read) '文件位置
        Dim TempBytes(FileStr.Length - 1) As Byte
        FileStr.Read(TempBytes, 0, FileStr.Length)
        FileStr.Close()


        Dim connStr As String = "server=127.0.0.1;database=GP;uid=sa;password="
        Dim conn As SqlConnection = New SqlConnection(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.2"
        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=127.0.0.1;database=GP;uid=sa;password="
        Dim conn As SqlConnection = New SqlConnection(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("C:\1024R整机标签.BTW", FileMode.Create, FileAccess.Write)
        FileStr.Write(TempBytes, 0, TempBytes.Length)
        FileStr.Close()
    End Sub