[URL] ....
By using above query its fine to save logout time in database, if the user unfortunately close the browser without logout then how to store logout time in database...
I want to kill the session on the browser closing or tab closing and store the Logout time in database using Asp.Net.
I have coded that code in Global.asax page which works only when we Click on Logout Button .but it's not worked on the tab closing /Browser closing.
void Session_End(object sender, EventArgs e) {
SqlTransaction transaction = null;
using (SqlConnection con = new SqlConnection(conn)) {
con.Open();
SqlCommand cmd = con.CreateCommand();
transaction = con.BeginTransaction("Transactions");
[Code] ....
I want to save log out time when user close the Browser without clicking log out button using asp.net with C# and SQL server 2005.
kindly let me know the way as well as code..
I have written custom code for login and logout...When use clicks on logout button the current session is closed and user is redirected to a login.aspx page...The problem is that when a user click a back button on internet explorer it the previous page he was navigating is shown to him...(altough he cant perform any operation as session is null and their is condition in page load that if session is null user should be redirected to login page)May i have to clear cache of client ??
View 3 RepliesIf Someone has logged in to website and directly closes the window without clicking signout button where i have written a code to clear all session.
So in this case how i clear a session when user closes window directly?
My program need to detect the user visibility, if the user is login or not. I Put the information on the database
here the pseudocode:
if the user click "LOGIN" I Update the user information to ONLINE = TRUE;
else if the user click "LOGOUT" I Update the user information to ONLINE = FALSE;
My Question is: How can I detect if the user leave the website or turn off the computer without clicking "logout"
How to kill the session when Browser closed/page closed.
View 1 RepliesI am using Wizard Contorl in one of my project, I want to maintain the state of the wizard control at any step .Let me explain further , let suppose when user is at Step 4 out of Step 10 and then user would close the browser so the state should be persisted and when the user come back again to the same URL the step would be 4.
View 1 RepliesI want to store Session Data after Close browser.
View 1 RepliesI have created a registration form where a User can fil up basic details and submit it.When user submit form a system generated username & password sent to user's mailid. Then user can login using that username & password.Once the user logged out from his account, get redirected to sign in page, but if he clicks on browser's Back Button then again it's profile page get opened.How should this can be stopped, Even if user clicks on Browser back button once he logged out he must have to sign in to view his profile page.
View 1 RepliesAfter about 10 mins my web app will give me an error when i logout or try to save page. I have the sessions set and dont understand why I get this problem.in webconfig i have this.
<system.web>
<sessionState mode="InProc" timeout="60"/>
login
username 01
pswd 1 .
go to any page and sit there for 10-20mins or just leave it logged in and try to logout after 10-20mins[URL]
[Code]....
I have issue about multiple login in asp.net.
Case this happen:
User X login as "user1" in web browser.
Then user Y also login as "user1" also in another web browser.
User Y got error message "Another user log in some account".
That is work as expected.
If X, close their web browser. Then try again to login in as "user1".
X get also get "Another user log in some account".
So i trying debug then i found session is remove when web browser is close, but cache still remaining in web browser.
how to clear cache when user close their browser, (not tab).
How does session expires when the browser is closed?
View 4 RepliesI have written a SP which maintains users log in and log out history,it works fine when any user logs in or clicks on log out, problem is that as per need its not to allowed to keep the screen idle for 1 minute or more then in the log out column Null value is passed.
SP
Create proc usp_trackuserlogindetails
@username varchar(50) = null,
@command int = 0
as
BEGIN
if(@command = 0)
begin
insert into userlog (USERNAME,LOGIN,LOGOUT) values (@username,Getdate(),Null)
[Code] ....
Here when user manually clicks the log out button then 1(table above) is the output.
When user leaves the screen idle then after 1 minute the page goes to the Login.aspx page if the user tries to do something on the current page,here 2(table above) is the output can i store some hard core value instead of Null like Session expire or the exact session expires time.
When the browser is closed (w/out clicking on log out) and user launches the site using a new session, it does not prompt user to login credential page, rather it takes the user back to the previous session.
View 1 RepliesI am working on roles. Allocated some tasks to Annonumous User and LoggedIn User. What happen, once I login it shows me the correct task for LoggedIn user. But if I restart the application then by default it shows me LoggedIn users tasks. I am testing chrome and I.E.
View 1 RepliesI have two asp page first is login page. I enter username and password then after submit click goes second page their is a logout option. then thr URL of second page is copy and paste in another browser then it will second page it is not logout,I want to after paste URL it goes Login page.
View 1 RepliesI need to perform an operation such as extracting the data for past one year from DB and doing some manipulations and finally displaying the excel graphs for the extracted data. The extraction of data takes almost 6-7 hrs. What i require is that user enters the required data (date and some other details )through an asp.net page and submits it and then closes the browser. Now a process should get started which will extract all data and create the graphs and finally send an email to the particular user.
View 6 RepliesIt seemed to keep the session cookies from staying on the client after the browser was closed. Another strange this is that I can close the IE and open FireFox and the session is in there too. HOW IS THAT? I am thinking it is how my environment is setup. I have the sessions set for InProc and using cookies in IIS. What is different in IIS7?
Update: I am using integrated mode for my app pool. I looked at an older site I created using .net 3.5 and iis6 running on Sever2003. I can log into the site and it creates the session variable for me. I then go to FireFox and open the same site. It requires me to log in (my application will take you to your prfile if a session exists). If I then close IE and reopen IE, then go back to my site, it requires me to log in again. What is happening with iis7 and my current application, is quite odd. The only difference in how my session is pulled is that I am getting the variable while casting the current handler to the Page object: (Page)HttpContext.Current.Handler
Update: well, I think i found where the issues is and it has to do with casting the HttpContext.Current.Handler to the current page object. I have a configuration file where I wanted to put a property so all other classes could reference a central point to grab the User session object I created. The HttpContext.Current.session was always null and someone had suggested casting the HttpContext.Current.Handler. I created a simple page that checks to see if a session varaible has been created and if not it creates it. Then I print out the value. When I close the browser, the session is GONE. So, that is working. The code I had origianlly in this message was really for the back button, So I guess it is not clear why that session pulled from the Hnadler is always available until I speicifcally clear it.
I have started using an SQLState server to store my objSessionData object and many more session data.
<sessionState mode="SQLServer" sqlConnectionString="Server=**********;UID=*****; PWD=***" cookieless="false" stateNetworkTimeout="20" timeout="60" />
I open two browser, log into the application, proceed in a few pages to store some information in the objSessionData for both browser (2 differrent session).If I close the first broswer, and now keep on going on the 2nd broswer, everything that was in session is now lost.It looks like Session 1 detroyed session 1 and session 2.I have tried to change the cookieless to TRUE and when it is set to TRUE, I do not get this problem at all.
I am doing office management system in web. here i want to display the employee login and logout time in calender (like reminder notice) every day. how to display all the database value to calender date wise.
View 2 RepliesI want to allow user to save time ..... How can I manage the time.....
I mean How I will provide interface to user to insert time ...How will I manage in database...
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesThis is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
how to avoid viewing the last page visited by the user after logging out.
View 2 Replies