login coding to store in sql server ?

have you done with registeration or signup first??


okie at login page..



the logic behind this is to get the value of the username entered in the textbox for username..


if you have used properties..

to get and set the value..


get the value from the textbox to the property and pass that value of username to the database


at the backend sqlserver


write query to select the rows where username=(the parameter passed from the textbox)


query wil be like dis..


select * from tablename where user_name=@user_name


this will return the rows..

fill it in the datatable.

check if the datatable has rows or not..

if not then print the message "Invalid username/password"

and if the datatable has the rows then check whether the password entered by the user matches wid the password returned from the datatable...


if yes then redirect it to home page for further functioning.

or print the message "invalid username/password"

i have told you about the logic..



at least i have given you the logic

but some people around here do not want to waste their time..

and only answer when they want to abuse the one who has answered the question..


so rest on you wat u want to do..



everyone knows.. who is the retard here :laugh:


thanks regards :)

richards...

The advice you have been given is very bad, and not secure at all. You should NEVER return the correct password from the data layer. You should make the data layer check if the password you were given was correct.'

Beyond that, the other reply was correct, there's no actual question here. This is a forum for programmers, which means, people who write code, and then need help with it. If you don't know how to write code at all, consider paying someone to write it for you.

I am not interested in fighting with retards. I respect that someone took the time to answer, I am just making a point to refine that answer. Never do a select * on your password table, always do a select count(*) and have your DB check the password that was entered.