473,804 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query for active SessionID

I need to provide a feature which will control access to data within my ASP.Net application. This is an age old problem of locking for edit. While there are many possible ways to solve this, in this case I wish to write the SessionID to a user table in SQL Server, along with the editing user's name. As long as the session is active, all other users will be allowed read access to this data. Once the editing user exits the edit, this record will be cleared to allow the next edit. This is fine if we exit gracefully. However, if the session is lost for whatever reason, this record must be cleared. The app timeout length can vary, and I do not wish to depnd on it

What I would like to do is this: User A acquires lock, SessionID is written to the lock table. User B attempts an edit, A's lock is seen. In order to validate that A is still active, I wish to ask ASP if the SessionID is still active. Is there an API call that I can use to perform this, even something from an obscure library, such as a debug API
Nov 18 '05 #1
2 1498
You really need a fat-client solution if this functionality MUST be implemented just so.
Nov 18 '05 #2
This cannot be a fat-client solution. My app calls a WebService that could read the database records and should be able to make an API call I believe?
Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1561
by: Lepa | last post by:
I'm trying to run this query and I think I know where the problem is: ------------ in select (SUM(C.Score * C.Weight) / SUM(C.Weight * C.MaxScore)*100) AS SC ...... HAVING ((SUM(C.Score * C.Weight) / SUM(C.Weight * C.MaxScore) * 100) > 30) AND ((SUM(C.Score * C.Weight) / SUM(C.Weight * C.MaxScore) * 100) < 75)
1
1486
by: yaroni | last post by:
Hi all, I have the following tables: A1 == HostID Name RunID ------ ---- ----- 1 host1 NULL 2 host2 1 3 host3 NULL
0
273
by: Roger Stavcode | last post by:
Is it possible to point current context's session to another active session based on a SessionID? Thank you STAVCOQ
7
3867
by: Christina N | last post by:
I want to output a list of all active SessionID's and their last time of activity. Can I loop through the active sessions and create a list like that? I use ASP.Net (VB.Net) Best regards, Christina
0
995
by: Andre | last post by:
Hi, I'm using a PCOMM AutSess instantiated class to establish a session with an IBM host (S/390) from within an Excel spreadsheet using: session.SetConnectionByName Not sure how long this session lasts. On subsequent reruns of the VB app (embedded in the spreadsheet), I get errors returned from the above method. Would seem that the session is still established/active. Even checking session.Started and session.Active gives errors. ...
9
2310
by: Laurent Bugnion | last post by:
Hi, I am wondering what is the best way to find out which ASP.NET sessions are still active. Here is the reason: I have a custom control which can upload files. It saves the files in a folder named after the SessionID. At Session_End, I do some cleanup and delete the "session folder". However, if the PC is rebooted before the session times out, the clean up never happens. So what I wanted to do isL: In my CleanUp method, check all...
0
5984
by: XML newbie: Urgent pls help! | last post by:
I am using VB.Net. My program is to connect to a remote IPAddress. Once, it verifies the login information it should display the SessionID and enable some button . I appreciate your help and thanku in advance When I run the pgm , I get the error: Can't parse login information. Namespace Manager or XsltContext needed. This query has a prefix, variable or userdefined function. I have added the Try-catch in all my functions. In...
23
2794
by: mlcampeau | last post by:
Hey guys, I have been mulling over this problem for a few days and have yet to come up with a query that will give me the expected results. I am working on a database that stores employee information, and my boss has asked me to add a component that will keep track of job vacancies as well. I have 6 tables that are all linked: Table: Employee 1. ID; Text; PK 2. ... (the rest are irrelevant to the query) Table: EmplStatus (linked to...
1
1090
by: sajin | last post by:
Hi I have 3 tables in my database. Students , SessionTable and Campus. Table campus have two fields CampusId and CampusName and SessionTable have two fields SessionId and Sessioname and the tble student have12 fields they are
0
9716
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9595
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10604
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10354
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10101
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6870
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5675
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4314
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3005
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.