frmp_del.frm

进销存管理系统是基于用户的数据库管理系统

VERSION 5.00
Begin VB.Form frmP_Del 
   Caption         =   "删除商品"
   ClientHeight    =   2835
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   4155
   LinkTopic       =   "Form1"
   ScaleHeight     =   2835
   ScaleWidth      =   4155
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton cmdExit 
      Caption         =   "返回(&R)"
      Height          =   375
      Left            =   2280
      TabIndex        =   4
      Top             =   2160
      Width           =   975
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存(&S)"
      Height          =   375
      Left            =   720
      TabIndex        =   3
      Top             =   2160
      Width           =   975
   End
   Begin VB.Frame fraInfo 
      Caption         =   "商品信息"
      Height          =   1575
      Left            =   240
      TabIndex        =   0
      Top             =   240
      Width           =   3612
      Begin VB.TextBox txtSize 
         Height          =   390
         Left            =   1440
         TabIndex        =   6
         Top             =   840
         Width           =   1815
      End
      Begin VB.TextBox txtName 
         Height          =   390
         Left            =   1440
         TabIndex        =   5
         Top             =   240
         Width           =   1815
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "商品规格："
         Height          =   180
         Index           =   1
         Left            =   240
         TabIndex        =   2
         Top             =   845
         Width           =   900
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "商品名称："
         Height          =   180
         Index           =   0
         Left            =   240
         TabIndex        =   1
         Top             =   360
         Width           =   900
      End
   End
End
Attribute VB_Name = "frmP_Del"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdSave_Click()

Dim P_Name As String
Dim P_Size As String

P_Name = txtName.Text
P_Size = txtSize.Text

gConn.Execute "delete from products where 商品名称='" & P_Name & " 'and 商品规格= '" & P_Size & " ' "
MsgBox "操作已成功!", vbOKOnly

    '刷新整个FlexGrid
    Unload Me
    Load frmProductList
    frmProductList.SQL = "select * from products"
    frmProductList.Show

End Sub

Private Sub txtItem_Change(Index As Integer)

End Sub