LoginControl VS 2005

[ceema]

Hello,

I have used Login Control for ASP.NEt with VS2005. I have followed the directions in the site
http://www.devx.com/asp/Article/29256
and converted the same for Oracle. It's working perfect in vb code behind. But the same I converted to C#
and it's showing erros like

1. OracleMembershipProvider.CreateUser(string, string, string, string, string, bool, object, ref System.Web.Security.MembershipCreateStatus)': no suitable method found to override
2. OracleMembershipProvider' does not implement inherited abstract member 'System.Web.Security.MembershipProvider.CreateUser (string, string, string, string, string, bool, object, out System.Web.Security.MembershipCreateStatus)'


There are 8 erros like this for GetALLUsers,FindUsersByEmail,FindUsersByName etc

Could any one help

Thanks Ceema


the following code

using System.Web.Security;
using System.Data;
using System.Data.OracleClient;
using System.Configuration;
using System.Web;
using System;
using System.Collections;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
 
/// <summary>
/// Summary description for AccessMembershipProvider
/// </summary>
public class OracleMembershipProvider : MembershipProvider
{
    private string connStr;
    private OracleCommand comm = new OracleCommand();
    private bool _requiresQuestionAndAnswer;
    private int _minRequiredPasswordLength;
 
    public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
    {
        if (config("requiresQuestionAndAnswer") == "true")
        {
            _requiresQuestionAndAnswer = true;
        }
        connStr = config("connectionString");
        base.Initialize(name, config);
    }
 
    public override string ApplicationName
    {
        get
        {
        }
        set
        {
        }
    }
 
    public override bool ChangePassword(string username, string oldPassword, string newPassword)
    {
    }
 
