Course Finder - Search Colleges and Courses


Posted Date:     Total Responses: 0    Posted By: Tony John   Member Level: Gold   Points/Cash: 10   


Please register yourself as a member in IndiaStudyChannel.com and submit information about your college and add photos to get additional support in this project. We can give you the latest version of this project if you have registered as a member in IndiaStudyChannel.com and posted information about your college like photos, classmates etc.

The live website (http://www.IndiaStudyChannel.com) is modified little bit from the sourcecode provided here. Some of the changes in the live website includes additional security, search engine optimization and changes for performance improvement. Lot of queries used in this project are converted to stored procedures in the live site for better performance. For simplicity, we have provided the source code of the basic version.

You may download a more recent version of this project from MCA Projects section in IndiaStudyChannel.com.


How to install the CourseFinder project



Download the IndiaStudyChannel zip file and extract in a convenient folder. Right click on the folder “IndiaStudyChannel" and select properties.
Select the tab web sharing. Choose the option “Share this folder". This will make it a virtual folder.

Extract the zip file indiastudychannelDatabase.zip. This will extract a file called indiastudychannelDatabase.bak. This is the backup of an
SQL Server database. Restore this backup to your SQL Server. ( To learn more about SQL Server backup and restore,
visit our SQL Server tutorials section.)

Project Features



CourseFinder project offers the following features:

• Register (New users)
• Login (Existing users)
• Edit profile
• Change password
• Colleges - search for colleges
- Courses - Find courses in the selected college.
- Classmates - Find students studied in the college. Search by academic year or student name.
- Photos - View photos from the selected college.
• Courses - search for courses and find colleges offering the course.
• Universities - search for universities and find colleges affiliated to the university.

Database Tables



Even though the live website uses some stored procedures for performance reasons, we have used dynamic queries in the source code provided to make it simple for beginners. Below are the tables used in the database:

Members - information of all registered members.

Colleges - master table where details of colleges are stored.

Universities - master table where all university name & details are stored.

Courses - master table where all course names are stored.

CollegeCourses - In this table, we store the college Id and the Ids of the courses offered in the specific college. If one college has 5 courses, then this table will have 5 rows for that college. All 5 rows will have same college id and different course ids.

CollegePhotos - In this table, we store the college Id and the Ids of the photos attached to the specific college. If one college has 10 photos, then this table will have 10 rows for that college. All 10 rows will have same college id and different photo details. We are storing the photos in the hard disk as a image file and only the file path is stored in this database table.

Classmates - Each member can select the college he has studied in the past and enter information like year completed, course studied etc. We store such
information in this table along with the member's user id and college id.

Countries - master list of all countries so that users can select the country while registering.

You may download complete source code and database backup by using the links provided in the top of this page.

Feedback

Please submit your feedback about this project using the link below. You can post
questions and comments. We will try our best to update this page or provide answers directly to you.

Attachments

  • 2--1593--IndiaStudyChannel.zip (2--1593--IndiaStudyChannel.zip)
  • 2--1597--IndiaStudyChannelDatabase.zip (2--1597--IndiaStudyChannelDatabase.zip)


    2--15911--Colleges.JPG



    2--15911--Homepage.JPG



    2--15912--KonguEngineeringCollege.JPG



    2--15912--Universities.JPG


  • Project Feedbacks

    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Thank u
    its helpful


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    can anyone provide me documentation of the project?

    its urgent please


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    It's realy nice project but how can i deployed it?


    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    Hi,,
    This is Anandh..
    CAn anyone send me the documentation,Database tables of the course finder project to my mail..

    My mail ID : Anandh.ct23@hotmail.com...
    Please send it..i need it very urgently...


    Author: Member Level: SilverRevenue Score: 1 out of 5
    cool good one


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    I want course finder database.iam unable to attach the database


    Author: Member Level: SilverRevenue Score: 3 out of 53 out of 53 out of 5
    Hello This is hanumanth

    how to add college photo into sites
    i tried using admin userid and password buts it displaying only admin can add photo please give details about this ...

    my mailid = hanamant.s@gmail.com




    Author: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    hi in the database also chcked amdin user id and password i enter same thing to
    after login it alloving enter a photo into project please tell how to use........


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi, this is jagriti its really very nice project
    but I m unable to see this database pls help me
    could u send me database details on my id
    thanks
    Jagriti06@gmail.com


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Hi,

    It's nice project for programming learner.


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Hi,

    This project will be helpful for every user.


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hi,,,,,,,
    it is really good project for new programmer.


    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    I have downloaded this project for about five months now, but it is a pity that I'm able to run it. Though, I'm a beginner but I think somebody in this forum should be able to advice me on what to do. I will really appreciate it if someone will come to my aid.

    Olufemi
    Nigeria


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Thanks, its nice project.

    ---------
    Mustufa Lotiya


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Timmy

    Nice Job

    Thanks for Posting the source Code

    thank you very much

    Nushrat Ali Tyagi



    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    Hi

    Very good..............

    actually i have to develop website for my company.

    have u any company website project?

    if have then

    plse send me company related websites

    project on this email id:- roushan85@gmail.com


    Thanks



    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    @rocky

    go to OPTIONS and make sure that both the Data path and the log path (And .MDF/.LDF names) are OK and unique.

    Alternatively, create the path *C:\Program Files\Microsoft Sql Server\MSSQL.1\MSSQL\DATA*.


    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'C:\Documents and Settings\Srinath\Desktop\IndiaStudyChannelProject\IndiaStudyChannelSite' because access is denied.

    Source Error:


    [No relevant source lines]


    Source File: C:\Documents and Settings\Srinath\Desktop\IndiaStudyChannelProject\IndiaStudyChannelSite\web.config Line: 0

    plz can help me how should run this project



    Author: Member Level: GoldRevenue Score: 1 out of 5
    This is really a very good project for last semester project for those who continuing their tudy.


    Author: Member Level: SilverRevenue Score: 1 out of 5
    HI very nice .. very helpful


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,
    Really very nice project.
    I want to develop such sort of project,it would be helpful for me to modify it and some more feature.
    Keep posting such valuable projects .


    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    Hi,
    Even i am also getting same thing

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'C:\Documents and Settings\Srinath\Desktop\IndiaStudyChannelProject\IndiaStudyChannelSite' because access is denied.

    Source Error:


    [No relevant source lines]


    Source File: C:\Documents and Settings\Srinath\Desktop\IndiaStudyChannelProject\IndiaStudyChannelSite\web.config Line: 0

    plz can help me how should run this project



    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,
    Its really nice. I would like learn such type of things.

    It will be greatful for me to send the files.

    Thanks Rakesh,
    Siva Sreenath


    Author: Member Level: SilverRevenue Score: 4 out of 54 out of 54 out of 54 out of 5
    hi..i hav dwnloaded the ZIP folders (2--1597--IndiaStudyChannelDatabase.zip)for IndianStudychannel prjct but unable to restore the database (.bak) file...it is giving error saying:
    Restored Failed: Directory Lookup for the file "C:\Progfile\...\MSSQL\data\CourseFinder_Data2.MDF" failed with Operating system error3.....

    how to solve this and restore the database...pls help..thanks in advance...


    Author: Member Level: SilverRevenue Score: 4 out of 54 out of 54 out of 54 out of 5
    hi..i hav dwnloaded the ZIP folders (2--1597--IndiaStudyChannelDatabase.zip)for IndianStudychannel prjct but unable to restore the database (.bak) file...it is giving error saying:
    Restored Failed: Directory Lookup for the file "C:\Progfile\...\MSSQL\data\CourseFinder_Data2.MDF" failed with Operating system error3.....

    how to solve this and restore the database...pls help..thanks in advance...


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,

    Is is good project for project.In the database there is no diagrams to create relations and no storedprocedure if u provide these two then that ll be beter for lerners.




    Author: Member Level: SilverRevenue Score: 1 out of 5
    Nice Project. It is very useful to me


    Post Feedback
    You must Sign In to post a feedback.
    Previous Project: Library Management System

    Return to Project Index

    Post New Project



    Top Contributors
    Today
      Last 7 Days
        more...

        Awards & Gifts

        Online Members

        More...
         
        Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India