|
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="Northeast_FTE" />
<asp:FormParameter Name="South_FTE" FormField="South_FTE" />
<asp:FormParameter Name="Southwest_FTE" FormField="Southwest_FTE" />
</UpdateParameters>
</asp:SqlDataSource>
I did originally have a <asp:SessionParameter Name="TableName" /> inside the update parameters but that didnt seem to do anything. Thanks for your help!
John Michael
|
|
|
|
|
After some wiked code in the web site hangs, IIS do the same, and you can not access the site from IE no more. Though you still can use IIS 5.1 and stop and pause the site, but it is not accessible from outside.
How to restart IIS without server reboot? What service needs to stop and run again or executable to kill?
Чесноков
|
|
|
|
|
Chesnokov Yuriy wrote: How to restart IIS without server reboot? What service needs to stop and run again or executable to kill?
its iisreset
Goto Start > Run > iisrest
|
|
|
|
|
|
Hello
Im using:
SQL Server 2005 - VS 2008
Im trying to read data with using DataReader.
when I want to replace my data with variable there is an error :
Must declare the scalar variable "@G#".
Behind code :
objConnection.Open();<br />
string query = "Select * From goods where G#=@G#";<br />
objDataAdapter.SelectCommand.Parameters.AddWithValue("@G",Textbox.Text);<br />
using (reader = new SqlCommand(query, objConnection).ExecuteReader())<br />
{<br />
if (reader.HasRows)<br />
{<br />
while (reader.Read())<br />
{<br />
}<br />
}<br />
}
TIA
|
|
|
|
|
comp_j wrote: string query = "Select * From goods where G#=@G#";
What was that ?
G# is your field name ?
comp_j wrote: @G#"
You can't use over here. You need to used '@' when you are using parameter only.
|
|
|
|
|
Yes, it is my field name.
Abhijit Jana wrote: You can't use over here. You need to used '@' when you are using parameter only.
I didnt understand what you said. plz explain it with a sample code.
|
|
|
|
|
using(SqlConnection objConnection = new SqlConnection)<br />
{<br />
objConnection.Open();<br />
string query = "Select * From goods where G#=@GParam";<br />
using (SqlCommand command = new SqlCommand(query, objConnection))<br />
{<br />
command.Parameters.Add(new SqlParameter("@GParam", SqlDataType.yourtype, value));
SqlDataReader reader = command.ExecuteReader();<br />
if (reader.HasRows)<br />
{<br />
while (reader.Read())<br />
{<br />
}<br />
}<br />
}<br />
}
Hope this works...
|
|
|
|
|
It worked
Thank you so much.
|
|
|
|
|
you are most welcome friend.
|
|
|
|
|
where can I get an asp .net based forum?..
It doesn't need to be free...I'm willing to pay for it...
|
|
|
|
|
benams wrote: where can I get an asp .net based forum?..
You are already in a best ASP.NET Forum.
benams wrote: where can I get an asp .net based forum?..
It doesn't need to be free...I'm willing to pay for it.
So, you want to develope a ASP.NET Web forum ?
Have a look into it.
Kigg
|
|
|
|
|
you need only two controls, gridview and detailsview to design a forum.
Obviously, some database tables, and stored procedures or SQL queries ...
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
|
I am creating a site for social gathering as a part of my project...i want that unaccepted friend request should be deleted after 10 days. For this im using current date time and substracting it with the date time selected from database(datetime when friend request was sent)..its giving value of datetime but i just want date part of it not time so that i can convert into int and compare it with 10..if greater than 10 then delete that record..
|
|
|
|
|
How you are planning for implement it. I will suggest you to forget about to ASP.NET, Implement this part using SQL Server only ( IF your DB is SQL Server ).
Create a SQL Server Job Agent, which will check for some status from DB, if this is unaccepted then delete the request.
Hope you understood what I mean.
|
|
|
|
|
I have some issues with sql on my vista so unfortunately i have to use ms access..
|
|
|
|
|
greendragons wrote: I have some issues with sql on my vista so unfortunately i have to use ms access..
Why what is the problem, for what you want to move total database to MS-SQL to Access ?
|
|
|
|
|
Not moved db..instead i cant find option to open database in sql configuration manager..sql server surface area coniguration and sql server config manager r the only two icons i can see. I cant' find option to create db , add tables n all..i tried hard..even sql express was not working before but anyhow i managed to enable that bt still it shows account login failed..
|
|
|
|
|
You need SQL Server Management Studio for it. Please Install SSMS.
|
|
|
|
|
Do u have yahoo id..i want to solve my some queries..they are headache from long time please..my id is dorian_yates2007@yahoo.co.in
|
|
|
|
|
greendragons wrote: Do u have yahoo id..i want to solve my some queries.
You are welcome. Check my ID from my profile Page. Feel free to drop me mail.
Thanks.
|
|
|
|
|
Sure..but what about my problem is ther anyway that i can get just date part from datetime object..?
|
|
|
|
|
greendragons wrote: that i can get just date part from datetime object..?
U are asking for C# or SQL ?
here it for SQL
DECLARE @DateOnly DATETIME<br />
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
Details Source : Check
|
|
|
|
|