Session value not working in SelectCommand of SqlDataSource for DetailsView

Question

i have a webapplication in .net and use a DetailsView. im control this DetailsView with a SqlDataSource. i set a session with jquery.

     <script >
         var baseUrl = (window.location).href;
         var clubid = baseUrl.substring(baseUrl.lastIndexOf('=') + 1);
         sessionStorage.setItem("se", "13801");
         var ses = sessionStorage.getItem("se");
     </script>

Fields of DetailsView :

<Fields>
    <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" />
    <asp:BoundField DataField="name" HeaderText="name"
        SortExpression="name" />
    <asp:BoundField DataField="saltasis" HeaderText="saltasis" SortExpression="saltasis" />
    <asp:CommandField />
    <asp:CommandField ShowEditButton="True" />
    <asp:CommandField ShowInsertButton="True" />
    <asp:CommandField ShowDeleteButton="True" />
</Fields>

and SQLDATASOURCEID :

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sina1ConnectionString %>" 
    SelectCommand="SELECT * FROM [club] WHERE saltasis = @saltasis">
    <SelectParameters>
    <asp:SessionParameter Name="?" SessionField="?" Type="string" />
    </SelectParameters>

</asp:SqlDataSource>

how to use a session as a value in SelectCommand of SqlDataSource for DetailsView.

mehdi Rahimy · Accepted Answer · 2023-08-11 22:33:10Z

0

Store session value in hidden field with javascript. Pay attention, if you use the master page, the name of the hidden field is as follows:

document.getElementById('ContentPlaceHolder1_hiddenfield1').value = "session_value";

Then you can use the session value stored in the hidden field

answered Aug 11, 2023 at 22:33

mehdi Rahimy

12 bronze badges

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

Comments

Tyler2P · Accepted Answer · 2023-08-15 18:58:39Z

0

Hi in your example I only show you save the session value inside your sessionStorage but you didn't past inside a html form or ajax as POST or GET. So you need to catch the url inside your controller: for example this URL (window.location).href https://domain.eg/ControllerName/ActionName?se=13801

[httpGet]
public void ActionName(string se)
{

  var sessionParams = se;
  -- do what you want with that...

}

edited Aug 15, 2023 at 18:58

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Aug 12, 2023 at 13:06

srame

11 bronze badge

2 Comments

simo Over a year ago

How i usee this source as a select command?

srame Over a year ago

To past you can do this Request.QueryString['se'] look at this stackoverflow.com/questions/13732975/…

Collectives™ on Stack Overflow

Session value not working in SelectCommand of SqlDataSource for DetailsView

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related