    public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)
    {
    }
 
    public override System.Web.Security.MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, ref System.Web.Security.MembershipCreateStatus status)
    {
        OracleConnection conn = new OracleConnection(connStr);
        try
        {
            conn.Open();
            string sql = "INSERT INTO XX_Test_Membership VALUES (" + "@username, @pwd, @email, " + " @passwordQuestion, @passwordAnswer )";
            OracleCommand comm = new OracleCommand(sql, conn);
            comm.Parameters.AddWithValue("@username", username);
            comm.Parameters.AddWithValue("@pwd", password);
            comm.Parameters.AddWithValue("@email", email);
            comm.Parameters.AddWithValue("@passwordQuestion", passwordQuestion);
            comm.Parameters.AddWithValue("@passwordAnswer", passwordAnswer);
            int result = comm.ExecuteNonQuery();
            conn.Close();
            status = MembershipCreateStatus.Success;
            MembershipUser user = new MembershipUser("AccessMembershipProvider", username, null, email, passwordQuestion, null, true, false, Now, null, null, null, null);
            return user;
        }
        catch (Exception ex)
        {
            status = MembershipCreateStatus.UserRejected;
            return null;
        }
    }
 
    public override bool DeleteUser(string username, bool deleteAllRelatedData)
    {
    }
 
    public override bool EnablePasswordReset
    {
        get
        {
        }
    }
 
    public override bool EnablePasswordRetrieval
    {
        get
        {
        }
    }
 
    public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
 
    }
 
    public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
    public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
    public override int GetNumberOfUsersOnline()
    {
    }
 
    public override string GetPassword(string username, string answer)
    {
    }
 
    public override System.Web.Security.MembershipUser GetUser(string username, bool userIsOnline)
    {
    }
 
    public override System.Web.Security.MembershipUser GetUser(object providerUserKey, bool userIsOnline)
    {
    }
 
    public override string GetUserNameByEmail(string email)
    {
    }
 
    public override int MaxInvalidPasswordAttempts
    {
        get
        {
        }
    }
 
    public override int MinRequiredNonAlphanumericCharacters
    {
        get
        {
        }
    }
 
    public override int MinRequiredPasswordLength
    {
        get
        {
        }
    }
 
    public override int PasswordAttemptWindow
    {
        get
        {
        }
    }
 
    public override System.Web.Security.MembershipPasswordFormat PasswordFormat
    {
        get
        {
        }
    }
 
    public override string PasswordStrengthRegularExpression
    {
        get
        {
        }
    }
 
    public override bool RequiresQuestionAndAnswer
    {
        get
        {
            if (_requiresQuestionAndAnswer == true)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
 
    public override bool RequiresUniqueEmail
    {
        get
        {
        }
    }
 
    public override string ResetPassword(string username, string answer)
    {
    }
 
    public override bool UnlockUser(string userName)
    {
    }
 
    public override void UpdateUser(System.Web.Security.MembershipUser user)
    {
    }
 
    public override bool ValidateUser(string username, string password)
    {
        OracleConnection conn = new OracleConnection(connStr);
        try
        {
            conn.Open();
            string sql = "Select * From XX_Test_Membership WHERE " + "UserName='" + username + "' AND PWD='" + password + "'";
            OracleCommand comm = new OracleCommand(sql, conn);
            OracleDataReader reader = comm.ExecuteReader;
            if (reader.HasRows)
            {
                return true;
            }
            else
            {
                return false;
            }
            conn.Close();
        }
        catch (Exception ex)
        {
            Console.Write(ex.ToString);
            return false;
        }
    }
}

[ceema]

Hello,

I have solved all those errors by changing the code as follows. But now I am getting the error like ( since the size of the post is restricted, I am avoiding some of the class file codes and posting as next reply)
Provider name cannot be null or empty.
Description: An unhandled exception occurred during the execution of the current web request....
Stack Trace:


[ArgumentException: Provider name cannot be null or empty.]
System.Web.Security.Membership.Initialize() +1068
System.Web.UI.WebControls.LoginUtil.GetProvider(St ring providerName) +33
System.Web.UI.WebControls.CreateUserWizard.get_Que stionAndAnswerRequired() +90
System.Web.UI.WebControls.CreateUserWizard.UpdateV alidators() +1134
System.Web.UI.WebControls.CreateUserWizard.CreateC hildControls() +32
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.WebControls.Wizard.OnInit(EventArgs e) +100
System.Web.UI.Control.InitRecursive(Control namingContainer) +346
System.Web.UI.Control.InitRecursive(Control namingContainer) +197
System.Web.UI.Control.InitRecursive(Control namingContainer) +197
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1795

***************************************My Code*****************************


In web.config

<membership defaultProvider="OracleMembershipProvider">
<providers>
<add  type="OracleMembershipProvider" requiresQuestionAndAnswer="true" connectionString="Data Source=erpudev;User Id=web_t_user;Password=oracle123;Integrated Security=no;" name="OracleMembershipProvider"/>
</providers>
</membership>
 
in class file
 
using System.Web.Security;
using System.Data;
using System.Data.OracleClient;
using System.Configuration;
using System.Web;
using System;
using System.Collections;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
 
 
/// <summary>
/// Summary description for AccessMembershipProvider
/// </summary>
public class OracleMembershipProvider : MembershipProvider
{
    private string connStr;
    private OracleCommand comm = new OracleCommand();
    private bool _requiresQuestionAndAnswer;
    private int _minRequiredPasswordLength;
 
    public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
    {
        //if (config("requiresQuestionAndAnswer") == "true")
        //{
        //    _requiresQuestionAndAnswer = true;
        //}
        //connStr = config("connectionString");
        //base.Initialize(name, config);
    }
 
    public override string ApplicationName
    {
        get { throw new NotSupportedException(); }
        set { throw new NotSupportedException(); }
 
    }
 
    public override bool ChangePassword(string username, string oldPassword, string newPassword)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
    public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
 
 
    public override MembershipUser CreateUser(string username, string
          password, string email, string passwordQuestion, string
          passwordAnswer, bool isApproved, object providerUserKey,
          out MembershipCreateStatus status)
    {
        OracleConnection cnn = null;
        OracleCommand cmd = null;
        MembershipUser newUser = null;
        try
        {
            cnn = new OracleConnection();
            cnn.ConnectionString = connStr;
            cnn.Open();
            string insertQry = "INSERT INTO XX_Test_Membership VALUES (" + "@username, @pwd, @email, " + " @passwordQuestion, @passwordAnswer )";
            cmd = new OracleCommand(insertQry, cnn);
            cmd.ExecuteNonQuery();
 
            // Right now I am giving default values for DateTime
            // in Membership constructor.
            newUser = new MembershipUser("OracleMembershipProvider", username, null, String.Empty, String.Empty, String.Empty, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
            status = MembershipCreateStatus.Success;
        }
        catch (Exception ex)
        {
            status = MembershipCreateStatus.ProviderError;
            newUser = null;
            throw ex;
        }
        finally
        {
            cmd.Dispose();
            cnn.Close();
        }
        return newUser;
    }
 
    /*public override System.Web.Security.MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, ref System.Web.Security.MembershipCreateStatus status)
    //public void  CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, ref System.Web.Security.MembershipCreateStatus status)
    {
        OracleConnection conn = new OracleConnection(connStr);
        try
        {
            conn.Open();
            string sql = "INSERT INTO XX_Test_Membership VALUES (" + "@username, @pwd, @email, " + " @passwordQuestion, @passwordAnswer )";
            OracleCommand comm = new OracleCommand(sql, conn);
            comm.Parameters.AddWithValue("@username", username);
            comm.Parameters.AddWithValue("@pwd", password);
            comm.Parameters.AddWithValue("@email", email);
            comm.Parameters.AddWithValue("@passwordQuestion", passwordQuestion);
            comm.Parameters.AddWithValue("@passwordAnswer", passwordAnswer);
            int result = comm.ExecuteNonQuery();
            conn.Close();
            status = MembershipCreateStatus.Success;
            MembershipUser user = new MembershipUser("AccessMembershipProvider", username, null, email, passwordQuestion, null, true, false, Now, null, null, null, null);
            return user;
        }
        catch (Exception ex)
        {
            status = MembershipCreateStatus.UserRejected;
            return null;
        }
    }*/
 
    public override bool DeleteUser(string username, bool deleteAllRelatedData)
    {
        throw new Exception("The method or operation is not implemented.");
    }
 
    public override bool EnablePasswordReset
    {
        get { return false; }
 
    }
 
    public override bool EnablePasswordRetrieval
    {
        get { return false; }
 
    }

[ceema]

Balance code

 public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }
    public override MembershipUserCollection FindUsersByEmail(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }
    public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }
   /* //public void FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, ref int totalRecords)
    public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
 
    }*/
 
    /*public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }*/
 
   /* public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, ref int totalRecords)
    {
        throw new Exception("The method or operation is not implemented.");
    }*/
 
    public override int GetNumberOfUsersOnline()
    {
        throw new NotSupportedException();
    }
 
    public override string GetPassword(string username, string answer)
    {
        throw new NotSupportedException();
    }
 
    public override System.Web.Security.MembershipUser GetUser(string username, bool userIsOnline)
    {
        throw new NotSupportedException();
    }
 
    public override System.Web.Security.MembershipUser GetUser(object providerUserKey, bool userIsOnline)
    {
        throw new NotSupportedException();
    }
 
    public override string GetUserNameByEmail(string email)
    {
        throw new NotSupportedException();
    }
 
    public override int MaxInvalidPasswordAttempts
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override int MinRequiredNonAlphanumericCharacters
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override int MinRequiredPasswordLength
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override int PasswordAttemptWindow
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override System.Web.Security.MembershipPasswordFormat PasswordFormat
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override string PasswordStrengthRegularExpression
    {
        get { throw new NotSupportedException(); }
 
 
    }
 
    public override bool RequiresQuestionAndAnswer
    {
        get
        {
            if (_requiresQuestionAndAnswer == true)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
 
    public override bool RequiresUniqueEmail
    {
        get { return false; }
 
    }
 
    public override string ResetPassword(string username,string answer)
    {
        throw new NotSupportedException();
    }
 
 
    public override bool UnlockUser(string userName)
    {
        throw new NotSupportedException();
 
    }
 
    public override void UpdateUser(System.Web.Security.MembershipUser user)
    {
    }
 
    public override bool ValidateUser(string username, string password)
    {
        OracleConnection conn = new OracleConnection(connStr);
        try
        {
            conn.Open();
            string sql = "Select * From XX_Test_Membership WHERE " + "UserName='" + username + "' AND PWD='" + password + "'";
            OracleCommand comm = new OracleCommand(sql, conn);
            OracleDataReader reader = comm.ExecuteReader();
            if (reader.HasRows)
            {
                return true;
            }
            else
            {
                return false;
            }
            conn.Close();
        }
        catch (Exception ex)
        {
            Console.Write(ex.ToString());
            return false;
        }
 
 
    }
}

[ceema]

Hello All,

I got the reason for the error, I have blocked the lines

connStr = config["connectionString"];
base.Initialize(name, config);


in


System.Collections.Specialized.NameValueCollection config)


Thanks
Ceema
public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
{
//if (config("requiresQuestionAndAnswer") == "true")
//{
// _requiresQuestionAndAnswer = true;
//}
connStr = config["connectionString"];
base.Initialize(name, config);
}

[kenobewan]

So do you need help with the connection string?

[karthiktss]

hi

i try to create membershipprivoder.at run time i getting this type error, find the solution for this error.

Errors

1.'sqlAccessMembershipProvider.CreateUser(string, string, string, string, string, bool, object, ref System.Web.Security.MembershipCreateStatus)': no suitable method found to override

2.'sqlAccessMembershipProvider' does not implement inherited abstract member 'System.Web.Security.MembershipProvider.CreateUser (string, string, string, string, string, bool, object, out System.Web.Security.MembershipCreateStatus)'


Coding

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Collections.Generic;
using System.Web.UI.WebControls;
using System.Web.UI;
using System.Web;
using System.Web.Security;
using System.Web.Caching;


public class sqlAccessMembershipProvider :MembershipProvider
{
//---for database access use---
private string connStr;
//private OleDb.OleDbCommand comm = new OleDb.OleDbCommand();
private SqlCommand comm = new SqlCommand();

private bool _requiresQuestionAndAnswer;
private int _minRequiredPasswordLength;

public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
{

//===retrives the attribute values set in
//web.config and assign to local variables===

if (config("requiresQuestionAndAnswer") == "true")
_requiresQuestionAndAnswer = true;

connStr = config("connectionString");
base.Initialize(name, config);
}

public override string ApplicationName
{
get { }
set { }
}

public override bool ChangePassword(string username, string oldPassword, string newPassword)
{

}

public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)
{
}
public override System.Web.Security.MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, ref System.Web.Security.MembershipCreateStatus status)
// public override bool CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, ref MembershipCreateStatus status)
{
SqlConnection conn = new SqlConnection(connStr);
// OleDb.OleDbConnection conn = new OleDb.OleDbConnection(connStr);
//----perform checking all the relevant checks here
// and set the status of the error accordingly, e.g.:
//status = MembershipCreateStatus.InvalidPassword
//status = MembershipCreateStatus.InvalidAnswer
//status = MembershipCreateStatus.InvalidEmail

//---add the user to the database
try
{
conn.Open();
string sql = "INSERT INTO Membership VALUES (" + "@username, @password, @email, " + " @passwordQuestion, @passwordAnswer )";
OleDb.OleDbCommand comm = new OleDb.OleDbCommand(sql, conn);
comm.Parameters.AddWithValue("@username", username);
comm.Parameters.AddWithValue("@password", password);
comm.Parameters.AddWithValue("@email", email);
comm.Parameters.AddWithValue("@passwordQuestion", passwordQuestion);
comm.Parameters.AddWithValue("@passwordAnswer", passwordAnswer);
int result = comm.ExecuteNonQuery();
conn.Close();
status = MembershipCreateStatus.Success;
MembershipUser user = new MembershipUser("AccessMembershipProvider", username, null, email, passwordQuestion, null, true, false, Now, null,
null, null, null);
return user;
}
catch (Exception ex)
{
//---failed; determine the reason why
status = MembershipCreateStatus.UserRejected;
return null;
}
}

