SqlDataSource - SelectCommand with session variable filter

Question

ASP.NET 2.0 framework

I'm trying to list all user related entries when the user visits the page. I have a session variable set with the visitor in session. Now I want to query the database with that ID. It seems to be executing, but no results are being returned (I'm displaying the contents in a seperate code section).

Please help!

<asp:SqlDataSource
ID="UserReports" 
runat="server"
ConnectionString= "<%$ ConnectionStrings:MyConnectionString %>"
SelectCommand = "SELECT [ID], [ReportName], [ReportPath] FROM [Pan].          
[dbo].[Reports] WHERE ([VisitorID] = @VisitorID)"
OnSelecting  = "SqldsExample_Selecting">

<SelectParameters>
    <asp:Parameter Name="VisitorID" Type="String"/>
</SelectParameters>    
</asp:SqlDataSource>

On the code behind:

Sub SqldsExample_Selecting(sender As Object, e As      
SqlDataSourceSelectingEventArgs)

UserReports.SelectParameters.Add("@VisitorID", Session("VisitorID"))

End Sub

You can take a look at marc_s' answer in the following post: stackoverflow.com/questions/17000390/…. — Martin Parenteau
– Martin Parenteau, Commented Jul 8, 2016 at 21:51

Denys Wessels · Accepted Answer · 2016-07-09 09:55:23Z

2

Don't use <asp:Parameter>.You should be using <asp:SessionParameter> to access the session variable directly:

<SelectParameters>
    <asp:SessionParameter Name="VisitorID" SessionField="VisitorID" />
</SelectParameters>

answered Jul 9, 2016 at 9:55

Denys Wessels

17.1k16 gold badges85 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Kana Over a year ago

Thanks Dennis. With your suggestion, I'm getting the following: Compiler Error Message: BC31143: Method 'Protected Sub SqlDataSource1_Selected(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)' does not have a signature compatible with delegate 'Delegate Sub SqlDataSourceSelectingEventHandler(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)'.

Denys Wessels Over a year ago

Remove the Selecting event handler completely.Set the session in the page load or on the previous page and access it using the example I provided.Have a look at this example - forums.asp.net/t/… it exactly the way ecbruck suggests

Kana Over a year ago

Thanks Dennis. Removed the Selecting event handler completely. And the session is being set on the pageLoad. Session("VisitorID") = userID Now getting: Parser Error Message: The server tag is not well formed. Source Error: Line 15: <asp:SqlDataSource Line 16: ID="UserReports" Line 17: runat="server"

Denys Wessels Over a year ago

That means one of the controls in your .aspx page is not well formed(doesn't have a closing tag,has an invalid character e.t.c) inspect your .aspx page and find the problem.And remember to mark my post as answered if it helped you

Kana Over a year ago

Thank you Denis. I was able to get the parse error corrected and now able to see the results with the following: <asp:Repeater id="Repeater1" DataSourceId="SQLsourceUserReports" Runat="server"> <ItemTemplate> <asp:HyperLink id="HyperLink1" Text='<%# Eval("ReportName") %>' NavigateUrl='<%# Eval("ReportPath", "{0}") %>' runat="server" /> </ItemTemplate> </asp:Repeater> The reason I had Selecting event handler was because I wanted to track the user clicks on the links above. Can you please help?

|

Collectives™ on Stack Overflow

SqlDataSource - SelectCommand with session variable filter

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related