Option Explicit
Dim cnn As ADODB.Connection
Dim rs As ADODB.RecordsetPrivate Sub Cmdcancel_Click()
rs.CancelUpdate
display
End SubPrivate Sub Cmddelete_Click()
Dim i As String
i = MsgBox("你确定要删除此记录吗?", vbYesNo + vbInformation, "删除记录")
If i = vbYes Then
rs.Delete
rs.MovePrevious
If rs.BOF Then rs.MoveFirst
display
End If
End SubPrivate Sub Cmdexit_Click()
Unload Me
End SubPrivate Sub cmdfind_Click()
Dim cnn2 As ADODB.Connection
Dim rs2 As ADODB.Recordset
Dim s As String
Set cnn2 = New ADODB.Connection
s = "select * from data_1 where id='" & Txtid.Text & "' ;"
cnn2.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn2.Open "D:\VB98\学生信息\data.mdb"
Set rs2 = New ADODB.Recordset
rs2.Open s, cnn2, adOpenDynamic
If rs2.EOF Or rs2.BOF Then MsgBox "无效ID号": Exit Sub
Do While Not rs2.EOF
If s = rs2!id Then
Txtid = rs2!id
txtname = rs2!Name
Txtadd = rs2!Add
Exit Do
End If
rs2.MoveNext
Loop
If rs2.EOF Then
Txtid = ""
txtname = ""
Txtadd = ""
MsgBox "没找到!" End If
End SubPrivate Sub Txtqdd_Change()End SubPrivate Sub Cmdsave_Click()
rs.AddNew
rs!id = Txtid
rs!Name = txtname
rs!Add = Txtadd
rs.Update
End SubPrivate Sub Codadd_Click() rs.AddNew
Txtid = ""
txtname = ""
Txtadd = ""
Txtid.SetFocus
End SubPrivate Sub Command1_Click()
rs.MoveFirst
display
End SubPrivate Sub Command2_Click()
rs.MovePrevious
If rs.BOF Then
MsgBox "到第一条记录"
rs.MoveFirst
End If
display
End SubPrivate Sub Command3_Click()
rs.MoveNext
If rs.EOF Then
MsgBox "到最后一条记录"
rs.MoveLast
End If
display
End SubPrivate Sub Command4_Click()
rs.MoveLast
display
End Sub
'激活窗口
Private Sub Form_Activate()
display
End Sub
'加载窗口
Private Sub Form_Load()
Dim addFlag As Boolean
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Open "D:\VB98\学生信息\data.mdb"
rs.Open "data_1", cnn, adOpenDynamic, adLockBatchOptimistic, adCmdTable
addFlag = False
End Sub
'显示记录
Private Sub display()
Txtid = rs!id
txtname = rs!Name
Txtadd = rs!Add
End Sub
'卸载窗体
Private Sub form_unload(cancel As Integer)
cnn.Close
End Sub
这个程序中~find和save是错误的`
请教高手`
这两个错在哪`
Dim cnn As ADODB.Connection
Dim rs As ADODB.RecordsetPrivate Sub Cmdcancel_Click()
rs.CancelUpdate
display
End SubPrivate Sub Cmddelete_Click()
Dim i As String
i = MsgBox("你确定要删除此记录吗?", vbYesNo + vbInformation, "删除记录")
If i = vbYes Then
rs.Delete
rs.MovePrevious
If rs.BOF Then rs.MoveFirst
display
End If
End SubPrivate Sub Cmdexit_Click()
Unload Me
End SubPrivate Sub cmdfind_Click()
Dim cnn2 As ADODB.Connection
Dim rs2 As ADODB.Recordset
Dim s As String
Set cnn2 = New ADODB.Connection
s = "select * from data_1 where id='" & Txtid.Text & "' ;"
cnn2.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn2.Open "D:\VB98\学生信息\data.mdb"
Set rs2 = New ADODB.Recordset
rs2.Open s, cnn2, adOpenDynamic
If rs2.EOF Or rs2.BOF Then MsgBox "无效ID号": Exit Sub
Do While Not rs2.EOF
If s = rs2!id Then
Txtid = rs2!id
txtname = rs2!Name
Txtadd = rs2!Add
Exit Do
End If
rs2.MoveNext
Loop
If rs2.EOF Then
Txtid = ""
txtname = ""
Txtadd = ""
MsgBox "没找到!" End If
End SubPrivate Sub Txtqdd_Change()End SubPrivate Sub Cmdsave_Click()
rs.AddNew
rs!id = Txtid
rs!Name = txtname
rs!Add = Txtadd
rs.Update
End SubPrivate Sub Codadd_Click() rs.AddNew
Txtid = ""
txtname = ""
Txtadd = ""
Txtid.SetFocus
End SubPrivate Sub Command1_Click()
rs.MoveFirst
display
End SubPrivate Sub Command2_Click()
rs.MovePrevious
If rs.BOF Then
MsgBox "到第一条记录"
rs.MoveFirst
End If
display
End SubPrivate Sub Command3_Click()
rs.MoveNext
If rs.EOF Then
MsgBox "到最后一条记录"
rs.MoveLast
End If
display
End SubPrivate Sub Command4_Click()
rs.MoveLast
display
End Sub
'激活窗口
Private Sub Form_Activate()
display
End Sub
'加载窗口
Private Sub Form_Load()
Dim addFlag As Boolean
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Open "D:\VB98\学生信息\data.mdb"
rs.Open "data_1", cnn, adOpenDynamic, adLockBatchOptimistic, adCmdTable
addFlag = False
End Sub
'显示记录
Private Sub display()
Txtid = rs!id
txtname = rs!Name
Txtadd = rs!Add
End Sub
'卸载窗体
Private Sub form_unload(cancel As Integer)
cnn.Close
End Sub
这个程序中~find和save是错误的`
请教高手`
这两个错在哪`
解决方案 »
- vsflexgrid控件 的问题
- 高分求解:由于您和其他用户试图同时改变同一数据,导致 Microsoft Jet 数据库引擎停止进程 ?
- 如何在vb中调用在access中的模块内建立的函数!急!
- 【问】如何让控件实现类似PictureBox的Align功能?(无需在调用窗体中编代码,只由控件自己实现!)
- 在OneForm窗体模块中定义如下:Public FormatForm As Boolean在TowMain窗体模块中应该怎么用这个全局变量?如果是Public FormatForm As
- Textbox 在win2000下与粘贴来自Excel的中文字,再复制回去就出现乱码?
- 久违了朋友们,100分帮我解决一个问题吧 ^_^
- 在WINXP下怎样用VB来屏蔽任务管理器具
- 讨论男程序员的性别问题
- 为什么Command对象返回的Recordset不支持AddNew
- 如何用VB把SQL2000中查询的结果导出为XML文件
- 能不能用SQL语句实现下面的显示格式
鄙视你这种人。
这样没人会帮你的。
应该诚恳,没分也会帮你的... ^^
坚决不帮
。。