performing multiple queries on a single click

Hi this i s my code to check the username and password for a login page..If it is vallidated it should be redirected to default3.aspx page and i have used it inside a if loop and have used stored procedure.   
protected void Button1_Click1(object sender, EventArgs e)
    {
        SqlConnection myConnection = new SqlConnection(connectionString);
        myConnection.Open();
        SqlCommand cmd = new SqlCommand(
              "getvalues",myConnection);
      
    
       
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new Sql ...