How to connect my ASP.NET using c# with Microsoft sql server 2000?

[ernest joel]

When i click this button connection should establish ...
my coding is

 protected void Button1_Click(object sender, EventArgs e)
    {
        cn.Open();
        cmd.Connection = cn;
 
            cmd.CommandText = "select user,pass from register where user_id='" & TextBox1.Text & "' and password='" & TextBox2.Text & "'";
            s = cmd.ExecuteReader();
            If s.Read(); Then
                Response.redirect("Login.aspx");
            Else
                Response.Write("invalid username or password");
            End If
 
        cn.Close();
 
}

[Markus]

So, what is your question?

[ernest joel]

was my coding correct if so what i have to do next .. if my coding is wrong where i have to change my coding

[Markus]

Well, does it work?