User-56120927 posted
Hi,
I'm stuck. I'm trying to return only a details view for the logged in user on this copy of the member details page. I create a variable called MemberID on page load and when I use a break, I can see that the correct value is being assigned to
the variable.
However, when I run the page, no details view displays because the query is not executing properly. Is there anything obviously wrong here?
Many thanks in advance,
-JS
Here is the code:
<%@ Page
Language="VB"
MasterPageFile="~/Default.master"
Title="Modify Membership Details" %>
<%@ Register
TagPrefix="Club"
Namespace="ClubSite" %>
<
script
runat="server">
Protected Sub Page_Load(ByVal sender
As Object,
ByVal e As System.EventArgs)
Dim MemberID
As String
If Not Page.User.Identity.IsAuthenticated
Then
Response.Write(
"To use the member details functionality, you need to be authenticated. Please use the <a href='login.aspx'>Login</a> page to authenticate yourself.")
Response.End()
End If
If Not IsPostBack
Then
InitPageData()
End If
If User.Identity.IsAuthenticated =
True Then
MemberID = Membership.GetUser.ProviderUserKey.ToString()
End If
End Sub
Sub InitPageData()
Dim user As MembershipUser = Membership.GetUser()
Dim da As
New DataSetTableAdapters.MemberInfoTableAdapter
Dim dt As DataSet.MemberInfoDataTable = da.GetMember(CType(user.ProviderUserKey,
Guid))
If dt.Rows.Count = 1
Then
Dim mr As DataSet.MemberInfoRow = dt(0)
UserName.Text = user.UserName
End If
End Sub
</
script>
<
asp:Content
ID="Content2"
ContentPlaceHolderID="ContentPlaceHolder1"
runat="Server">
<div
id="body">
<!--Start of left column-->
<div
id="columnleft">
<a
name="content_start"
id="content_start"></a>
<div
class="leftblock">
<h2>
<asp:Label
ID="UserName"
runat="server"
/>'s Basic Information
</h2>
<p>
<strong>Modify My:</strong></p>
<p>
<a
href="Member_Details.aspx">
Membership Details
<strong></strong></a></p>
<p>
<a
href="Member_Artist.aspx">
Artist Profile
</a></p>
<p>
<a
href="Member_Pro.aspx">
Professional Profile
</a></p>
<p>
<a
href="Member_Student.aspx">
Student Profile
</a></p>
</div>
</div>
<!--end columnleft-->
<!--Start of right column-->
<div
id="columnright">
<br
/>
<br
/>
<br
/>
<br
/>
<br
/>
<br
/>
<asp:DetailsView
ID="DetailsView1"
runat="server"
AutoGenerateRows="False"
DataKeyNames="memberid"
DataSourceID="SqlDataSource1"
Height="50px"
Width="125px">
<Fields>
<asp:BoundField
DataField="memberid"
HeaderText="memberid"
ReadOnly="True"
SortExpression="memberid"
/>
<asp:BoundField
DataField="address"
HeaderText="address"
SortExpression="address"
/>
<asp:BoundField
DataField="phone"
HeaderText="phone"
SortExpression="phone"
/>
<asp:BoundField
DataField="firstname"
HeaderText="firstname"
SortExpression="firstname"
/>
<asp:BoundField
DataField="lastname"
HeaderText="lastname"
SortExpression="lastname"
/>
<asp:BoundField
DataField="WhatInspiresStudent"
HeaderText="WhatInspiresStudent"
SortExpression="WhatInspiresStudent"
/>
</Fields>
</asp:DetailsView>
</div>
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:ClubSiteDb %>"
SelectCommand="SELECT memberid, address, phone, firstname, lastname, WhatInspiresStudent FROM MemberInfo WHERE (memberid = @MemberID)">
<SelectParameters>
<asp:Parameter
Name="MemberID"
/>
</SelectParameters>
</asp:SqlDataSource>
<div
class="clear2column">
</div>
</div>
</
asp:Content>
