手机站
网通分站
电信主站
密 码:
用户名:
当前位置 : 主页>程序设计>VB>列表

利用Vb保存一幅图到Access数据库

来源:互联网 作者:west263.com 时间:2008-02-23
西部数码-全国虚拟主机10强!40余项虚拟主机管理功能,全国领先!双线多线虚拟主机南北访问畅通无阻!免费赠送企业邮局,.CN域名,自助建站480元起,免费试用7天,满意再付款! P4主机租用799元/月.月付免压金!


    Object = "{3B7C8863-D78F-101B-B9B5-04021C009402}#1.2#0"; "richtx32.ocx"

    Begin VB.Form fshow

    BorderStyle = 0 'None

    Caption = "显示图片"

    ClientHeight = 7125

    ClientLeft = 0

    ClientTop = 0

    ClientWidth = 10275

    LinkTopic = "Form1"

    MDIChild = -1 'True

    ScaleHeight = 7125

    ScaleWidth = 10275

    ShowInTaskbar = 0 'False

    Begin VB.Frame Frame2

    Height = 6615

    Left = 2880

    TabIndex = 1

    Top = 240

    Width = 7335

    Begin VB.CommandButton Command1

    Caption = "关闭"

    Height = 375

    Left = 5880

    TabIndex = 5

    Top = 5880

    Width = 1215

   End

    Begin RichTextLib.RichTextBox RichTextBox1

    Height = 4095

    Left = 120

    TabIndex = 4

    Top = 1200

    Width = 6975

    _ExtentX = 12303

    _ExtentY = 7223

    _Version = 393217

    TextRTF = $"fshow.frx":0000

   End

    Begin VB.Image Image1

    Height = 855

    Left = 120

    Stretch = -1 'True

    Top = 5640

    Width = 1095

   End

    Begin VB.Line Line4

    X1 = 5520

    X2 = 5520

    Y1 = 5520

    Y2 = 6600

   End

    Begin VB.Line Line3

    X1 = 0

    X2 = 7320

    Y1 = 5520 

    Y2 = 5520

   End

    Begin VB.Line Line2

    X1 = 0

    X2 = 7320

    Y1 = 960

    Y2 = 960

   End

    Begin VB.Label Label1

    BackColor = &H80000009&

    Height = 615

    Left = 120

    TabIndex = 3

    Top = 240

    Width = 7095

   End

   End

    Begin VB.Frame Frame1

    Height = 6735

    Left = 120

    TabIndex = 0

    Top = 240

    Width = 2535

    Begin MSComctlLib.TreeView TreeView1

    Height = 6375

    Left = 120

    TabIndex = 2

    Top = 240

    Width = 2295

    _ExtentX = 4048

    _ExtentY = 11245

    _Version = 393217

    PathSeparator = ""

    Style = 7

    Appearance = 1

   End

   End

    Begin VB.Line Line1

    BorderColor = &H80000001&

    X1 = 2760

    X2 = 2760

    Y1 = 120

    Y2 = 6960

   End

   End

    Attribute VB_Name = "fshow"

    Attribute VB_GlobalNameSpace = False

    Attribute VB_Creatable = False

    Attribute VB_PredeclaredId = True

    Attribute VB_Exposed = False

    Option Explicit



   Private Sub Command1_Click()

    Unload Me

   End Sub



    Private Sub Form_Load()

    Dim temptop, templeft As Long

    Me.Left = 0

    Me.Top = 0

    fmain.Width = Me.Width 340

    fmain.Height = Me.Height 1550

    fmain.Top = (Screen.Height - fmain.Height) / 2

    fmain.Left = (Screen.Width - fmain.Width) / 2



   '显示结果

    Dim rs As New ADODB.Recordset

    Dim image_filename As String

    Dim temp_image() As Byte

    Dim sql As String

    sql = "select * from paper where subject=' ipx协议简介'"

    rs.Open sql, cn, adOpenDynamic, adLockReadOnly

    Label1.Caption = rs("inputtime")

    temp_image() = rs("photo")

    image_filename = App.Path "\temp." rs("photo_ext")

    rs.Close

    '建立临时文件

    Open image_filename For Binary As #1

    Put #1, , temp_image()

    Close #1

    Image1.Picture = LoadPicture(image_filename)

    '删除临时文件

    Kill image_filename

   End Sub

     上面代码只能显示一条记录,而且需要先赋条件,显示图片用的是先建一个临时文件,然后把二进制数据读到这个文件里,同时要赋给正确的扩展名,然后可以显示图片,注意,要及时删除临时文件。

   总结:这种方法只是保存图片的其中一种,还有其它保存到数据库的方法,希望大家不断的交流其它的保存图片的方法。

上一篇: 文本框的使用说明与技巧
下一篇: VB中列表框的使用技巧说明

文章整理:西部数码--专业提供域名注册虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢!