There are a lot of SQL connections on the Internet login authentication, but no Oracle connection way, I groped a morning to write this executable function, share to everyone
Copy Code code as follows:
//user logon Check
public bool Logincheck (string f_loginname, String f_loginpass)
{
bool result = FALSE;
//Regular expression Check
if (Regex.IsMatch (f_loginname,@ "^[a-za-z0-9]{1,15}$") && Regex.IsMatch (f_loginpass,@ "^[") a-za-z0-9]{1,15}$ "))
{
OracleConnection objconn = new OracleConnection ( configurationmanager.connectionstrings["ConnectionString"]. ConnectionString);
OracleCommand objcmd = new OracleCommand ("SELECT * from USERS where username=:p username and password=:p password", OBJC Onn);
ObjCmd.Parameters.Add ("Pusername", oracledbtype.varchar2). Value = F_loginname;
ObjCmd.Parameters.Add ("Ppassword", oracledbtype.varchar2). Value = F_loginpass;
objConn.Open ();
OracleDataReader objdr = Objcmd.executereader ();
//Read content
if (Objdr.read ())
{
result = true;
}
//Close Database
Objdr.close ();
Objconn.close ();
}
return result;
}