Solved

Set parameters for gridview select statement

Posted on 2008-06-24
2
772 Views
Last Modified: 2012-02-02
I have set up a grid view and I want to use a stored procedure to populate the grid. This works if I hard code a value, but I want to use value of HttpContext.Current.User.Identity.Name.

For example
SelectCommand="sp_SelectStatement 'mysearchitem' works but
SelectCommand="sp_SelectStatement '<%=HttpContext.Current.User.Identity.Name %>'
doesn't.
I've also tried using <%#eval(HttpContext.Current.User.Identity.Name)%> and this doesn't work either.

Thanks.
0
Comment
Question by:kirkheaton25
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
Dustin Hopkins earned 500 total points
ID: 21857716
you should use a parameterised query. then just set the username to a session variable in the pageload. and set a sessionparameter in the markup.
'PageLoad
 Sub page_load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Session("username") = HttpContext.Current.User.Identity.Name
    End Sub
 
'FrontEnd
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:urodataConnectionString %>"
            SelectCommand="Testselectuser" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:SessionParameter Name="name" SessionField="username" />
            </SelectParameters>
        </asp:SqlDataSource>

Open in new window

0
 
LVL 1

Author Closing Comment

by:kirkheaton25
ID: 31470134
That was perfect, thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question