Question

未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。

我用VB.net2003写的登陆界面代码：
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Total As Integer
Dim StrConnApp = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & "setting.mdb"
Dim ConnTemp As New OleDb.OleDbConnection
Dim StrSQL As String
ConnTemp.ConnectionString = StrConnApp
StrSQL = "Select * From sjk Where [User]='" & TextBox1.Text & "' AND [Password]='" & TextBox2.Text & "'"
Dim CmdTemp As New OleDb.OleDbCommand(StrSQL, ConnTemp)
ConnTemp.Open()'这里有问题运行到这里就不能执行下去了
Total = CmdTemp.ExecuteScalar
If Total > 0 Then
MessageBox.Show("密码或用户名错误!", "错误提示!", MessageBoxButtons.OK, MessageBoxIcon.Error)

TextBox1.Text = ""

TextBox2.Text = ""

TextBox1.Focus()

End If

Answer 1

检查数据库连接字符串是否正确，再查SQL语句是否正确

Answer 2

数据库存在地址不对 <add name="HDianConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\HDian.mdb"
providerName="System.Data.OleDb" />