sqlDataSource and Session Variable

[MTSkull]

I am trying to tie a sqlDatasource to a Stored Procedure.

 

The stored procedure looks like...

dbo.Select_SomeData_BySuperAssemID
(@SuperAssemID as int)

Select * 
From SomeTable
Where SuperAssemID= @SuperAssemID

 

Then the asp page is accessed via ...

Response.Redirect("DataPage.aspx?SuperID=" + ID);

 

In the code behind I can access and use Super ID no problem, but when I try to set up the SQL data source to access super ID it returns nothing.

My gridview is bound to the following control.

<asp:SqlDataSource ID="sqlSubAssemblies" runat="server" 
           ConnectionString="<%$ ConnectionStrings:MyConnStr %>" 
           SelectCommand="Select_SomeData_BySuperID" 
           SelectCommandType="StoredProcedure">
               <SelectParameters>
                   <asp:SessionParameter Name="SuperAssemID"
                           SessionField="SuperID" Type="Int32" />
               </SelectParameters>
</asp:SqlDataSource>

 

Thanks in advance...

Brian

[PlausiblyDamp]

It looks as though you are passing the parameter as part of the query string, yet in the markup you are using a SessionParameter, are you copying the query string value into the session first? If not you could just use a

[MTSkull]

How easy was that! I switched from session to Query String and passed the session variable as the value and presto it worked.

 

Your help is greatly Appreciated.