Using a Session variable in an UpdateCommand
-
Hello, I am trying to use a Session Variable in an update command and the error that I continue to get is: Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Server tags cannot contain <%...%>constructs. It also says that the Datasource is not well formed when I try to enter it in. Could someone help me figure out how to use this? The session variable I am trying to bring over is a global temp table name. Below is the code.
<asp:SqlDataSource ID="FAR15DataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:Cost_ModelConnectionString %>"
SelectCommand="SELECT Service_Tower_Code, WBS_Code, Ownertype, Compensation_Code, Compensation_Rate, Far_East_FTE, Hawaii_FTE,Mid_Atlantic_FTE, NCR_FTE, North_Midwest_FTE, Northeast_FTE, South_FTE, Southwest_FTE
FROM fn_enterprise_positions(1)"
UpdateCommand="UPDATE <%=Session["TableName"]%> SET Far_East_FTE = @Far_East_FTE, Hawaii_FTE = @Hawaii_FTE, Mid_Atlantic_FTE = @Mid_Atlantic_FTE, NCR_FTE = @NCR_FTE, North_Midwest_FTE = @North_Midwest_FTE, Northeast_FTE = @Northeast_FTE, South_FTE = @South_FTE, Southwest_FTE = @Southwest_FTE
WHERE Service_Tower_Code = @Service_Tower_Code AND WBS_Code = @WBS_Code AND Compensation_Code = @Compensation_Code AND worker_code = @worker_code">
<UpdateParameters>
<asp:FormParameter Name="Service_Tower_Code" FormField="Service_Tower_Code" />
<asp:FormParameter Name="WBS_Code" FormField="WBS_Code" />
<asp:FormParameter Name="Compensation_Code" FormField="Compensation_Code" />
<asp:FormParameter Name="worker_code" FormField="worker_code" />
<asp:FormParameter Name="Compensation_Rate" FormField="Compensation_Rate" />
<asp:FormParameter Name="Far_East_FTE" FormField="Far_East_FTE" />
<asp:FormParameter Name="Hawaii_FTE" FormField="Hawaii_FTE" />
<asp:FormParameter Name="Mid_Atlantic_FTE" FormField="Mid_Atlantic_FTE" />
<asp:FormParameter Name="NCR_FTE" FormField="NCR_FTE" />
<asp:FormParameter Name="North_Midwest_FTE" FormField="North_Midwest_FTE" />
<asp:FormParameter Name="Northeast_FTE" FormField="N