[Code]....
Above is dynamic sql and when it is executed by sp_executesql then I got output as as xml. If I want to store that XML in a variable. So then what I need to add in my tsql script.
i am wishing to store the query result in any variable, have look at below code.
[Code]....
I have marked the code with bold, where I am getting error.
how do I store query result in any variable.
I have a web application which uses a session variable to store the logged in userid. If no user is logged in, of course this variable will be empty and the contents displayed on my website are meant for guests. If there is a user logged in, the user specific controls/access/links will then be a displayed.
I am now having issues with my hosting where on shared application pool, the worker recycle is triggered every 90 minutes, this will clear sessions causing all my users to be logged out. I opted for a dedicated application pool, which got worse because I am only allocated 50MB memory limit and if this is reached, the worker recycle is triggered and I lose my sessions again. I have tried as much as possible optimization techniques, e.g. dispose where possible, close connections, disable viewstate for static controls etc but my memory per instance keeps building up from page to page without any signs of improvement. I don't use loops nor store huge objects like bitmaps etc but my sessions are now gone even faster than 90 minutes in shared application pool before.
I have considered using SQL Session State but there isn't a simple guide on using this with MySQL. I am getting desperate and considering using a public variable, a string as a replacement to store logged in user id instead of in a session variable. I am pretty sure this will solve my issue with sessions being recycled but are there any negative consequences of doing this? One problem I can think of is if the user closes the browser, the system will never know that the user is now logged out and this public variable should be nothing. In this scenario, will the GC eventually clear this abandoned public variable.
i want to put the output of store procedure in ImageUrl
this is behind code, i wrote it on onclick event of asp:image
Pic is the name of a folder in root of site , i want to put the output of store procedure in Eval:
Image1.ImageUrl("~/pic/"+Eval(" " ));
I want to correspond the output of a store procedure to the image onclick event I mean here:
protected void imageLoaded(object sender, EventArgs e) {
Image1.ImageUrl("~/pic/"+Eval(" " )); }
I don't know what I should write in Eval.
I want to execute a Store Procedure and then get the Output in one table. However I am not getting the query. I want something like this execute 'Stored procedure name' 'param1','param2','param3' and then get the result into some table. Is this possible?
select * into #table from (execute 'Stored procedure name' 'param1','param2','param3')
I am calling a stored procedure, that exists in a SQL Server 2005 database, using ADO.NET, in which I instantiate a sql command object.
The stored procedure has an ouput variable like '@packageCode VARCHAR(100) = NULL OUTPUT'.
Can I set it's value when creating the sql command object? Or I can never set a value for an output type variable in a stored procedure?
here my code-
using (SqlDataReader sqlDataReader = ExecuteReader(CommandType.StoredProcedure, StoredProcedures.AuthenticateUser, sqlParameter))
{
isAuthenticated = Convert.ToBoolean(sqlParameter[2].Value);
if (isAuthenticated)
{
if (sqlDataReader.Read())
{
User = new UserEntity();
DbHelper.GetEntity(sqlDataReader, User);
}
}
}
I always get isAuthenticated as false because sqlParameter[2].Value is null all the time but when I execute my query with ExecuteNonQuery it gives me the value but in that case I can not fill the entity.
Currently in an .aspx file, I am storing a value (filename that was created in that session) in an hidden text box. When the user clicks on the "Print" labeled Hyperlink control, it opens the file that was stored in the hidden text box control. But when the user goes to different screen (in the same session), I loose the filename value that is stored in the hidden text box control. So I would like to store the filename variable in a session variable. So that if the user leaves this .aspx file and comes back to this .aspx file I can load the value into the hidden text box from the session variable.
View 11 RepliesI have a datalist that shows Label, Label2 and has 8 rows of data.
I would like to store the value in Label2 row 8 in a session variable... how can i do this in VB.net?
how could i store a Asp.net Application variable by javascript.
View 2 RepliesI want to store a Max value of a table in sqlserver database to a C# Variable.
View 2 Repliesi have written following code to access public variable of asp.net onclick event on button but its not giving me desired output.. please check it:
<asp:Button runat="server" CssClass="txtdisplay" ID="Button1"
Text="Browse all jobs in area"
OnClientClick="return navigateURL('index.aspx?c=<%=cityid %>')" />
consider this scenario: a user on my website has a profileID. There are some pluginID's associated with this profileID.
E.g.: User1 might have 2, 3 and 5 plugins associated with his profile.
When the user logs in, I store the profileID of the user in a session variable cod. ON a certain page, the user tries to edit the plugins associated with his profile. So, on that page, I have to retrieve those pluginID's from the DB.
I have applied this code but this fetches only the maximum pluginID from the DB and not all the pluginID's.
[Code]....
I was trying to figure out how can I store multiple pluginID's in this session variable?
I wish to store some variables across my whole ASP.NET site, such as the site name/title and a multitude of others.
I wish to store them in an XML file with a name and value, and then insert them into the relevant place on the page using a tag like <% siteTitle %>.
How can I do this? I have seen similar with sites like SmarterMail and other ASP.NET off-the-shelf products, but they seem to use a value from their own DLL file, this is probably too much of a complex method, so I will need something simple like the XML method mentioned above. Having said this, I don't particularly want to use the AppSettings method.
How to store the values in array(variable) using textbox?..
View 7 RepliesI have 2 arrays declared like this :
[Code]....
and i wish to put both in one session variable and then retrieve it to get one array like:
{"intItemID","strCategory","strType"}
I'm looking store an ArrayList into a session variable, but am having a few problems. Can you spot anything wrong?
public partial class _Default : System.Web.UI.Page { ArrayList score = new ArrayList(); protected void twist2(object sender, EventArgs e) { int a = 11; int c = RandomNumber(a); score.Add(c); score = (ArrayList)Session["scoreData"]; Result.Text = (c).ToString(); String Result_id = Result.Text; int total = 0; //Session["scoreData"] = score; for (int i = 0; i < score.Count; ++i) { total += (int)score[i]; } Sum.Text = (total).ToString(); String Sum_id = Sum.Text; }
Is there a way how to capture only the picture from webcam and store that image into the variable. But i dont want to use silerlight nor flash.But if is not possible then i do need the step how to use in flash. I dont need good quality.
View 2 RepliesDim ename As String = DropDownList.SelectedItem.Value
this statement is'nt working
my JSON is as follows :
{ "Data":[ { "id":"1", "Name":"Sachin" }, { "id":"2", "Name":"Rahul" },
{ "id":"3", "Name":"Sovrav" } ]}
Now i want to filter out only array from that JSON and store them in a variable like this :
[ { "id":"1", "Name":"Sachin" }, { "id":"2", "Name":"Rahul" },
{ "id":"3", "Name":"Sovrav" } ]
i want to store Session["Name"] into databse "name" column. how to do this ?
View 1 RepliesI have to build a screen that tracks despatched goods on trucks on a certain date. I have created a form (using C# and ASP.NET) where I am displaying the calendar and am allowing the user to select the date he wants to check for the despatched goods.
My question is how to store the date that was clicked by a user in a variable which I want to use it later in an SQL query.
Should I store the date as a session variable? Suppose I want to display the date that the user clicked, how do I display it?
the dropdown list is showing data from database, but how to retrieve the selected value and store it in a session variable??
View 1 RepliesI'm working on a web page that is going to be used to enter data into a database. The page is going to be dynamic in that the user has the ability to add a row to the table with the same fields, ie lname1, fname1, mi1 then lname2, fname2, mi2
I'm wanting to use a variable to keep track of how many lines there are so that when I generate the added line I am creating a new field with the ID of lname+# . Whats the best way to do this, a global variable, session variable? As side note, first time programming in .Net or C#.