code for login table

Subin Thomas

i have a login table which has

UserID UserName Password OrgID RoleID Count Lastlogin

123 lab1 svkLRj9nYEgZo7gWDJD5IQ== 5 1 0 NULL

and so on i have designed a form which has username and pasword i want to write a code in c# with sql query that if you pur credential from login table then new page to be displayed

thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
view
controller level
public ActionResult(string username,string password)
{

// in username and password you will get data which is posted from form
sql query :- select * from usertable where username=@username and password =@password
//if query return results means
redirect to dashboard else say invalid credentials
}
Sanwar Ranwa7y ago
Hello

Check these Links

https://www.c-sharpcorner.com/article/how-to-create-login-page-in-asp-net-web-application-using-c-sharp-and-sql-server/

https://www.c-sharpcorner.com/UploadFile/009464/simple-login-form-in-Asp-Net-using-C-Sharp/

You can also create a stor proc in sql and then use it

https://www.c-sharpcorner.com/UploadFile/0c1bb2/login-page-in-Asp-Net-C-Sharp-web-application-using-stored-proce/

https://www.c-sharpcorner.com/uploadfile/abhikumarvatsa/simple-login-project-using-stored-procedures-in-Asp-Net-part-2/
Salman Beg7y ago
Hi. You can follow up with this article and which contains exactly what you want, https://www.c-sharpcorner.com/UploadFile/0c1bb2/login-page-in-Asp-Net-C-Sharp-web-application-using-stored-proce/ . Thanks.