Can any one explain me how to use login control to check username and password stored in sql server database. if login is succesful how can i retrive some value.

Please provide me code also, if u can. Urgent.

/Bindu

 

The Login control will by default use the Membership API to validate a user aginast a datasource (By default a Sql provider is used).

If you don't want to use the Memberhip and instead use your own code (I should probably create my own Membership provider and still use the Membership feature) you can hook up to the Authenticate event of the Login control and add your own validation logic. Make sure to set the event argument's Authenticate property to true. Within the Authenticate event you can also write your code to get retrive som value from your datasource, you can also use the LoggedIn event to add some code that should be called after a user is logged in.

hi!
here is some example:

 protected void Login1_Authenticate( object sender, AuthenticateEventArgs e )
    {
        e.Authenticated = eLibraryUtils.loginUser( Login1.UserName, Login1.Password );
    }

and the eLibraryUtils.loginUser() :

public static bool loginUser( string user_name, string password )
    {
        bool result = false;
        SqlConnection conn = new SqlConnection( ConfigurationManager.ConnectionStrings [ "eBConnectionString" ].ConnectionString );

        try
        {
            SqlCommand cmd = new SqlCommand( "check_user", conn );
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter param = cmd.Parameters.Add( "@user_name", SqlDbType.VarChar, 20 );
            param.Value = user_name;
            param = cmd.Parameters.Add( "@pass", SqlDbType.VarChar, 20 );
            param.Value = password;
            SqlParameter user_id = cmd.Parameters.Add( "@user_id", SqlDbType.Int );
            user_id.Direction = ParameterDirection.Output;
            conn.Open();
            cmd.ExecuteNonQuery();
            if(Convert.IsDBNull( user_id.Value ))
                return false;
            result = Convert.ToBoolean( user_id.Value );
        }
        finally
        {
            conn.Close();
        }

        return result;
    }

hope it helps

orzeh

 

It is working now. Thanks all for your support.