Possible To Set DataSource Where Table Is In Session Variable

Aug 12, 2011

Can I set up an ASP.Net datasource in the ASPX code as opposed to the code behind) where the datasource is a DataTable that's stored in a Session variable?

View 1 Replies


Similar Messages:

DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value

Oct 27, 2010

I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:

[Code]....

However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />

View 2 Replies

Add Session Variable Or Custom Field To Elmah Error Log Table

Apr 21, 2010

I want to add my own session variable to elmah error log table and display it. I already have modified the source code and added the new fields to Error.cs and other fields but I don't know but when I assign an HttpContext.Current.Session["MyVar"].tostring() value to my field in the constructor it stops logging exceptions and does not log any exception. I just need to get the value of the session variable is there other way for this ? I read a post which he added fields for the email but it does not say where exactly should I get the session value. I also read that Session and Cookies ar e logged by default by Elmah but I dont know how to access them.

View 2 Replies

C# - Session Variable Assigned To Data Table And Create Object Reference?

Jan 13, 2010

----> I have datatable which is passing to another page in session variable.
----> Now on another page i take the session variable into datatable.

datatable ds_table = new datatable();
ds_table = (datatable)session["table_value"];

----> so problem, is that , when i filtering some rows from ds_table . that taking effect in the session variable. if some rows deleted from ds_table. then it is also deleted from session variable.

----> so, anyone tell me why is this going to happene?

View 3 Replies

DataSource Controls :: Session Variable Causes Cast Error?

Jun 23, 2010

I get a casting error on line #8 below which reads "db.UserID = Session("UserID")". What would be the correct way to cast this? The datatype of the DB field is GUID.

[Code]....

View 4 Replies

DataSource Controls :: Unable To Use Session Variable In Sql Select Statement

May 26, 2010

I am new to all this, and ignorant beyond compare. I believe I have the same problem as this :

[URL]. However, the solution proposed for him doesn't seem to work for me. I have a session variable that 'march_cpi_session' that I wish to include in an sql select statement to multiply the values I get from a datatable before they're used to populate a gridview control. The session variable works fine elsewhere in my application, but causes a variety (depending upon how I fiddle about with the syntax) of sql errors. This is the currrent code:

[code]....

View 3 Replies

How To Store A Value Into A Session Variable And Load From That Value Back From The Session Variable

Nov 22, 2010

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 Replies

DataSource Controls :: How To Fetch Rows Based On Values In A Session Variable

Dec 23, 2010

How to Fetch Rows based on Values in a Session Variable

View 4 Replies

DataSource Controls :: Using Table Variable In Stored Procedure?

Feb 18, 2010

I've written a stored procedure which uses a table variable. The stored procedure is shown below:

[Code]....

The table variable @CaseNumbers is declared, and is a bunch of values are inserted using a table-valued function called SplitStringIntoInts. At this point I can select from @CaseNumbers and this works fine.But when I try to join onto @CaseNumbers, the name '@CaseNumbers' in the ON clause is highlighted with the error 'Must declare scalar variable @CaseNumbers'. What?! It's not scalar, I declared it ages ago and I have used it since!

View 3 Replies

JQuery :: Grab A Global Variable Or Session Or View State Variable In The Javascript?

Dec 9, 2010

can we grab a global variable or Session or View State variable in the javascript or using jquery?

View 2 Replies

State Management :: Public Variable Vs Session Variable To Store Logged In UserID

May 17, 2010

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.

View 10 Replies

C# - Temporary Or Session Variable - Want To Add A Decimal Number To This Variable

Dec 2, 2010

What would be the proper syntax in ASP.NEt 3.5 C# to assign a TextBox value to a temporary or session variable to be manipulated (added, subtracted, multiplied, divided) at different points in the application? I want to add a decimal number to this variable in almost every instance as well.

View 3 Replies

Which Is The Best Usage Session Variable Or Global Variable

May 25, 2010

I have the dataset. in this i am having total 20 tables with huge amount of data..I want use this data over all the page..so where i can keep this data..

