login details has to be store in backend

Question

0.00/5 (No votes)

See more:

hello sir/madam,

how to store login details like username and password in database i.e in sqlserver.
if the user is already exists then it has to be login and show the page.if user does not exit then it has to show msg.and if want want to create a new user login details, then we have to create it and that new login detais also has to be store in backend sqlserver

Posted 15-Dec-11 18:11pm

Member 8493183

Add a Solution

5 solutions

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)

srinivas vadepally · Answer 1 · 2011-12-15T19:11:00

Solution 2

Hi,
Click Here[^]

Posted 15-Dec-11 19:11pm

srinivas vadepally

raj ch · Answer 2 · 2011-12-15T22:21:00

Solution 4

Go through this link it will help u

http://www.daniweb.com/software-development/csharp/threads/24148[^]

Posted 15-Dec-11 22:21pm

raj ch

Not Active · Answer 3 · 2011-12-15T18:17:00

Solution 1

Create the database with this http://msdn.microsoft.com/en-us/library/ms229862(v=vs.80).aspx[^]
Then use ASP.NET membership provider

Posted 15-Dec-11 18:17pm

Not Active

koolprasad2003 · Answer 4 · 2011-12-15T19:32:00

Basic Question. This is login functionality of any project.
you can customize you code or use readymade controls of asp.net. check out, ASP.NET login controls[^]

Before storing your username and password to database you can encrypt with different security algorithms. Use a cryptographically secure random number generator.
you can take help of this article. The Art & Science of Storing Passwords[^]

Vasim889 · Answer 5 · 2011-12-15T22:46:00

VB

//first check a user nmae in table after insert
//this is sample code for checking username available
// u write code for txtname_textchanged event for (check user name available) 
dim sql as string=string.empty
dim result as integer
dim conn as new sqlconnection="connection string"
sql="select count(*) username from table where username='" &txtname.text &"'"
with cmd
.connection=conn
.commandtype=command.text
.commandtext=sql
.selectcommand
end with
i=cmd.executescalar(sql)
if i=0 then
//this area for new  insert usernmae and password
else
msgbox("user name already available")

end if