Jump to content

Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Toggle shoutbox Shoutbox Open the Shoutbox in a popup

@  yordan : (14 April 2014 - 05:28 PM) By The Way, This Could Be An Interesting Subject For A Topic, What About Posting This Question? Let's See If Other People Have The Same Feeling Concerning Bootlists!
@  yordan : (13 April 2014 - 09:36 AM) Boot Order : Cd, [Usb,] Hard Drive :D
@  yordan : (11 April 2014 - 07:23 PM) I Simply Let The Bios Do That
@  Ritesh : (11 April 2014 - 10:23 AM) Is It Possible To Launch Fedora Live Cd Or Installation Disk From Hard Drive On Windows Platform Using Grub Mbr File.
@  Ritesh : (11 April 2014 - 10:21 AM) No U Are Not.. Btw.. I Have Question For You.
@  yordan : (10 April 2014 - 08:02 AM) You Are Partially Right.
I Was Not.
Nevertheless, I Am Again :)
@  Ritesh : (09 April 2014 - 07:33 PM) :P
@  Ritesh : (09 April 2014 - 07:33 PM) I Think U R Not..
@  yordan : (09 April 2014 - 09:28 AM) I'm The Master Of The Shoutbox!
@  yordan : (05 April 2014 - 10:32 PM) He-He
@  Ritesh : (04 April 2014 - 06:59 PM) Ha Ha Ha ....
@  yordan : (04 April 2014 - 11:15 AM) Welcome Back, Starscream!
@  yordan : (03 April 2014 - 02:31 PM) And I Hope That He Will Come Back Soon :)
@  yordan : (01 April 2014 - 02:53 PM) Nice, Ritesh Came, I'm Not Home Alone Today.
@  Ritesh : (01 April 2014 - 08:51 AM) Oh!!! Poor Dear Yordan..
@  yordan : (31 March 2014 - 10:02 AM) I'm A Poor Lonesome Cow-Boy
@  yordan : (27 March 2014 - 02:22 PM) He Is Unpatient Due To His Patients!
@  Ritesh : (27 March 2014 - 10:46 AM) :(
@  Ritesh : (27 March 2014 - 10:46 AM) He Is Busy With His Patients.
@  yordan : (26 March 2014 - 08:12 PM) Ahsani, Where Are You?

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

Post Options

    • Can't make it out? Click here to generate a new image

  or Cancel

Topic Summary


Posted 06 May 2007 - 04:38 PM

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.

Review the complete topic (launches new window)