How to create Login page

First you need tho choose a membership provider. Let's assume you choose SQL based one, that's shipped with the framework. You can read about it here: Using SQL Membership with ASP.NET Application[^]; than you need to follow the steps described here: http://msdn.microsoft.com/en-us/library/ff649314.aspx[^] to configure and use the provider.

Alternatively read this article: http://www.aspfree.com/c/a/.NET/Creating-ASPNET-Login-Web-Pages-and-Basic-Configuration-/[^]

it can be declare globaly

SqlConnection con;
    SqlCommand cmd;
    SqlDataReader dr;
    int flag = 0;
    string s1, s2, uname, upass;

write code on btton click event it shoud be great helpful

 con = new SqlConnection("Data Source=.; Initial Catalog=krishna; Integrated Security =true;");
            con.Open();
            cmd = new SqlCommand("select *from register", con);
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                uname = dr[2].ToString();
                upass = dr[3].ToString();

                //if (s1.Equals(uname) && (s2.Equals(upass)))
                if (s1 == uname && s2 == upass)
                {
                    flag = 1;
                    break;

                }

            }
            if (flag == 1)
            {
                Server.Transfer("Welcometest.aspx?uname=+"+s1+""); 
                //Response.Redirect("WelcomeStudent.aspx");

            }
            else
            {
                Label3.Visible = true;
            }

in this code equire database file to match the database and go to the next page