Technical Corner: Session variable in select Asp.net 2.0 SqlDataSource parameter

Showing posts with label Session variable in select Asp.net 2.0 SqlDataSource parameter. Show all posts

Tuesday, June 3, 2008

Session & Control variable in select Asp.net 2.0 SqlDataSource

asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT DISTINCT nicknm,uweek FROM uNflsel WHERE ((loginm = @loginm) AND (uWeek = @uWeek))"
SelectParameters
asp:SessionParameter Name="loginm" SessionField="loginm" Type="String"
asp:ControlParameter ControlID="DropDownList1" Name="uWeek" PropertyName="SelectedValue" Type="String"
SelectParameters
asp:SqlDataSource

www.visli.com