SQL Server :: Stored Procedure To Create Log In Page?

create procedure edifyp
(
@firstname varchar(50),
@lastname varchar(50),
@Username varchar(50),
@password varchar(50),
@cpassword varchar(50)
)
as insert into esignup
(
[firstname],
[lastname],
[username],
[password],
[cpassword]
)
values
(
@firstname ,
@lastname ,
@Username ,
@password ,
@cpassword
)

this is my sign up page store procedure, and i have created sign up page, its already runs very well,

but i am a begineer, and i am learning my self. so i need to get the user name from this table as well password to log in with these datails,

ahow can i write stored procedure for log in page, and what shuld i have to do inside the login button contol