public override bool DeleteUser(string username, bool deleteAllRelatedData)
{

}

public override bool EnablePasswordReset
{

get { }
}

public override bool EnablePasswordRetrieval
{

get { }
}

//public override System.Web.Security.MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, ref int totalRecords)
//{

//}

//public override System.Web.Security.MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, ref int totalRecords)
//{

//}

//public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, ref int totalRecords)
//{

//}

public override int GetNumberOfUsersOnline()
{

}

public override string GetPassword(string username, string answer)
{

}

public override System.Web.Security.MembershipUser GetUser(string username, bool userIsOnline)
{

}

public override System.Web.Security.MembershipUser GetUser(object providerUserKey, bool userIsOnline)
{

}

public override string GetUserNameByEmail(string email)
{

}

public override int MaxInvalidPasswordAttempts
{

get { }
}

public override int MinRequiredNonAlphanumericCharacters
{

get { }
}

public override int MinRequiredPasswordLength
{

get { }
}

public override int PasswordAttemptWindow
{

get { }
}

public override System.Web.Security.MembershipPasswordFormat PasswordFormat
{

get { }
}

public override string PasswordStrengthRegularExpression
{

get { }
}

public override bool RequiresQuestionAndAnswer
{
get
{
if (_requiresQuestionAndAnswer == true)
{
return true;
}
else
{
return false;
}
}
}

public override bool RequiresUniqueEmail
{

get { }
}

public override string ResetPassword(string username, string answer)
{

}

public override bool UnlockUser(string userName)
{

}

public override void UpdateUser(System.Web.Security.MembershipUser user)
{

}

public override bool ValidateUser(string username, string password)
{
OleDb.OleDbConnection conn = new OleDb.OleDbConnection(connStr);
try
{
conn.Open();
string sql = "Select * From Membership WHERE " + "username=@username AND password=@password";
OleDb.OleDbCommand comm = new OleDb.OleDbCommand(sql, conn);
comm.Parameters.AddWithValue("@username", username);
comm.Parameters.AddWithValue("@password", password);
OleDb.OleDbDataReader reader = comm.ExecuteReader;
if (reader.HasRows)
{
return true;
}
else
{
return false;
}
conn.Close();
}

catch (Exception ex)
{
Console.Write(ex.ToString);
return false;
}
}

public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
{
throw new Exception("The method or operation is not implemented.");
}

public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
throw new Exception("The method or operation is not implemented.");
}

public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
throw new Exception("The method or operation is not implemented.");
}
}