User Count With Sessionstate Set As Sqlserver?
Oct 25, 2010active users on my website with sessionstate set as sqlserver.
And what if a person closes his browser then how to maintain the user count?
Similar Messages:
C# SessionState Mode SQLServer Serialization With Protobuf-net?
Feb 12, 2011I have been thinking of ways to optimize the out of state storage of sessions within SQL server and a few I ran across are:
Disable session state on pages that do not require the session. Also, use read-only on pages that are not writing to the session.
In ASP.NET 4.0 use gzip compression option.
Try to keep the amount of data stored in the session to a minimum.
Right now, I have a single object (a class called SessionObject) stored in the session. The good news is, is that it is completely serializable.
Optimizing using protobuf-net An additional way I thought might be a good way to optimize the storage of sessions would be to use protocol buffers (protobuf-net) serialization/deserialization instead of the standard BinaryFormatter. I understand I could have all of my objects inherit ISerializable, but I'd like to not create DTO's or clutter up my Domain layer with serialize/deserialize logic.
Architecture :: Access SessionState - Via App1 To SessionState From App2?
Aug 21, 2010i'm interested to do the following - i geuss, i have no option to do that:
we have our "mainapplication" on a DB; we are tracking user-login status by switching a bit in the DB in the users data row.
we hvae a second application, the backend, which is the administration tool.
(the applications are put in seperate diretories on HD)
sometimes, we need to block/ban users. in some cases the users are logged in, when we "see them in action".
i'd like to build a button in the backend-application, which logss-out the user from the mainapplication.
for sure: i can access the same DB and switch the bit to "know" he's offline, but this will not kill the session on the mainapplication.
because: if a user is on/offline is also indicated by the session in the IIS. and as the IIS-session is active, the user may be already banned - but he will not be logged out automatically (and showing something like "you have been logged out because of a ban) one option would be to call the DB by each page-load to find out, if the user is logged on.
DataSource Controls :: Connect To Sqlserver - Invalidoperationexception Was Unhandled By User Code
Jan 6, 2010i am getting this error, trying to connect to sqlserver! senario! im trying to connect 2 tables with corresponding information.
eg: table 1 has (item no., picture and link) table 2 has (all the information pertaining to the item number and picture meaning when you click on the link it has to link you back to the same picture with more information about it! what could possibly be wrong??
DataSource Controls :: Reading Excel Files To Store Into Sqlserver Database - OleDbException Was Unhandled By User Code
Feb 1, 2010i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
Getting User Count From Database?
Jan 14, 2011Is the following code using good practices? All I want to do is get a count of the number of rows which any given user has:
objSQLCommand = New SqlCommand("select count(id) as record_count from table1 where user = @strUser", objSQLConnection)
objSQLCommand.Parameters.Add("@strUser", SqlDbType.VarChar, 3).Value = strUser
objSQLCommand.Connection.Open()
objSQLDataReader = objSQLCommand.ExecuteReader()
objSQLDataReader.Read()
intRecordCount = objSQLDataReader("record_count")
objSQLDataReader.Close()
objSQLCommand.Connection.Close()
Count Views Of A Page For Each User?
Apr 8, 2010I am trying to count page views for each user.
After 100 views, the user won't able see the page anymore.
At the end of the dat the counter will be reset.
I think of using the cookies, but it is very easy to hack.
How do I manage this the best way and reset every 24 hours the counter?
Count User Online When Opening Website?
Nov 16, 2010count user online when opening the asp.net website.
View 4 RepliesWeb Forms :: How To Prevent The User From Adding Count By Refresh The Page
Aug 3, 2010I have a web of ashx,in it
string ipSrc;
if (context.Request.UrlReferrer == null)
{
ipSrc = "";
}
else
{
ipSrc = context.Request.UrlReferrer.ToString();
}
string os=hbc.Platform;
string browserInfo = hbc.Browser + hbc.Version;
DAL.InsertData_OleDb(context.Request.ServerVariables["REMOTE_ADDR"], ipSrc, WebTitle, os, browserInfo);
SQL Server :: Returning Value By Comparing Row Count & Checking With User Name Not Working?
Mar 24, 2011I have Create user form through which i am creating thousands of users and generating unique user id's. If there are lot of concurrent users using the form then how should I display the new generated user id to user through stored procedure I have tried returning the value by comparing row count and checking with user name but its not working in fast way.I am displaying the user id on form itself.Any alternate solution for this?
View 3 RepliesForms Data Controls :: GridView_RowUpdated Event The E.OldValue.count E.NewValue.Count
Jun 4, 2010In the GridView_RowUpdated event the e.OldValues.count <> e.NewValues.Count. 1 out of 5 columns has been converted to a template field.
View 9 RepliesForms Data Controls :: Gridview Row Count / How To Get A Count Of The Number Of Rows That Are Returned
Dec 17, 2010When a user submits the query to SQL when clicking a button I need to get a count of the number of rows that are returned. Which event does the gridview.count code need to be place in?
Right now I have it in the btn_click event, but in order to get it to count the rows you have to hit the button twice since the query is not returned yet. Here is my code.
[Code]....
Data Controls :: Display Total Row Count And Count Of Specific Types In Label In GridView
Oct 5, 2012I HAVE A GRID VIEW IN asp.net + VB Code. There is a drop down list and the selected data is displayed in web page. I placed a label in web page and code behind i used following code.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
Label1.Text = GridView1.Rows.Count.ToString()
Dim ONYO As Integer = 0
Dim DONE As Integer = 0
For i As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(i).Cells(0).Text = "ON YO" Then
[Code] .....
Forms Data Controls :: Dynamically Load User Control Based On The Count?
Mar 17, 2010Im working with asp.net web application,I need to get multiple gridviews dynamically based on the count (which i get from database) for that i took a web user control and i added a gridview there . iwant to load that usercontrol in aspx.cs based on the count..
but im able to bind only one grid view...
VS 2010 For Loop - Count All Correct Answers Of User Based On Radio Button Click
Dec 9, 2014I am building this simple quiz application using asp.net/vb.net and sql server for the database. Now what I want to happen is that when I click on submit button, it will count all the correct answers of the user based on the radio button he clicks.
I have two radio buttons and the correct answer for those two radio buttons is A, now if they click both A for those 2 radio buttons, they will get a score of two else if wrong, it won't count the incorrect answer.
Code:
Dim score As Integer = 0
If RbAnswers1.SelectedValue = "A" Then
For score = 0 To lbCorrectAnswerCount.Text.Count - 1
score += 1
Next score
If RbAnswers2.SelectedValue = "A" Then
[Code] ...
How To Detect If SessionState Has Expired
Nov 9, 2010What would be the best way to detect if the SessionState has died in order to send the user to a "Session Expired" page? I've successfully configured the app (in Web.config) to do this when the authentication cookie is gone (there's a setting for that), but so far I haven't found an effective way to do something similar when the SessionState is gone. The app in question holds some data in the Session, and should present the user with a "Session Expired - login again" page if any of them is gone.
So far, the only option I can think of doing it in each of the places I access Session, but this is obviously a less than optimal solution.
C# - Comparing Viewstate And SessionState?
Jul 7, 2010I set ViewState["zzz"] and Session["zzz"] to the same string.
When I compare using == I get false.
When I do ViewState["zzz"].Equals(Session["zzz"]), I get true.
In the debugger, both their values show the same string, and when I do
? ViewState["zzz"] == Session["zzz"]
I get false.
I thought the ViewState StateBag Item defaults to the set value and the Session Item defaults to the value as well?
C# - ApplicationState Expire Like SessionState
Dec 22, 2010There is a timeout for Session object of HttpSessionState that can be set. I want to see if we can make HttpApplicationState timeout too?
View 2 RepliesC# - SessionState Timeout Never Fires?
Nov 26, 2010What am I doing wrong. The sessionState Timeout never fires,It only fires after 24 hours, I want to let it fire in 20 minutes on my webpage. In the web.config I handle the sessionstate like this:
<sessionState cookieless="false" mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
timeout="1" stateNetworkTimeout="1"/>
timeout="1" is on purpose, for testing.And in the code I check on which session I am by calling Session.SessionID.ToString()
C# - Sessionstate Not Being Saved Between Pages?
May 3, 2010i am having problems with an asp.net c# site whereby i am setting a session state object to true and then redirecting to another page that needs to check the value of the session state object and it is null.
Sometimes it is set correctly and other times is is simply null.
When i debug on my local machine it works perfectly every time. Only when i upload to my web server does this temperamental behaviour happen.
As it is based around the security of the site it is obviously important that the session data be valid and accurate every time.
Is session state data unreliable?
AFAIK its set to inproc, cookieless, 30 min timeout, vanilla installation of IIS.
Does anyone have any suggestions? Perhaps i need to thread.sleep inbetween the storing of the session data and the reading?
NB: the time between the write and the read is about 70ms.. ample time for the data to be written to RAM.....
Does The SessionState Attribute In MVC 3 Work Properly
Feb 11, 2011I'm managing a rather large project, written in asp.net webforms + mvc3, with a large user base, and a pretty high daily visitor count. Basically, there are a lot of requests at any given moment.
One of my controllers in MVC that handles / resizes images on the fly has the following attribute applied to it:
[SessionState(SessionStateBehavior.Disabled)]
Now, if an action in the controller tries to access the session - it obviously throws an exception - so we're good so far. The problem is: if I go to the IIS Worker Processes window (Win Server 2008 R2, IIS 7.5), and check the current requests for this site, I can sometimes see the requests to an action in this controller. Their current state is locked in State: RequestAcquireState, Module Name: Session. Sometimes these locks go over a second or two in this state.
Wasn't the whole point of the attribute in the first place to make the requests to the controller ignore the state, and not waste time (and possibly being locked) trying to acquire the state? If this is so - am I doing something wrong here, or does the problem lie elsewhere?
State Management :: SessionState Across Frameworks?
May 13, 2010[Code]....
From my understanding, the asp.net 1.1 application will login the user then store the information to a session and a cookie? I'm trying to access that cookie with a asp.net 2.0 application. Is this possible?
I'm thinking the mode would need to change to maybe StateServer or Sql.
Web Forms :: SessionState Is Null For IRouteHandler GetHttpHandler()?
Dec 9, 2010I'm having a problem with getting a valid Session object in the GetHttpHandler() method of a IRoutHandler. Here is my code:
[Code]....
No luck, Session is still null.
Configuration :: Trying To Config Application To Use Out-of-process SessionState?
Oct 18, 2010I am trying to config my application to use out-of-process sessionState.
<sessionstate mode="stateserver" cookieless="false" timeout="20" sqlconnectionstring="data source=127.0.0.1;user id=<user id>;password=<password>" server="127.0.0.1" port="42424" />In my web.config I get errors for the server and port attributes, telling me that server attribute is not allowed and port attribute is not allowed.
Configuring SessionState With Remote ConfigSource File?
Nov 24, 2010In my web.config I have:
<sessionState configSource="SessionState.config">
</sessionState>
In SessionState.config I have:
<sessionState timeout="90" mode="SQLServer" allowCustomSqlDatabase="true" cookieless="false" sqlConnectionString="Data Source=.;Persist Security Info=True;Integrated Security=True">
</sessionState>
I've tried various incantations but can't seem to get it to work. I get this error:
Parser Error Message: Unable to open configSource file 'SessionState.config'.
From MSDN:
Of course they don't show an actual example.
I verified that the file is in the bin directory. I also have this working fine for the connection strings section.
How do I use a remote config file for sessionState?