Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - ASP.NET (c#)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ASP.NET (c#)

 Post Reply Post Reply
Author
gangla View Drop Down
Newbie
Newbie


Joined: 28 May 2008
Location: Kenya
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote gangla Quote  Post ReplyReply Direct Link To This Post Topic: ASP.NET (c#)
    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.
Back to Top
jamie.townsend View Drop Down
Groupie
Groupie


Joined: 07 December 2007
Location: England
Status: Offline
Points: 114
Post Options Post Options   Thanks (0) Thanks(0)   Quote jamie.townsend Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
gangla View Drop Down
Newbie
Newbie


Joined: 28 May 2008
Location: Kenya
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote gangla Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.