How to connect multiple custom login controls to single database different tables(sql)?
<p>There are 4 custom login controls on my web page. I need to connect them to different tables in a database. I have managed to connect one of the login controls to a table (below is the code for that). But now I'm not sure on how to connect the remaining controls to the database. If any one has any suggestions, I will be thankful.</p>

<pre><code>    protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {
        bool Authenticated = false;
        Authenticated = Authenticate(Login1.UserName, Login1.Password);
        e.Authenticated = Authenticated;
        if (Authenticated == true)
        {
            Response.Redirect("WebForm1.aspx");
        }
    }
    private bool Authenticate(string UserName, string Password)
    {
        bool boolReturnValue = false;
        string strConnection = "server=HP-PC\\SQL2K8;database=gaurav;uid=sa;pwd=VINIMANIA;";
        SqlConnection Connection = new SqlConnection(strConnection);
        String strSQL = "Select * From login";
        SqlCommand command = new SqlCommand(strSQL, Connection);
        SqlDataReader Dr;
        Connection.Open();
        Dr = command.ExecuteReader();
        while (Dr.Read())
        {
            if ((UserName == Dr["username"].ToString()) &amp; (Password == Dr["pass"].ToString()))
            {
                boolReturnValue = true;
            }



        }
        Dr.Close();
        return boolReturnValue;

    }
</code></pre>
