asp.net - Populating SQLDataSource from Sessions in VB.NET -
i have below code , trying make connection string parameters pass stored procedure use values stored in session. how can done?
<asp:sqldatasource id="sqlds" runat="server" connectionstring="<%# session("connstrep") %>" selectcommandtype="storedprocedure" selectcommand="getgeninfo_mines"> <selectparameters> <asp:parameter defaultvalue="6" name="revno" type="string" /> <asp:parameter defaultvalue="1003992" name="appno" type="string" /> </selectparameters> </asp:sqldatasource>
an example of how pass session parameter can found here:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sessionparameter.aspx
Comments
Post a Comment