Displaying data based on user logged in

mashype · January 31st, 2009, 04:18 PM

Thanks Lee. I had some structural issues on the query, but I moved some things around and its working great! Thanks so much for all your help!

Lee Dumond · February 1st, 2009, 12:17 AM

You're welcome.

If you like, feel free to click the Thanks button on any posts you found helpful.

larsenal · May 19th, 2010, 03:49 AM

Quote:

Originally Posted by Lee Dumond

This is getting somewhat confusing, as there are two different users asking stuff in this same thread.

Okay, this is for Mashype. Based on the code example you did posted yesterday. I am using a DetailsView here. Here is the entire code sample.

Page:

Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
   <title></title>
</head>
<body>
   <form id="form1" runat="server">
      <div>
         <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="UserID"
            DataSourceID="SqlDataSource1" Height="50px" Width="125px">
            <Fields>
               <asp:BoundField DataField="UserID" HeaderText="UserID" InsertVisible="False" ReadOnly="True"
                  SortExpression="UserID" />
               <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
               <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
            </Fields>
         </asp:DetailsView>
         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ProdConnectionString %>"
            SelectCommand="SELECT [UserID], [UserName], [LastName] FROM [TblUsers] WHERE ([UserName] = @UserName)"
            OnSelecting="SqlDataSource1_Selecting">
            <SelectParameters>
               <asp:Parameter Name="UserName" Type="String" />
            </SelectParameters>
         </asp:SqlDataSource>
      </div>
   </form>
</body>
</html>

Code-behind:

Code:

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
   protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
   {
      e.Command.Parameters["@UserName"].Value = Context.User.Identity.Name;
   }
}

This might be a little bit too late but..
I have excactly the same problem but I am using a access data source. I am a beginner and I can't find a solution. How would the code look? Please help me.

Imar · May 19th, 2010, 01:44 PM

Hi larsenal,

It's almost the same with an AccessDataSource, except that you don't refer to the parameters by name, but by their index. Here's q quick example using a GridView:

Code:

 
<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
    DataFile="~/App_Data/Database1.mdb" OnSelecting="AccessDataSource1_Selecting" 
    SelectCommand="SELECT * FROM [Test] WHERE ([UserName] = ?)">
  <SelectParameters>
    <asp:Parameter Name="UserName" Type="String" />
  </SelectParameters>
</asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" 
       DataKeyNames="ID" DataSourceID="AccessDataSource1" />

And then in the Code Behind you need this:

Code:

 
protected void AccessDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
  e.Command.Parameters[0].Value = Context.User.Identity.Name;
}

This assigns the user name to the first (and only) parameter defined in the query.

Hope this helps,

Imar
---------------------------------------------------------------------------------------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter.

Everyone is unique, except for me.
Author of Beginning ASP.NET 4 : in C# and VB, Beginning ASP.NET 3.5 : in C# and VB, and ASP.NET 2.0 Instant Results.
While typing this post, I was listening to: Kitty Litter by Placebo (From the album: Battle for the Sun) What's This?