before i used viewstate but the viewstate data is render to page every postback ..so this time the page size is increasing(interanlly viewstate is rendered to page)..so performence wise it was very slow..

Now i change my logic insted of viewstate to i used Globel Dataset on Page Level.. now the performence wise better than viewstate..

i used Like shared dsControls as Dataset at top of the page..so every time i use this dataset..

my quesation is session is better or Globel variable is better way use in my situavation..

View 3 Replies

State Management :: Global.asax To Load Up Several Session Variable When A Session Starts?

Sep 14, 2010

I added the following code to global.asax to load up several session variable when a session starts. I'm assuming that when a page goes to use the variable that I should be

1) checking at the page level that the value is valid not 0 when its not expected to be 0, not a zero-length string when its expected to have a length

2) have code at the page level that sets the values if the values have not been set as when the Session timeout, ideally putting the code in a class derived from Page and then deriving all of my pages from the new class so that the code does not have to be repeated in every page

[Code]....

View 7 Replies

State Management :: Session Variables And Tabs / Is There A Way To Reset The Session Variable

Nov 11, 2010

I have some code in my page load event where I just want to fire once when the user opens the Browser. The only issue is if you open a new tab with the same website the session variable does not reset. Is there a way to reset the session variable when you open a new tab or do you have to take the whole web browser down for it to clear the session variable.

In Global Page:

[code]....

View 2 Replies

State Management :: Session Variable Persisting Even After Abandoning A Session - Closing Browser Windows

Aug 5, 2010

I have been spending a better part of a week trying to track down why I am not able to clear all session variables in a web app (vs 2010, vb.net). What I have tracked it down to is that when I remove or abandon sessions that my html pages or codebehind access, it works, but for some reason in any of my class files where I use "Public Shared strConnection as String = HttpContext.Current.Session("strConnection").ToString" to access a session variable, it finds the old one and not the current one. I have to wait for it to time out, go in again, and it will find the new one.

I do not use Linq, and there is only one place in the whole web app that I place the connection string in a variable whcih is when a person logs in. It points them to the correct database. The sqlconnection is set for all of my listviews in Page_Init to make sure that they aren't using any session variable that they create on their own. Interestingly enough that if I use debug to go in each time, exit debug, enter debug again trying to access a different database, it works correct each time. I assume that debug is correctly killing the session variable for the classes for me.

View 4 Replies

AJAX :: Cascading Dropdownlists / Tried A Session Variable But It Comes Up With Session Is Null?

Jul 29, 2010

I have some cascading dropdownlists using the ajax toolkit I have a set up datatables in an xsd file. Then use these in a webservice to populate all the fields ... this all works great but now i need to pass an additional paramter to the first dropdownlist ( a date) but don't know how to do this? The method is below...

[Code]....

The other code is:

[Code]....

The first change would be to the tableadapter to add a param to the code i.e

AuditWebDS.TeamsDataTable teams = teamsAdapter.GetTeams(calldate);

but how do i get the calldate param to the webservice method... i tried a session variable but it comes up with session is null ? Is there another better way?

View 1 Replies

State Management :: What Is Session And What Is Session Variable

Apr 21, 2010

I am new to asp.net Can you please guide me what is session and session variables ? Please I don't need a comparision of asp session and asp.net session because I don't know anything about asp. I have saw many articles on types of session as well. But still I cant understand exectly what is session and what are session variables in asp.net ?

View 9 Replies

Web Forms :: Session Variable In VS2010 - Error "Session Is Not Declared"

Jun 15, 2010

I'm working on converting the TailspinSpyworks shopping cart Joe Stagner wrote in C# to VB using an evaluation version of VS 2010. I have the following public function:

Public Function GetShoppingCartId() As [String]
If Session(CartId) Is Nothing Then
Session(CartId) = If(System.Web.HttpContext.Current.Request.IsAuthenticated, User.Identity.Name, Guid.NewGuid().ToString())
End If
Return Session(CartId).ToString()
End Function

