thanx a lot, will try the 1st option.

hi im doing an asp.net website with a login system for its users. i used a table in sql to maintain a record of user details.when a user logs in , i set a flag to 1 and when they click the logout button , the flag is set back to 0. my problem is if the user closes the browser window or for some reason the system crashes , that user still remains logged in. i have 2 go to the database and set the flag. please suggest some way to solve my prob. thanx

We are doing a project in asp.net 2.0 with sql server 2005,we need to move to the next record at the click of a button.We are using an sql datareader,we have one button 'show',to show each record,and in the page load, the following code is there: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load regid.Text = "1" mysql = "select que_bank.que_no,que_bank.ans,testquestions.ans from testquestions,que_bank where que_bank.que_no=testquestions.que_no and testquestions.reg_id='" & regid.Text & "'" cmd.CommandText = mysql myconn.Open() objdr = cmd.ExecuteReader() End Sub Protected Sub show_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles show.Click objdr.Read() queno.Text = objdr.GetValue(0) cans.Text = objdr.GetValue(1) urans.Text = objdr.GetValue(2) End Sub Can anyone help us?

[Message Deleted]

ur saying that i should create a flag field in my database , and everytime a user logs in set flag to 1, and then on logging out set flag to 0.right? is there any easier way?

im developing an online test application using ASP.NET , IIS 7.0 is the server and SQL 2005 is our database engine. the user for a test must login first. i used session id s and variables to store names and login logout. but im having a problem with authentication .if on one computer im logged in as raj , then from a different computer i can still login as raj. how can i maintain unique logging in of users.really stumped. please help.