【VB开源代码栏目提醒】：文章导读：在新的一年中，各位网友都进入紧张的学习或是工作阶段。网学会员整理了VB开源代码-frmgoodstable.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"
    Begin VB.Form frmGoodsTable 
       BorderStyle     =   1  'Fixed Single
       Caption         =   "显示现存商品"
       ClientHeight    =   2700
       ClientLeft      =   45
       ClientTop       =   330
       ClientWidth     =   6480
       Enabled         =   0   'False
       LinkTopic       =   "Form1"
       MaxButton       =   0   'False
       MDIChild        =   -1  'True
       MinButton       =   0   'False
       ScaleHeight     =   2700
       ScaleWidth      =   6480
       Begin MSDataGridLib.DataGrid DataGrid1 
          Bindings        =   "frmGoodsTable.frx":0000
          Height          =   2055
          Left            =   0
          TabIndex        =   0
          Top             =   120
          Width           =   6135
          _ExtentX        =   10821
          _ExtentY        =   3625
          _Version        =   393216
          AllowUpdate     =   0   'False
          HeadLines       =   1
          RowHeight       =   15
          BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "MS Sans Serif"
             Size            =   8.25
             Charset         =   0
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "MS Sans Serif"
             Size            =   8.25
             Charset         =   0
             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 
             BeginProperty Column00 
             EndProperty
             BeginProperty Column01 
             EndProperty
          EndProperty
       End
       Begin MSAdodcLib.Adodc Adodc1 
          Height          =   375
          Left            =   1800
          Top             =   2160
          Visible         =   0   'False
          Width           =   3015
          _ExtentX        =   5318
          _ExtentY        =   661
          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         =   "Provider=MSDASQL.1;Persist Security Info=False;Data Source=SellSystem"
          OLEDBString     =   "Provider=MSDASQL.1;Persist Security Info=False;Data Source=SellSystem"
          OLEDBFile       =   ""
          DataSourceName  =   ""
          OtherAttributes =   ""
          UserName        =   ""
          Password        =   ""
          RecordSource    =   "select * from goods"
          Caption         =   "Adodc1"
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "MS Sans Serif"
             Size            =   8.25
             Charset         =   0
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          _Version        =   393216
       End
    End
    Attribute VB_Name = "frmGoodsTable"
    Attribute VB_GlobalNameSpace = False
    Attribute VB_Creatable = False
    Attribute VB_PredeclaredId = True
    Attribute VB_Exposed = False
     
    Private Sub Form_Load()
      Dim X0 As Long
       Dim Y0 As Long
      
       '让窗体居中
       X0 = Screen.Width
       Y0 = Screen.Height
       X0 = (X0 - Me.Width) / 2
       Y0 = (Y0 - Me.Height) / 2
       Me.Move X0, Y0
      Dim rs_check As New ADODB.Recordset
      If all = False Then
         Dim strsql As String
         strsql = "select * from goods where 商品名='" _
         & strgname & "'and 型号= '" & strtype & "'"
         'strgname 和strtype变量是前面定义的公共变量，用来传递查询窗体中的商品名和型号
         Adodc1.RecordSource = strsql
         Adodc1.Refresh
         DataGrid1.ReBind
         rs_check.Open strsql, conn, adOpenKeyset, adLockPessimistic
         Adodc1.RecordSource = strsql
         Adodc1.Refresh
         DataGrid1.ReBind
         If rs_check.EOF = True Then
              MsgBox "此型号商品没有进货！", vbOKOnly + vbInformation, "注意"
              rs_check.Close
              Exit Sub
          End If
          rs_check.Close
      End If
        
    End Sub