How can I grab the user name to display only his information in the grid view. I'm using User Authentication and want to match the CurrentUser to the Project Lead Name.
In the following code in the WHERE clause if I put "FirstName LastName" it will work, but I want to grab the person who's logged in and display if Display Name and Current User Name match.
WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = "FirstName LastName")
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Here are my parameters: Nothing displays and it doesn't error out. must be very close, just not working.
<SelectParameters>
<asp:Parameter DefaultValue="Yes" Name="Active" Type="String" />
<asp:Parameter DefaultValue="No" Name="Completed" Type="String" />
<asp:SessionParameter Name="Project_Lead_Name" SessionField="CurrentUser.
</SelectParameters>
If you use this method,
<asp:Parameter DefaultValue="CurrentUser.
You probably want to set this through code as this is going to take string literal "CurrentUser.DisplayName".
Is
Not sure what LINQ syntax is, using VisualStudio and building with the Grid Views. Here's the page:
<%@ Page Language="VB" MasterPageFile="~/MasterPa
<asp:Content ID="Content1" ContentPlaceHolderID="Cont
<div align="left">
<asp:Panel ID="pnlCurrentProjects" runat="server" HorizontalAlign="Left" Width="100%">
<br />
<asp:Label ID="lblDashboard" runat="server" CssClass="big" ForeColor="#56A8E2" Text="Dashboard"></asp:Label
<br />
<br />
<table border="0" bgcolor="#eeeeee" cellpadding="10">
<tr>
<td colspan="3" rowspan="3" style="height: 105px" class="dashedTable" valign="top">
<table>
<tr>
<td class="subHead">
Welcome
<asp:Label ID="displayName" runat="server"></asp:Label></t
<td>
</td>
</tr>
<tr>
<td class="detailLabel">
This is your dashboard. On it you will find your upcoming projects listed below
meeting the criteria of being either the lead or on the team.</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td class="bold">
You may do the following:</td>
<td>
</td>
</tr>
<tr>
<td class="detailLabel">
-
<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/createProje
-
<asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl="~/projectList
-
<asp:LinkButton ID="LinkButton3" runat="server" PostBackUrl="~/admin.aspx"
<td>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
<tr>
</tr>
</table>
<br />
<br />
<asp:SqlDataSource ID="SqlCurrentProjectList"
DeleteCommand="DELETE FROM [projectDetails] WHERE [ID] = ?" InsertCommand="INSERT INTO [projectDetails] ([ID], [Project Title], [Project Priority], [Project Lead Name], [End Date], [Current Status], [Active]) VALUES (?, ?, ?, ?, ?, ?, ?)"
ProviderName="<%$ ConnectionStrings:RANSProj
SelectCommand="SELECT ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date, [Current Status] AS Current_Status, Active, Shop FROM projectDetails WHERE (Active = ?) AND (Completed = ?) ORDER BY [End Date] DESC"
UpdateCommand="UPDATE [projectDetails] SET [Project Title] = ?, [Project Priority] = ?, [Project Lead Name] = ?, [End Date] = ?, [Current Status] = ?, [Active] = ? WHERE [ID] = ?">
<SelectParameters>
<asp:Parameter DefaultValue="Yes" Name="Active" Type="String" />
<asp:Parameter DefaultValue="No" Name="Completed" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Project_Title" Type="String" />
<asp:Parameter Name="Project_Priority" Type="String" />
<asp:Parameter Name="Project_Lead_Name" Type="String" />
<asp:Parameter Name="End_Date" Type="DateTime" />
<asp:Parameter Name="Current_Status" Type="String" />
<asp:Parameter Name="Active" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Project_Title" Type="String" />
<asp:Parameter Name="Project_Priority" Type="String" />
<asp:Parameter Name="Project_Lead_Name" Type="String" />
<asp:Parameter Name="End_Date" Type="DateTime" />
<asp:Parameter Name="Current_Status" Type="String" />
<asp:Parameter Name="Active" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:Label ID="Label1" runat="server" Font-Bold="True" ForeColor="Black" Height="25px"
Text="Current Projects"></asp:Label>
<asp:GridView ID="gvCurrentProjectList" runat="server" AllowSorting="True" AutoGenerateColumns="False
BackColor="White" BorderColor="White" BorderStyle="None" BorderWidth="0px" CellPadding="4"
DataSourceID="sqlCurrentPr
Width="600px">
<FooterStyle BackColor="#CCCC99" ForeColor="Black" />
<Columns>
<asp:CommandField HeaderText="Compare" ShowSelectButton="True" Visible="False" />
<asp:HyperLinkField DataNavigateUrlFields="ID"
DataTextField="Project_Tit
<asp:BoundField DataField="Project_Title" HeaderText="Project Title" SortExpression="Project_Ti
Visible="False" />
<asp:BoundField DataField="Project_Priorit
<asp:BoundField DataField="Project_Lead_Na
<asp:BoundField DataField="Shop" HeaderText="Shop" SortExpression="Shop" />
<asp:BoundField DataField="End_Date" DataFormatString="{0:d}" HeaderText="Due Date"
HtmlEncode="False" SortExpression="End_Date" />
<asp:BoundField DataField="Current_Status"
<asp:BoundField DataField="Active" HeaderText="Active" SortExpression="Active" Visible="False" />
</Columns>
<PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="LightGray" BorderStyle="None" BorderWidth="0px" CssClass="normal"
Font-Strikeout="False" ForeColor="Black" />
<AlternatingRowStyle BackColor="#EEEEEE" ForeColor="#404040" />
</asp:GridView>
</asp:Panel>
<asp:SqlDataSource ID="SqlTeamListOnly" runat="server" ConnectionString="<%$ ConnectionStrings:RANSProj
DeleteCommand="DELETE FROM [projectDetails] WHERE [ID] = ?" InsertCommand="INSERT INTO [projectDetails] ([ID], [Project Title], [Project Priority], [Project Lead Name], [End Date], [Current Status], [Active]) VALUES (?, ?, ?, ?, ?, ?, ?)"
ProviderName="<%$ ConnectionStrings:RANSProj
SelectCommand="SELECT ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date, [Current Status] AS Current_Status, Active, Shop FROM projectDetails WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = @CurrentUser) ORDER BY [End Date] DESC"
UpdateCommand="UPDATE [projectDetails] SET [Project Title] = ?, [Project Priority] = ?, [Project Lead Name] = ?, [End Date] = ?, [Current Status] = ?, [Active] = ? WHERE [ID] = ?">
<SelectParameters>
<asp:Parameter DefaultValue="Yes" Name="Active" Type="String" />
<asp:Parameter DefaultValue="No" Name="Completed" Type="String" />
<asp:SessionParameter Name="Project_Lead_Name" SessionField=@CurrentUser.
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Project_Title" Type="String" />
<asp:Parameter Name="Project_Priority" Type="String" />
<asp:Parameter Name="Project_Lead_Name" Type="String" />
<asp:Parameter Name="End_Date" Type="DateTime" />
<asp:Parameter Name="Current_Status" Type="String" />
<asp:Parameter Name="Active" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Project_Title" Type="String" />
<asp:Parameter Name="Project_Priority" Type="String" />
<asp:Parameter Name="Project_Lead_Name" Type="String" />
<asp:Parameter Name="End_Date" Type="DateTime" />
<asp:Parameter Name="Current_Status" Type="String" />
<asp:Parameter Name="Active" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<asp:GridView ID="gvTeamListOnly" runat="server" AutoGenerateColumns="False
DataSourceID="SqlTeamListO
<Columns>
<asp:CommandField HeaderText="Compare" ShowSelectButton="True" Visible="False" />
<asp:HyperLinkField DataNavigateUrlFields="ID"
DataTextField="Project_Tit
<asp:BoundField DataField="Project_Title" HeaderText="Project Title" SortExpression="Project_Ti
Visible="False" />
<asp:BoundField DataField="Project_Priorit
<asp:BoundField DataField="Project_Lead_Na
<asp:BoundField DataField="Shop" SortExpression="Shop" HeaderText="Shop" >
<ItemStyle CssClass="detailLabel" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="End_Date" DataFormatString="{0:d}" HeaderText="Due Date"
HtmlEncode="False" SortExpression="End_Date" />
<asp:BoundField DataField="Current_Status"
<asp:BoundField DataField="Active" HeaderText="Active" SortExpression="Active" Visible="False" />
</Columns>
<FooterStyle BackColor="#CCCC99" ForeColor="Black" />
<PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="LightGray" ForeColor="Black" BorderWidth="0px" CssClass="normal" Font-Strikeout="False" BorderStyle="None" />
<AlternatingRowStyle BackColor="#EEEEEE" ForeColor="#404040" />
</asp:GridView>
<br />
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RANSProj
ProviderName="<%$ ConnectionStrings:RANSProj
SelectCommand="SELECT [Project Title] AS Project_Title, [Project Lead Name] AS Project_Lead_Name FROM [projectDetails] WHERE ([Project Lead Name] = ?)">
<SelectParameters>
<asp:SessionParameter Name="Project_Lead_Name" SessionField="CurrentUser.
</SelectParameters>
</asp:SqlDataSource>
</div>
</asp:Content>
Ah, sorry, I have been so use to creating my own connections that I didn't recognize the SqlDatasource structure.
http://msdn.microsoft.com/
See this. SessionParameter lets you add from session variables.
See 4guysfromrolla site on examples for using other parameter types.
But this is what I meant. I wanted you to setup the parameter, giving it a name that you can reference in the code behind and assign value.
http://www.pluralsig
no luck, I'm just not getting it. Thank you for helping though, anything else I should try :)
Last Attempt:
SelectCommand="SELECT ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date, [Current Status] AS Current_Status, Active, Shop FROM projectDetails WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = ?) ORDER BY [End Date] DESC"
<SelectParameters>
<asp:Parameter DefaultValue="Yes" Name="Active" Type="String" />
<asp:Parameter DefaultValue="No" Name="Completed" Type="String" />
<asp:QueryStringParameter Type="String" Name="Project_Lead_Name" QueryStringField=" DashboardUser " />
</SelectParameters>
code behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim X As String
X = CurrentUser.DisplayName
displayName.Text = CurrentUser.DisplayName
Dim DashboardUser As New SessionParameter()
DashboardUser.Name = " DashboardUser "
DashboardUser.Type = TypeCode.String
DashboardUser.SessionField
End Sub
I'm trying the example from the last link.
What event do I use instead of 'Inserting'. I can't get the page break to fire the event. I've tried, Selecting, Selected. Also tried Load, but it doesn't give me the e.command.
Latest Try: Code Behind
Protected Sub SqlTeamListOnly_Selecting(
e.Command.Parameters("@Pro
End Sub
ASPX:
SelectCommand="SELECT ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date, [Current Status] AS Current_Status, Active, Shop FROM projectDetails WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = @Project_Lead_Name) ORDER BY [End Date] DESC"
<SelectParameters>
<asp:Parameter DefaultValue="Yes" Name="Active" Type="String" />
<asp:Parameter DefaultValue="No" Name="Completed" Type="String" />
<asp:Parameter Name="Project_Lead_Name" Type="String" />
</SelectParameters>
Is SqlTeamListOnly the datasource name of the datasource you are doing the select from? If not, then change the Handles clause to be the correct datasource ID. Double check all the names/queries to ensure they are updated to have accurate code for all the things you are trying to do as their may be code from other attempts still in place causing issues. The parameters should just be plain asp:Parameters with name matching the @param in query without the @ in front.
When I break point the code behind, it is pulling the correct information from the database, however I then get the 'IndexOutOfRangeException was unhandled by user code'
An OleDbParameter with ParameterName '@Project_Lead_Name' is not contained by this OleDbParameterCollection.
does it have something to do with my clsBasePage:
Sub LoadUser()
Dim WindowsUser As String
If CurrentUser.LoginName Is Nothing Then
WindowsUser = Page.User.Identity.Name.To
WindowsUser = (WindowsUser.Split(Convert
'Connect the database and get user
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim reader As OleDbDataReader
con = New OleDbConnection("Provider=
cmd = New OleDbCommand("select [LoginName], [DisplayName], [Role] from [Users] where LoginName='" + WindowsUser + "'", con)
con.Open()
reader = cmd.ExecuteReader(CommandB
If reader.Read() Then
_User = New StructUser
_User.LoginName = WindowsUser
_User.DisplayName = reader("DisplayName").ToSt
_User.Role = Convert.ToInt32(reader("Ro
Session("CurrentUser") = _User
End If
End If
End Sub
Business Accounts
Answer for Membership
by: mwvisa1Posted on 2008-09-10 at 12:10:30ID: 22441816
SELECT ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date,
[Current Status] AS Current_Status, Active, Shop
FROM projectDetails
WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = @CurrentUser)
ORDER BY [End Date] DESC
Use a parameter @paramname in your SQL text of command and the use command.AddParameter function to set parameter value to CurrentUser.DisplayName.