How to update the ASPNETDB file (login control) with a GridView (asp.net 2.0)

microsoft.public.dotnet.framework

19 Dec 2005 11:04 PM

stockblaster

Hello

I am beginning to feel sorry that i am using the asp.net 2.0 login
controls.. it feels it makes you limited and you do not have much
support about it..

I managed to view aspnet_Membership and aspnet_Users into 1 GridView
using the SqlDataSource control
I can't figure out how to Initialize the built in Update in the
GridView so i could update user information from the gridview
(including UserName, Password and other stuff i added manually to the
database when a user register), or i need to do it manually?
I already managed to delete a user with GridView1_RowCommand detecting
the button pressed and doing Membership.DeleteUser(row.Cells[3].Text ,
true);

Does anyone can please help me here :\

20 Dec 2005 11:26 AM

stockblaster

What i did already is:

I am new to this kind of syntax in asp.net2.0 and db.
What happenes now that if i Press -> Edit --> Update it just postback
and nothing happenes, all i want it is to update the fields.. consider
that i am using two tables.
I would greatly appreciate it if someone can assist me here.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:UserBase %>"
        OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT vw_aspnet_MembershipUsers.UserId,
vw_aspnet_MembershipUsers.PasswordFormat,
vw_aspnet_MembershipUsers.MobilePIN, vw_aspnet_MembershipUsers.Email,
vw_aspnet_MembershipUsers.LoweredEmail,
vw_aspnet_MembershipUsers.PasswordQuestion,
vw_aspnet_MembershipUsers.PasswordAnswer,
vw_aspnet_MembershipUsers.IsApproved,
vw_aspnet_MembershipUsers.IsLockedOut,
vw_aspnet_MembershipUsers.CreateDate,
vw_aspnet_MembershipUsers.LastLoginDate,
vw_aspnet_MembershipUsers.LastPasswordChangedDate,
vw_aspnet_MembershipUsers.LastLockoutDate,
vw_aspnet_MembershipUsers.FailedPasswordAttemptCount,
vw_aspnet_MembershipUsers.FailedPasswordAttemptWindowStart,
vw_aspnet_MembershipUsers.FailedPasswordAnswerAttemptCount,
vw_aspnet_MembershipUsers.FailedPasswordAnswerAttemptWindowStart,
vw_aspnet_MembershipUsers.Comment,
vw_aspnet_MembershipUsers.ApplicationId,
vw_aspnet_MembershipUsers.UserName,
vw_aspnet_MembershipUsers.MobileAlias,
vw_aspnet_MembershipUsers.IsAnonymous,
vw_aspnet_MembershipUsers.LastActivityDate, aspnet_Users.ApplicationId,
aspnet_Users.UserId, aspnet_Users.UserName,
aspnet_Users.LoweredUserName, aspnet_Users.MobileAlias,
aspnet_Users.IsAnonymous, aspnet_Users.LastActivityDate,
vw_aspnet_MembershipUsers.UserId,
vw_aspnet_MembershipUsers.PasswordFormat,
vw_aspnet_MembershipUsers.MobilePIN, vw_aspnet_MembershipUsers.Email,
vw_aspnet_MembershipUsers.LoweredEmail,
vw_aspnet_MembershipUsers.PasswordQuestion,
vw_aspnet_MembershipUsers.PasswordAnswer,
vw_aspnet_MembershipUsers.IsApproved,
vw_aspnet_MembershipUsers.IsLockedOut,
vw_aspnet_MembershipUsers.CreateDate,
vw_aspnet_MembershipUsers.LastLoginDate,
vw_aspnet_MembershipUsers.LastPasswordChangedDate,
vw_aspnet_MembershipUsers.LastLockoutDate,
vw_aspnet_MembershipUsers.FailedPasswordAttemptCount,
vw_aspnet_MembershipUsers.FailedPasswordAttemptWindowStart,
vw_aspnet_MembershipUsers.FailedPasswordAnswerAttemptCount,
vw_aspnet_MembershipUsers.FailedPasswordAnswerAttemptWindowStart,
vw_aspnet_MembershipUsers.Comment,
vw_aspnet_MembershipUsers.ApplicationId,
vw_aspnet_MembershipUsers.UserName,
vw_aspnet_MembershipUsers.MobileAlias,
vw_aspnet_MembershipUsers.IsAnonymous,
vw_aspnet_MembershipUsers.LastActivityDate FROM
vw_aspnet_MembershipUsers INNER JOIN aspnet_Users ON
vw_aspnet_MembershipUsers.UserId = aspnet_Users.UserId"
        UpdateCommand="UPDATE aspnet_Membership SET UserId =
aspnet_Membership.UserId, Password = aspnet_Membership.Password, Email
= aspnet_Membership.Email, LoweredEmail =
aspnet_Membership.LoweredEmail, IsApproved =
aspnet_Membership.IsApproved, IsLockedOut =
aspnet_Membership.IsLockedOut, MessageCount =
aspnet_Membership.MessageCount, ExperienceYears =
aspnet_Membership.ExperienceYears, Country = aspnet_Membership.Country,
MailListSubscribe = aspnet_Membership.MailListSubscribe FROM
aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId =
aspnet_Users.UserId">
    </asp:SqlDataSource>