How I can pass session parameters to SqlDataSource
Database
2
Posts
2
Posters
0
Views
1
Watching
-
hi.. How I can Pass session parameters to sqlDataSource. I do like this but it is not work:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>"SelectCommand="SELECT CampaignName, AdType AS \[Campaign Type\], Status, Date AS \[Start Date\], Clicks, Impr, DailyBudget AS \[Daily budget\] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE Account.EmailAddress = @EmailAddress "> <SelectParameters> <asp:SessionParameter Name="EmailAddress" Type="String" SessionField="EmailAddress" /> </SelectParameters> </asp:SqlDataSource>
The session name is :session["EmailAddress"] Please guide me.
-
hi.. How I can Pass session parameters to sqlDataSource. I do like this but it is not work:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>"SelectCommand="SELECT CampaignName, AdType AS \[Campaign Type\], Status, Date AS \[Start Date\], Clicks, Impr, DailyBudget AS \[Daily budget\] FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE Account.EmailAddress = @EmailAddress "> <SelectParameters> <asp:SessionParameter Name="EmailAddress" Type="String" SessionField="EmailAddress" /> </SelectParameters> </asp:SqlDataSource>
The session name is :session["EmailAddress"] Please guide me.
Add the risk of sounding repetitious and single-minded: And what is the error message? There are no psychics here.