frm_sdf.frm

公寓信息管理系统： 公寓的住宿、 退房等 水电费管理

VERSION 5.00
Begin VB.Form Frm_sdf 
   Caption         =   "Form1"
   ClientHeight    =   5850
   ClientLeft      =   60
   ClientTop       =   405
   ClientWidth     =   8280
   LinkTopic       =   "Form1"
   ScaleHeight     =   5850
   ScaleWidth      =   8280
   StartUpPosition =   3  '窗口缺省
   Begin VB.TextBox Text3 
      Height          =   495
      Left            =   6360
      TabIndex        =   3
      Text            =   "54"
      Top             =   1080
      Width           =   1695
   End
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   615
      Left            =   2520
      TabIndex        =   2
      Top             =   3240
      Width           =   2295
   End
   Begin VB.TextBox Text2 
      Height          =   615
      Left            =   3480
      TabIndex        =   1
      Text            =   "54"
      Top             =   1080
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Left            =   720
      TabIndex        =   0
      Text            =   "王小二"
      Top             =   1080
      Width           =   2415
   End
End
Attribute VB_Name = "Frm_sdf"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim tast_sf As Integer
Dim tast_df As Integer
Dim sql As String
cnn.Open strcnn
sql = "select * from 水电费 where 姓名='" + Text1.Text + "'"

rst.Open sql, cnn, adOpenStatic, adOpenDynamic

       tast_sf = rst.Fields(1).Value + Int(Trim(Text2.Text))
      tast_sf = rst.Fields(1).Value + Int(Trim(Text2.Text))
        tast_df = rst.Fields(3).Value + Int(Trim(Text3.Text))
        sql = "update 水电费 set 姓名='" + Text1.Text + "',水费='" _
        + tast_sf + "',班级编号='" + Trim(Text3.Text) + "',电费='" + Trim(Text3.Text) + "'where 姓名='" + Trim(Text1.Text) + "'"
        Update (sql)
End Sub

Private Sub Txt_zy_Change()

End Sub