ASP.NET Discussion - ASP.NET (c#)

Print Page | Close Window

ASP.NET (c#)

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25768
Printed Date: 28 March 2026 at 4:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP.NET (c#)

Posted By: gangla
Subject: ASP.NET (c#)
Date Posted: 28 May 2008 at 3:02pm

Am coming up with a web based application which requires users to log in and see issues assigned to them by an administrator.The issue table is one containing all the users and details assigned to them.How do i come up with the application to allow each user to see only see issues assigned to him or her using ASP.NET (c#) AND SQL Server Database 2005.

Replies:

Posted By: jamie.townsend
Date Posted: 01 June 2008 at 3:44am

Well, when a issue is added I am guessing you choose which user to assign the issue too.

This could be a drop down box or a textbox which ever is easiest.

This can then have a value of the ID number of the user.

Then when that user logs in you can do a sql statement for all issues assigned to his ID.

Example:

Select * from tblissues where userID = "&session("userID")&"

Hope this helps

Posted By: gangla
Date Posted: 07 June 2008 at 9:42am

Thanks for the idea,but how are sessions raised and handled in ASP.NET based on for example a UserID.
Please assist and thank you once again.