How to select data for "current user" in detailsview?

V

VB Programmer

When my users login I want them to be able to change some of their personal
info in a db. I want to use a detailsview control for this.

How can I get the detailsview to only pull up the record based on their
USERID ("current user")?

This SqlDataSource doesn't seem to return anything...

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:MyMainDatabase %>"

SelectCommand="SELECT * FROM [MyUsers] WHERE ([UserId] = @UserId)">

<SelectParameters>

<asp:profileParameter Name="UserId" Type="String" />

</SelectParameters>

</asp:SqlDataSource>


Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,230
Members
46,818
Latest member
Brigette36

Latest Threads

Top