code for login table

Question

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

Madan Shekar · Answer

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 Ranwa · Answer

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 Beg · Answer

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.