通过MySQL会员提供程序获取当前用户id

本文关键字：获取 用户 id 程序 MySQL 通过 | 更新日期: 2023-09-27 18:16:53

我目前参考这个教程http://www.asp.net/web-forms/tutorials/security/membership/storing-additional-user-information-cs，但我使用MySql成员资格提供程序而不是sql成员资格提供程序。这是教程中的代码:

protected void UserProfileDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
    // Get a reference to the currently logged on user
    MembershipUser currentUser = Membership.GetUser();
    // Determine the currently logged on user's UserId value
    Guid currentUserId = (Guid)currentUser.ProviderUserKey;
    // Assign the currently logged on user's UserId to the @UserId parameter
    e.Command.Parameters["@UserId"].Value = currentUserId;
}
这是我的错误代码 
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
    // Get a reference to the currently logged on user
    MySql.Web.Security.MySQLMembershipProvider currentUser = MySQLMembership.GetUser();
    // Determine the currently logged on user's UserId value
    Guid currentUserId = (Guid)currentUser.ProviderUserKey;
    // Assign the currently logged on user's UserId to the @UserId parameter
    e.Command.Parameters["@id"].Value = currentUserId;
}

我的问题是如何获得当前登录的用户id?我已经添加了mysql。Web和mysql。数据。我错过什么了吗?

通过MySQL会员提供程序获取当前用户id

查看使用SELECT USER(),CURRENT_USER();登录的用户id。查看当前登录的所有用户，请使用show processlist;或SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST

相关文章：