MySql.Data.MySqlClient.MySqlCommand.ExecuteReader C# (CSharp) Method

ExecuteReader() public method

public ExecuteReader ( ) : MySqlDataReader
return MySqlDataReader
		public new MySqlDataReader ExecuteReader()
		{
			return ExecuteReader(CommandBehavior.Default);
		}

Same methods

MySqlCommand::ExecuteReader ( CommandBehavior behavior ) : MySqlDataReader

Usage Example

コード例 #1
1
        public static bool validateLogin(UserLog ul)
        {
            DBConnector dbcon = new DBConnector();
            dbcon.openConnection();

            //try {

            MySqlCommand cmd = new MySqlCommand();
            cmd.CommandText = "SELECT * FROM user WHERE username='******' AND password=MD5('" + ul.getPassword() + "')";
            cmd.Connection = dbcon.connection;

            MySqlDataReader login = cmd.ExecuteReader();

            if (login.Read())
            {
                LoginSession.setSession(login.GetString("iduser"));

                //login.Close();
                dbcon.closeConnection();
                return true;
            }
            else
            {
                //login.Close();
                dbcon.closeConnection();
                return false;
            }
            //}
            //catch (MySqlException e){
            //int errorcode = e.Number;
            //return false;
            //}
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlCommand::ExecuteReader