 |  |  |  |  |  |  |  |
Reading and comparing data from 2 tables
Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Mar 2008
Posts: 269
Reputation: 
Solved Threads: 19
Posting Whiz in Training
I am designing a Library website, and I have two table Libarian and Student table so when the Libarian login should have access to all the database(Adding new record, updating and all) but when the student login should only view the database without changing anything, so What I want to know is how do I read from those two tables and see who has logged in so that I can provide him/her with suitable information, I understand that I need to read from both tables everytime a person login then determine if the person is a student or a Librarian then give the person the access s/he deserves in the website
I hope that makes sense
I hope that makes sense
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Oct 2008
Posts: 2,721
Reputation: 
Solved Threads: 501
Design two pages : one for librarian and another for student. Configure Form authentication & authorization.
•
•
Join Date: Mar 2008
Posts: 269
Reputation:
Solved Threads: 19
Posting Whiz in Training
I dont think thats gona work coz this is gona be online website, so I will only have one login page for everyone coz there is gona be no way to determine who clicked the login button now between the librarian(who is responsible for the database and signing in and out the books) and the student who is gona browse thru the database checking if the books s/he needs are available and reserving them if they are not
Last edited by Traicey; Jun 2nd, 2009 at 11:00 am.
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
Where are you storing the log on details? Just hold all the logon information in on table e.g.
UID
Username
Password
AccessLevel
Create a different access level for librarians and students
and when the user logs in, depending on what their access level is you can allow/deny access to pages and so on.
UID
Username
Password
AccessLevel
Create a different access level for librarians and students
and when the user logs in, depending on what their access level is you can allow/deny access to pages and so on.
Please mark this post as 'Solved' if it has helped and fixed your issue.
aren't you making it mandatory for the student to login to the site before browsing through the lists ?
•
•
Join Date: Mar 2008
Posts: 269
Reputation:
Solved Threads: 19
Posting Whiz in Training
No, The student can reserve a book which is on loan so to do that the student needs to login, otherwise they can browse for books without logging in, sometimes there are articles or journals which are exclusively for members of the library
if you know what I mean so what I need is a sample code to do that or maybe just a clue on where to start
if you know what I mean so what I need is a sample code to do that or maybe just a clue on where to start
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
|
Similar Threads
- Join Two data tables (C#)
- Insert data into two tables using php and mysql (MySQL)
- Reading and comparing a file (Java)
- reading a specific data in .txt file to put in specific tag in xml in vb.net (VB.NET)
- reading column data (Python)
- Using Visual Fox Pro data tables in asp.net application (ASP.NET)
- Reading from external data file (C++)
- Internal Data Tables (Visual Basic 4 / 5 / 6)
Other Threads in the ASP.NET Forum
- Previous Thread: need coding for menu bar
- Next Thread: Vanishing Excel tab issue (ASP.net)
Views: 593 | Replies: 5
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 ajax alltypeofvideos anathor appliances application asp asp.net beginner box browser button c# cac checkbox commonfunctions complex connection control dataaccesslayer database datagridview datalist deployment development dgv dialog dropdownlist dynamic dynamically edit editing embeddingactivexcontrol feedback fileuploader fill findcontrol flash form formatdecimal gridview gudi iis image javascript languages list listbox login microsoft mobile mouse mssql news novell numerical opera panelmasterpagebuttoncontrols parent problem project radio redirect registration relationaldatabases reportemail response.redirect richtextbox rows schoolproject search security select session sessionvariables silverlight smoobjects software sql sql-server sqlserver2005 ssl theft tracking treeview validatedate validation vb.net videos vista visualstudio web webapplications webarchitecture webdevelopment webprogramming webservice xsl youareanotmemberofthedebuggerusers
