Access 2000數據庫放在d:\paster\data.mdb中,執行到dr=cmd.ExecuteReader()句中出錯,錯誤提示如下:An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll下面是代碼:
private bool ValidateUser()
{
string strUsername=txtUserID.Text;
string strPassword=txtPassword.Text; string sql="select UserType from User where Username='"+strUsername+"' and Password='"+strPassword+"'"; OleDbConnection cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Paster\\Data.mdb");
OleDbCommand cmd=new OleDbCommand(sql,cn);
OleDbDataReader dr; cn.Open();
dr=cmd.ExecuteReader(); bool flag=false; while (dr.Read())
{
flag=true;
this.UserType=Convert.ToInt16(dr[0]);
} dr.Close();
cn.Close(); return flag;
}
private bool ValidateUser()
{
string strUsername=txtUserID.Text;
string strPassword=txtPassword.Text; string sql="select UserType from User where Username='"+strUsername+"' and Password='"+strPassword+"'"; OleDbConnection cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Paster\\Data.mdb");
OleDbCommand cmd=new OleDbCommand(sql,cn);
OleDbDataReader dr; cn.Open();
dr=cmd.ExecuteReader(); bool flag=false; while (dr.Read())
{
flag=true;
this.UserType=Convert.ToInt16(dr[0]);
} dr.Close();
cn.Close(); return flag;
}
using System.Data;
using System.Data.OleDb;
C#我不熟悉
1.将此句:string sql="select UserType from User where Username='"+strUsername+"' and Password='"+strPassword+"'";
改为:string sql="select UserType from [User] where Username='"+strUsername+"' and Password='"+strPassword+"'";
2.更改表名User为UserLogin,再更改SQL语句.