I have a web application ASP.NET
I need to know how can I list the users online? I hope that you can direct me into a solution for this question.
I have a login page login.aspx and this is how I validate the user
Dim strConnStr As String
Dim Cnn As New OleDb.OleDbConnection("Provider=SQLOLEDB.1;data source=192.xxx.xxx.xxx . etc......")
Dim Mycmd As New OleDb.OleDbCommand("select * from users_tbl", Cnn)
Dr = Mycmd.ExecuteReader()
If Trim(UCase(Dr("Usercode"))) = Me.txtUserID.Text.ToUpper Then
If Trim(UCase(Dr("UserPass"))) = Me.txtPassword.Text.ToUpper Then
'Now we need to load the sesstion Variables
Session("UserID") = Trim(Dr("UserCode")).ToUpper
Is there is a way that I can display a list of all users logged in to the site. If you can provide a sample code it will be greate or direct me to the proper direction.
NOTE: I'm using a SQL server that has users_tbl to validate the user login and I also post the time/date of their login.