Spatacus 2014-12-15 12:11 采纳率: 0%
浏览 1946

用ADO控件编的一个简易学生成绩管理器,运行时显示找不到可安装的ISAM,求解决

Private Sub Command1_Click()
On Err GoTo MyErr
If Command1.Caption = "添加" Then
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Label1(6).Caption = ""
Command1.Caption = "保存"
Else
If ChkData Then
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("num") = Trim(Text1.Text)
Adodc1.Recordset.Fields("name") = Trim(Text2.Text)
Adodc1.Recordset.Fields("Lang") = Trim(Text3.Text)
Adodc1.Recordset.Fields("Math") = Trim(Text4.Text)
Adodc1.Recordset.Fields("Eng") = Trim(Text5.Text)
Adodc1.Recordset.Fields("scor") = Val(Text3.Text) + Val(Text4.Text) + Val(Text5.Text)
Adodc1.Recordset.Update
MsgBox "添加学生成绩信息成功!", vbOKOnly, "系统提示"
Command1.Caption = "添加"
End If
Exit Sub
MyErr:
MsgBox "添加学生成绩信息失败!", vbOKOnly, "系统提示"
End Sub

Private Sub Command2_Click()
On Err GoTo MyErr
If ChkData Then
Adodc1.Recordset("num") = Trim(Text1.Text)
Adodc1.Recordset("name") = Trim(Text2.Text)
Adodc1.Recordset("Lang") = Trim(Text3.Text)
Adodc1.Recordset("Math") = Trim(Text4.Text)
Adodc1.Recordset("Eng") = Trim(Text5.Text)
Adodc1.Recordset("scor") = Val(Text3.Text) + Val(Text4.Text) + Val(Text5.Text)
Adodc1.Recordset.Update
MsgBox "修改学生成绩信息成功!", vbOKOnly, "系统提示"
End If
Exit Sub
MyErr:
MsgBox "修改学生成绩信息失败!", vbOKOnly, "系统提示"
End Sub

Private Sub Command3_Click()
On Err GoTo MyErr
Adodc1.Recordset.Delete
MsgBox "删除记录成功!", vbOKOnly, "系统提示"
Exit Sub
MyErr:
MsgBox "删除记录失败,请重试!", vbOKOnly, "系统提示"
End Sub

Private Sub Command4_Click()
End
End Sub

Private Sub Form_Load()
Adodc1.Visible = False
lst.ColumnHeaders.Add , , "学号"
lst.ColumnHeaders.Add , , "姓名", , 2
lst.ColumnHeaders.Add , , "语文", , 2
lst.ColumnHeaders.Add , , "数学", , 2
lst.ColumnHeaders.Add , , "英语", , 2
lst.ColumnHeaders.Add , , "总成绩", , 2
lst.FullRowSelect = True
lst.GridLines = True
lst.LabelEdit = lvwManual
lst.View = lvwReport
Dim Li_RecCount As Integer
Dim Li_i As Integer
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\Data.mdb;Persist Security Info=False"
Adodc1.RecordSource = "select * from 成绩表"
Adodc1.Refresh
Li_RecCount = Adodc1.Recordset.RecordCount - 1
For Li_i = 0 To Li_RecCount
lst.ListItems.Add , , Adodc1.Recordset.Fields("num").Value
lst.ListItems.Item(Li_i + 1).SubItems(1) = Adodc1.Recordset.Fields("name").Value
lst.ListItems.Item(Li_i + 1).SubItems(2) = Adodc1.Recordset.Fields("lang").Value
lst.ListItems.Item(Li_i + 1).SubItems(3) = Adodc1.Recordset.Fields("math").Value
lst.ListItems.Item(Li_i + 1).SubItems(4) = Adodc1.Recordset.Fields("Eng").Value
lst.ListItems.Item(Li_i + 1).SubItems(5) = Adodc1.Recordset.Fields("scor").Value
Adodc1.Recordset.MoveNext
Next
Adodc1.Recordset.MoveFirst
End Sub

Private Sub lst_ItemClick(ByVal Item As MSComctlLib.ListItem)
Text1.Text = lst.SelectedItem.Text
Text2.Text = lst.SelectedItem.SubItems(1)
Text3.Text = lst.SelectedItem.SubItems(2)
Text4.Text = lst.SelectedItem.SubItems(3)
Text5.Text = lst.SelectedItem.SubItems(4)
Label1(6).Caption = lst.SelectedItem.SubItems(4)
End Sub

  • 写回答

2条回答

  • 全栈极简 博客专家认证 2014-12-15 14:26
    关注

    Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\Data.mdb;Persist Security Info=False"
    找不到可安装的ISAM,系统没有相应的ado驱动。要么换连接方式,要么装完整版的操作系统。

    评论

报告相同问题?

悬赏问题

  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog