iwant to do authencation for multi user and deny any user to enter to site whithout pass throw log in page

See more:

C#3.0

C#

ASP.NET

iwant to do authencation for multi user and deny any user to enter to site whithout pass throw log in page
add security to may site and deny any user pass to site pages without pass login page]\
the answe very beutiful and i ahave many ready code


but i want from you code if we but deny user no body can enter i want to create new user

and mke hime enter and the name of user stored in data base

and
iwill but may code


SqlConnection c;
SqlCommand m;
SqlDataReader r;

public void get_con()
{
c = new SqlConnection();
c.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\pard.mdf;Integrated Security=True;User Instance=True";
}

protected void Page_Load(object sender, EventArgs e)
{
get_con();
}


protected void Button1_Click(object sender, EventArgs e)
{


m = new SqlCommand();
c.Open();
m.Connection = c;

m.Parameters.Add("@a", TextBox2name.Text);
m.CommandText = "select [prd] from [user] where nam=@a";


r = m.ExecuteReader();
if (r.HasRows == false)
Response.Write("rrrrr");
if (r.Read())
{
if (r["prd"].ToString() == TextBox1pard.Text.Trim())
{
Response.Redirect("WebForm6.aspx");
}

}
else
{
Response.Write("wrong prd");
}
c.Close();




}