private void but_login_Click(object sender, EventArgs e)
{
string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\xx.mdb;Persist Security Info=False ";
OdbcCommand comm = new OdbcCommand();
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = constring;
comm.Connection = conn;
conn.Open();
comm.CommandText = "select * from user where user_name="+teb_username.Text +"and user_password="+teb_password.Text;
OdbcDataReader reader = new OdbcDataReader();
reader = comm.ExecuteReader();
if (reader.HasRows)
{
label1.Text = "yes";
}
else
label1.Text = "no";
}代码如上,但是在OdbcDataReader reader = new OdbcDataReader();上出错,提示信息是:
system.data.odbc.odbcdatareader 未定义构造函数。谢谢指教
{
string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\xx.mdb;Persist Security Info=False ";
OdbcCommand comm = new OdbcCommand();
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = constring;
comm.Connection = conn;
conn.Open();
comm.CommandText = "select * from user where user_name="+teb_username.Text +"and user_password="+teb_password.Text;
OdbcDataReader reader = new OdbcDataReader();
reader = comm.ExecuteReader();
if (reader.HasRows)
{
label1.Text = "yes";
}
else
label1.Text = "no";
}代码如上,但是在OdbcDataReader reader = new OdbcDataReader();上出错,提示信息是:
system.data.odbc.odbcdatareader 未定义构造函数。谢谢指教
reader = comm.ExecuteReader();这两句话,改成:OdbcDataReader reader = comm.ExecuteReader();