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

No comments: