Pass ASP.Net Membership LoggedIn UserName as parameter to SQL Server Datasource query

sdeyoung

SOLVED CLOSED ACTIVE ANSWERED
User: sdeyoung
Posted: on Jul 23, 2012 11:57 PM
Forum: ASP.Net Basics
Answer: 1
Views: 10003

Hello, New to this site and was hoping for some help with something I have looked very hard for answers about but can't get it. I am new to ASP.NET programming so this probably is very easy for you all. I have an ASP.NET VB website in which I am using the Membership functionality to authenticate users. I am doing this through the Login control on the HTML page. I have working that it will authenticate the user and then opens a welcome screen in which I have a button they can push to open a Reports.aspx page. On that page I have a dropdown box that is being populated from a datasource connection query to my SQL Server database table. It is a hard coded query but want it to query the table off the username text value that the user provided on the login (i.e. select <something> from inventory where username = <username>). I have not behind code but only HTML at this point. Here it is any any help will be greatly appreciated!

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Login.aspx.vb" Inherits="Login" %>

<!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:LoginView ID="LoginView" runat="server">
<AnonymousTemplate>
Please Login<br></br>
<asp:Login ID="LoginControl" runat="server"></asp:Login>
</AnonymousTemplate>
<LoggedInTemplate>
Welcome back. <asp:LoginName ID="LoginName1" runat="server" /> | <asp:LoginStatus runat="server" />
<h3>Reports Page</h3>
<asp:Button
ID="Button1"
PostBackUrl="~/Report.aspx"
runat="server"
Text="Reports Button" />
</form>
</LoggedInTemplate>
</asp:LoginView>
</div>
</form>
</body>
</html>


Here is the Reports form that has the dropdown on it:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Report.aspx.vb" Inherits="Report" %>

<!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:Label ID="Label1" runat="server" Text="REPORTS PAGE"></asp:Label>
<br />
<br />
<p>
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="Warehouse"
DataValueField="Warehouse" Width="124px">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyDatabaseConnectionString %>" SelectCommand="select b.whse_code+'-'+b.Whse_name as [Warehouse]
from users a
join Inventory b on a.cust_code = b.cust_oode
where a.username = 'sdeyoung'
"></asp:SqlDataSource>
</p>
<asp:Button
ID="Button1"
PostBackUrl="~/Login.aspx"
runat="server"
Text="back to Welcome Screen" />
</div>
</form>
</body>
</html>

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Jul 24, 2012 12:02 AM
Modified: on Jul 24, 2012 05:23 PM
Report

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyDatabaseConnectionString %>"
        SelectCommand="select b.whse_code+'-'+b.Whse_name as [Warehouse]from users a join Inventory b on a.cust_code = b.cust_oodewhere a.username = @UserName">
        <SelectParameters>
        <asp:Parameter Name="UserName" Type="String" DefaultValue="Anonymous" />
        </SelectParameters>
    </asp:SqlDataSource>

    protected void Page_Init(object sender, EventArgs e)
    {
        SqlDataSource1.SelectParameters["UserName"].DefaultValue = this.Page.User.Identity.Name;
    }

VB.Net

Protected Sub Page_Init(sender As Object, e As EventArgs)
    SqlDataSource1.SelectParameters("UserName").DefaultValue = Me.Page.User.Identity.Name
End Sub

Pass ASP.Net Membership LoggedIn UserName as parameter to SQL Server Datasource query

Company

Explore

Follow us

Contact Us