Devart Forums

Code: Select all

public static bool CheckUserEmail(string useremail)
{
    string sql = "SELECT email FROM aspnet_membership WHERE email='" + useremail + "';";

    using (PgSqlConnection connection = ConnectionManager.GetConnection())
    {
        using (PgSqlCommand command = new PgSqlCommand(sql, connection))
        {
            command.CommandType = CommandType.Text;

            try
            {
                string rec = command.ExecuteScalar().ToString();

                if (rec == useremail)
                    return true;
                else
                    return false;
            }
            catch (Exception ex)
            {
                return false;
                throw ex;
            }
        }
    }
}

Code: Select all

Server Error in '/' Application.
current transaction is aborted, commands ignored until end of transaction block 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Devart.Data.PostgreSql.PgSqlException: current transaction is aborted, commands ignored until end of transaction block

Source Error: 

Line 23:         {
Line 24:             //Membership.CreateUser("g", "lami123");
Line 25:             Membership.DeleteUser("g");
Line 26: 
Line 27: 

Stack Trace:

[PgSqlException (0x80004005): current transaction is aborted, commands ignored until end of transaction block]
   Devart.Common.Web.Providers.DbMembershipProvider.DeleteUser(String username, Boolean deleteAllRelatedData) +144

[ProviderException: An exception occurred. Please contact your administrator.]
   Devart.Common.Web.Providers.DbMembershipProvider.DeleteUser(String username, Boolean deleteAllRelatedData) +215
   System.Web.Security.Membership.DeleteUser(String username) +75

Code: Select all

requiresUniqueEmail="true"