如何用登录控件连接aspnetdb数据库用户表？

<asp:Login ID="Login1" runat="server" DestinationPageUrl="~/Default.aspx" 
    OnAuthenticate="Login1_Authenticate">
</asp:Login>

protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
    string connectionString = "your_connection_string"; // 替换为实际的连接字符串
    string username = Login1.UserName;
    string password = Login1.Password;

    // 验证用户名和密码是否匹配数据库中的记录
    bool isValidUser = ValidateUser(connectionString, username, password);

    if (isValidUser)
    {
        e.Authenticated = true;
    }
    else
    {
        e.Authenticated = false;
    }
}

private bool ValidateUser(string connectionString, string username, string password)
{
    // 在aspnetdb数据库中验证用户名和密码
    // 这里可以使用ADO.NET或者Entity Framework等技术进行数据库操作
    // 示例代码仅作为演示，实际应根据具体情况进行修改

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        string query = "SELECT COUNT(*) FROM aspnetdb.dbo.aspnet_Users WHERE UserName = @Username AND Password = @Password";
        SqlCommand command = new SqlCommand(query, connection);
        command.Parameters.AddWithValue("@Username", username);
        command.Parameters.AddWithValue("@Password", password);

        connection.Open();
        int count = (int)command.ExecuteScalar();

        return count > 0;
    }
}