Jump to content
xisto Community
Sign in to follow this  

[help] Asp .net With Ms Access Database And More

Recommended Posts

Heya guys, i need your help again. This time its in ASP .NET with Access DB. It just keeps getting annoying B) aint it ?


Newayz, i am attaching the file i have done so far from various sources and help from people around me. My friends who have worked with asp .net have used SQL as the backend and never used access. Well i dont blame them, its a smart choice. But because i choose to use access in my VB .net application i have to use it here in asp .net too.


Concept of the website is simple, the DB provided in the attachment is pretty self explainatory, but to give you a jist of it, this is a website for the colleges. Each college would have a userid and password that would allow them to get into exclusive areas of the DB. By this i mean for example, i have a University table that has some fields. The university that logs in should be able to view ONLY its own DB and should be able to update/edit its records. The university table would NOT allow addition of records.


Posted Image


On the other hand the Student DB would allow addition/updation/deletion of records. Only in that university. For example:


University X has logged in and wants to add students, then under the college field on this page, the university name "X" should be readonly and all the students added should get into the student DB.


Now university Y logs in, so all the students it adds should go under college field "Y"


Posted Image


My logic might differ from yours so please feel free to critisize me and correct me. I have no idea A-Z of asp .net but with the little knowledge i knew in 2 days i figured out from sql examples of how to connect an access DB and check values, but as i go further it keeps getting complicated. If possible please comment every line of connecting a DB to addition .. updation .. refreshing of the page etc, because i have connected the DB alright but to be honest it was a fluke from the huge amount of sources i had in hand.


Probably will be getting a asp.net book tommorow from a friend so will check that out too, but at this time with the deadline over my neck, i need fast and eazy to understand help.


Hope to learn from you guys.



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.