ASP.Net(C#)-Simple Login

[learner.11]

hi friends

I need to learn asp.net (c#) web application.
I need to create a very simple login page with 2 textboxes(userid,password) and one button for submit.Given userid -Admin,password-Admin
If login is successful,it has to redirect to another page ,else it shows a error message says,Login failure!

I believe this is the way,the 5 steps down,But I am not much congident in this code and logic.Can anyone check and give me feedback!!!

I am not good at C# coding,im new to this.

1.I created a ASP.Net webapplication called Sampleportal ,and in the form called Login.aspx ,put 2 textbox controls,1 botton,4 labels (2 extra for error msgs).

2.Create one more new form,Register.aspx,If login is successful.

3.Databse

Made a table Usertbl in the databse Northwind.

CREATE TABLE Usertbl
(UserID INT IDENTITY(1,1) NOT NULL,
UserName VARCHAR(50) NOT NULL,
Password VARCHAR(50) NOT NULL)

INSERT INTO Usertbl
(UserName, Password)
VALUES ('Admin', 'Admin')

please reply ,for me to correct and improve !