Hi all,
Finally succeeded in altering the RSVP module from Angelo. (small adaption)
I wanted only to show the attendance of the logged-in user instead of the complete list. (for privacy reasons, though I myself don't see it as a problem, I am anticipating the demand to change it like that would come soon)
So the change has to be something like (in pink):
SelectCommand
="SELECT aspnet_Users.UserName, aspnet_Users.UserId, Attendance.numofguest, aspnet_Membership.ImageId FROM Attendance INNER JOIN aspnet_Users ON Attendance.member = aspnet_Users.UserId INNER JOIN aspnet_Membership ON Attendance.member = aspnet_Membership.UserId WHERE (Attendance.eventid = @id) AND (aspnet_Users.UserId = @this)">
This in itself works fine. But I could only get it done by using a control,
<asp:ControlParameter ControlID="Lex" Name="this" PropertyName="Text" />
I guess it should also be possible to use a QueryStringParameter
This I can't get done. (Perhaps UserID being UniqueIdentifier complicate things also.)
Thanks in advance,
Lex
I use VB