Solved

Set parameters for gridview select statement

Posted on 2008-06-24
2
766 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SignalR - getting new data from sql DB 5 81
error on the asp.net page 1 33
Code works but I need to redo it and assign values to Model 7 32
Runtime Error 2 28
Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now