oledb连接sql server2000出错?急!!!!!!!!!
string Sql = null;
Conn.Open();
UserName = ChangeHope_fc.newstr(this.username.Value.ToString());
Pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(ChangeHope_fc.newstr(this.password.Value.ToString()), "md5 ");
Sql = "select * from YX_Manage where YX_AdminUser=@YX_AdminUser and YX_Pwd=@YX_Pwd and YX_Stat=0 ";
OleDbCommand Comm = new OleDbCommand(Sql, Conn);
Comm.Parameters.Add(new OleDbParameter( "@YX_AdminUser ", OleDbType.VarChar, 8));
Comm.Parameters[ "@YX_AdminUser "].Value = UserName;
Comm.Parameters.Add(new OleDbParameter( "@YX_Pwd ", OleDbType.VarChar, 50));
Comm.Parameters[ "@YX_Pwd "].Value = Pwd;
int Count = Convert.ToInt32(Comm.ExecuteScalar());
OleDbCommand Comm = new OleDbCommand(Sql, Conn);
OleDbDataReader dr = Comm.ExecuteReader();
这样写会出现必须声明@YX_AdminUser的错误(注:跑access不会错)
但是直接写sql执行跑sql server2000又不错
Sql = "select * from YX_Manage where YX_AdminUser= ' " + UserName + " ' and YX_Pwd= ' " + Pwd + " ' and YX_Stat=0 ";
这到底是为什么 高手指点
[解决办法]
OleDbCommand就是为了跑access，
跑sql用sqlcommand