For Session in Session(CartId) I'm etting the following error: 'Session' is not declared. It may be inaccessible due to its protection level. For User in User.Identity.Name I'm getting the same error: 'User' is not declared. It may be inaccessible due to its protection level

View 7 Replies

DataSource Controls :: Variable Connection String Parameter In A DataSource Control

May 20, 2010

I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:

<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%&#36; ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%&#36; ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>

As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.

View 1 Replies

SQL Server :: To Pass A Table Type Variable To A Table-Valued UDF In SQL Server 2005?

Nov 25, 2010

I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?

My function name is udf_t_GetSales ( @financialYearMonthsData as table)

The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)

View 7 Replies

Two Different Users Seeing The Same Session Variable?

Dec 6, 2010

It has been reported to me that a user logs into our web application and after supplying the correct credentials for themselves, are taken to the next page where they see a different customer's name at the top of the screen.

All the data at the top of our web pages is stored in session variables. The login page executes a Session.Clear statement in the Page_Load event. The user enters a username and password which is validated against our supplied database via an SQL statement. Once the user is proven to be valid, session variables are set to hold the Customer's name, as well as a few other details about them.

This is a fairly simple application, consisting of only of about 10 different pages. I am only tracking about 5 session variables per user. The session variables are initialized to either 0 or "" in the global.asax file in the Session_start routine. Upon clicking a "log out" link on any page, the login page is displayed again (executing the Session.Clear statement).

We have roughly 400 users logging into this site about once or twice a week each. The site is hosted on a server running Windows Server 2008 R2 Standard and IIS 7.

Of all 400 users, this strange session behavior has only been reported to me on a couple of occasions.

I have tried to duplicate this behavior and have not been able to. Has anyone ever heard of this? Where should I be checking for solutions? I have already checked my SQL statement and database for user authentication to make sure it is working correctly.

View 13 Replies

Subtracting From A Session Variable?

Dec 3, 2010

I have a session variable with year stored in it and in my if condition I want to check if the current year is one less than the year in the session variable like this:

[Code]....

This isn't allowed though. It says operator '-' cannot be applied to operands of type object and int. How would I do this subtraction?

View 3 Replies

Session Variable Not Being Updated?

Apr 15, 2010

I have a three step wizard. On the first step I use a repeater to create a series of buttons that an individual can select from. When the user selects one of the buttons the value of the button is saved to session state. They are taken to the next step and shown a similar list of buttons that are based on what they previously selected. Thus, if you choose "Hamburger" you might receive the options of "onion", "lettuce", "tomato" while if you choose "Hot Dog" you might receive "sauerkraut" and "ketchup".Lets say an individual chooses Hamburger. This is saved into session state like so:

Public Sub Button_ItemCommand(ByVal Sender As Object, ByVal e As RepeaterCommandEventArgs)
' ******** Lets pass on the results of our query in LinqDataSource1_Selecting.
Session("food_select") = RTrim(e.CommandName)
Wizard1.ActiveStepIndex = 1
End Sub

Now, this works fine and dandy. But lets say I select hamburger and then realize I'm really hankering for a hot dog. I go back to the first wizard step and click on the hot dog button but when the wizard progresses to the next step I still see the options for hamburgers! The session variable has not been updated.

View 2 Replies

Session Variable Getting Lost?

Sep 22, 2010

Given this Global.asax.cs:

using System;
using System.Web;

namespace Foo.Web {
[code]....

User hits webapp and is shown Introduction.aspx

User continues using webapp for a few minutes (ASP.NET_SessionId: ublbhu45ji31e055ywqu0555)

User falls idle (doesn't perform any postbacks) for a few minutes

User performs postback

User is shown Introduction.aspx
Second inspection of user's ASP.NET_SessionId cookie still shows ublbhu45ji31e055ywqu0555

Why is the user shown Introduction.apsx the second time inside the same ASP.NET Session? I'm familiar w/ the risk in setting session variables just before a redirect in the same postback, but that doesn't apply here, right?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved