OracleDataReader reader = cmd.ExecuteReader();
程序运行的时候提示表不存在。可是我在数据库里面可以查出数据。 代码如下:
private void sure_Login(object sender, EventArgs e)
{
string userName = this.userName.Text.ToString().Trim();
string userPwd = this.userPwd.Text.ToString().Trim();
if (userName == "" || userPwd == ""|| this.comboBoxRol.SelectedIndex==-1)
{
MessageBox.Show("用户名,密码,登录的身份不能为空");
}
//读取配置文件中得连接字符
// string connstring = ConfigurationManager.ConnectionStrings["benoraclConn"].ConnectionString;
//创建连接对象
OracleConnection conn = new OracleConnection();
// conn.ConnectionString = connstring;
conn.ConnectionString = "server=bigben;User ID=system;Password=ben123";
conn.Open();
MessageBox.Show("lianjiechenggong ");
OracleCommand cmd = new OracleCommand();
cmd.Connection=conn;//指定用conn连接数据库
cmd.CommandText = "select userName, userPwd from user_talbe where userName=:name";
OracleParameter pare = new OracleParameter(":name", userName);
cmd.Parameters.Add(pare);
OracleDataReader reader = cmd.ExecuteReader();这里报错 if(!reader.HasRows)
{
MessageBox.Show("您输入的账户不存在!");
}
else
{
while(reader.Read())//一行
{
//有数据,并取出来
string user = reader[0].ToString();//一行的一列
string pwd=reader[1].ToString();
if(pwd==userPwd)
{
string role = comboBoxRol.SelectedItem.ToString();
FormMain userlog = new FormMain(role, this, skinLog, userName, userPwd);
userlog.Show();
this.Hide();
}
else
{
MessageBox.Show("密码不正确!请重试!");
}
}
}
conn.Close();
}
}
}