下面代碼為何執行出錯?
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;
}