Extract role from database based on credentials by user

Question

Hi I want to extract roles from database and redirect user to other page based on the role i extract after user logs in. So if role is admin then he will be redirected to some page and if role is user he will be redirected to some other page. My question is how to write select query where i will compare username and password provided by user. Thanks in advance for help

Akhil Garg · Answer

If your table contains usernamepassword and role then Select dbo.Role from Users Where Username=@inusername and password=@inpasswordif user exists it will return role else it will not return anything