check Security question right or wrong as per combo selection

Question

0.00/5 (No votes)

See more:

Hi,
I want to check users selected security question and answer is matched with its database value which he is stores in sql server at the time registration.
Thank you,

Posted 2-Sep-12 18:43pm

indrajeet jadhav

Add a Solution

Comments

pradiprenushe 3-Sep-12 1:05am

What is problem then?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Answer 1 · 2012-09-02T19:08:00

Solution 1

Hi,

I understand what you want to do. but you also need to show what you have done so far. Anyway,

In your UserMaster table, you can create one flag(IsSecurityQuestionEnabled) indicating if user have checked Security Question or not. If so, you can create one another table(UserSecurityQuestion) with information about Question and Answer of that user.

While any user would like to change his/her password, you can prompt for Security question depending upon the flag you have defined in your UserMaster table.

For matching your security question and answer, you can write one StoredProcedure. StoredProcedure should contains all those select statements for matching security IsSecurityQuestionEnabled flag and UserSecurityQuestion table information for that user.

Hoe you got your required information.
Thanks
-Amit Gajjar

Posted 2-Sep-12 19:08pm

AmitGajjar

Comments

indrajeet jadhav 7-Sep-12 7:26am

yes sir..i write here 1 store proc .i pass parameter 'SecurityQuestion' and 'Answer' here but its still nt wrkng.

AmitGajjar 7-Sep-12 7:27am

can you post your sp code by improving questoin?

indrajeet jadhav 7-Sep-12 7:32am

ALTER PROCEDURE dbo.SelectSecurityQueAndAnswerFromUserDetails

(
@SecurityQuestion nvarchar(MAX),
@Answer nvarchar(50)
)

AS
select * from UserDetails where(SecurityQuestion=@SecurityQuestion and Answer=@Answer)
RETURN

AmitGajjar 7-Sep-12 7:34am

Instead of returning select query return count of the selected rows. if it returns 1 then success otherwise fail.

indrajeet jadhav 7-Sep-12 7:34am

and the code i write a method here...
public DataTable SelectSecurityQueAndAns()
{
DataTable dtCheckSecQue = new DataTable();
DAL.UserDetailTableAdapters.SelectSecurityQueAndAnswerFromUserDetailsTableAdapter objCheckSec = new DAL.UserDetailTableAdapters.SelectSecurityQueAndAnswerFromUserDetailsTableAdapter();
try
{
//dtCheckSecQue = objCheckSec.SelectSecurityQueAndAnswerFromUserDet(UserId);
dtCheckSecQue = objCheckSec.SelectSecurityQueAndAnswerFromUserDet(SecurityQuestion,Answer);
}
catch (Exception ex)
{

BAL.ExceptionLogger.LogInfo(ex);
}
return dtCheckSecQue;
}

indrajeet jadhav 7-Sep-12 7:35am

yes sir i write here IsActive 1 at the end of procedure.