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.

score 0 · Answer 1 · answered Aug 11 '23 at 22:33

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

score 0 · Answer 2 · edited Aug 15 '23 at 18:58

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 '23 at 18:58

Tyler2P

2,324
26
22
31

answered Aug 12 '23 at 13:06

srame

1
1

How i usee this source as a select command? – simo Aug 12 '23 at 16:36
To past you can do this Request.QueryString['se'] look at this https://stackoverflow.com/questions/13732975/getting-a-variable-from-url-and-passing-it-into-sqldatasource-selectcommand – srame Aug 13 '23 at 13:24

Session value not working in SelectCommand of SqlDataSource for DetailsView

2 Answers2