【VB开源代码栏目提醒】：网学会员,鉴于大家对VB开源代码十分关注，论文会员在此为大家搜集整理了“frmFile_toFile.frm”一文，供大家参考学习!

    VERSION 5.00
    Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
    Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
    Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "ComDlg32.OCX"
    Begin VB.Form frmFile_toFile 
       Caption         =   "已发文件"
       ClientHeight    =   4980
       ClientLeft      =   60
       ClientTop       =   345
       ClientWidth     =   10455
       LinkTopic       =   "Form1"
       MaxButton       =   0   'False
       ScaleHeight     =   4980
       ScaleWidth      =   10455
       StartUpPosition =   2  '屏幕中心
       Begin VB.CommandButton cmdEnd 
          Caption         =   "退出"
          Height          =   360
          Left            =   9015
          TabIndex        =   0
          Top             =   150
          Width           =   1260
       End
       Begin MSComDlg.CommonDialog CommonDialog1 
          Left            =   6600
          Top             =   60
          _ExtentX        =   847
          _ExtentY        =   847
          _Version        =   393216
       End
       Begin MSAdodcLib.Adodc adoFile 
          Height          =   330
          Left            =   2895
          Top             =   135
          Visible         =   0   'False
          Width           =   2130
          _ExtentX        =   3757
          _ExtentY        =   582
          ConnectMode     =   0
          CursorLocation  =   3
          IsolationLevel  =   -1
          ConnectionTimeout=   15
          CommandTimeout  =   30
          CursorType      =   3
          LockType        =   3
          CommandType     =   8
          CursorOptions   =   0
          CacheSize       =   50
          MaxRecords      =   0
          BOFAction       =   0
          EOFAction       =   0
          ConnectStringType=   1
          Appearance      =   1
          BackColor       =   -2147483643
          ForeColor       =   -2147483640
          Orientation     =   0
          Enabled         =   -1
          Connect         =   ""
          OLEDBString     =   ""
          OLEDBFile       =   ""
          DataSourceName  =   ""
          OtherAttributes =   ""
          UserName        =   ""
          Password        =   ""
          RecordSource    =   ""
          Caption         =   "adoFile"
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          _Version        =   393216
       End
       Begin MSDataGridLib.DataGrid DataGrid1 
          Height          =   3975
          Left            =   60
          TabIndex        =   1
          Top             =   600
          Width           =   10260
          _ExtentX        =   18098
          _ExtentY        =   7011
          _Version        =   393216
          AllowUpdate     =   0   'False
          HeadLines       =   1
          RowHeight       =   15
          BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          ColumnCount     =   2
          BeginProperty Column00 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          BeginProperty Column01 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          SplitCount      =   1
          BeginProperty Split0 
             MarqueeStyle    =   4
             BeginProperty Column00 
             EndProperty
             BeginProperty Column01 
             EndProperty
          EndProperty
       End
       Begin VB.Label Label1 
          AutoSize        =   -1  'True
          BackColor       =   &H8000000A&
          Caption         =   "提示：双击表格文件记录即可下载当前文件。"
          ForeColor       =   &H00C00000&
          Height          =   180
          Left            =   6690
          TabIndex        =   2
          Top             =   4710
          Width           =   3600
       End
    End
    Attribute VB_Name = "frmFile_toFile"
    Attribute VB_GlobalNameSpace = False
    Attribute VB_Creatable = False
    Attribute VB_PredeclaredId = True
    Attribute VB_Exposed = False
    Public filePath As String
    Dim cn As ADODB.Connection
    Dim rs As ADODB.Recordset
    Dim mst As ADODB.Stream
    
    Private Sub cmdEnd_Click()
      Unload Me
    End Sub
    
    Private Sub DataGrid1_DblClick()
      If MsgBox("是否保存传送给【" & DataGrid1.Columns(1).Text & "】的『" & DataGrid1.Columns(3).Text & "』文件吗？", vbQuestion + vbYesNo) = vbYes Then
         CommonDialog1.fileName = DataGrid1.Columns(8).Text
         CommonDialog1.ShowSave
         filePath = CommonDialog1.fileName
         Me.MousePointer = 11
         Set cn = New ADODB.Connection
             cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db_OA;Data Source=MRZYT"
             cn.Open
         Set rs = New ADODB.Recordset
             rs.Open "select * from tbOA_file where file_id='" & frmFile_incept.adoFile.Recordset.Fields(0).Value & "'", cn, adOpenStatic, adLockOptimistic
         Set mst = New ADODB.Stream
             mst.Type = adTypeBinary
             mst.Open
             mst.Write rs.Fields(7).Value
             mst.SaveToFile filePath, adSaveCreateOverWrite  '保存文件，adSaveCreateOverWrite为覆盖以存在文件
         rs.Close
         cn.Close
         Me.MousePointer = 0
         MsgBox "现在成功！ " & "文件保存在： " & frmFile_incept.filePath, vbInformation, "文件下载"
      End If
    End Sub
    
    Private Sub Form_Load()
      adoFile.ConnectionString = PublicStr
      adoFile.RecordSource = "select * from tbOA_file where file_person='" + Mid(frm_mainBefore.StatusBar1.