C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !






Course Finder - Search Colleges and Courses


Posted Date: 12 May 2007
Total Responses: 0

Posted By: Timmy M.John

Member Level: Silver       Posted Date: 12 May 2007
Revenue Score: Revenue Score: 0


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: MaNisH GanGraJMember Level: BronzeRevenue Score:
    hi,,,,,,,
    it is really good project for new programmer.


    Author: umeshkumarMember Level: BronzeRevenue Score:
    hi,its good one i liked it


    Author: Satyanarayan SushilKumar BajoriaMember Level: DiamondRevenue Score:
    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: SreeMember Level: BronzeRevenue Score:
    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: Satyanarayan SushilKumar BajoriaMember Level: DiamondRevenue Score:
    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: Olufemi HunjenukonMember Level: BronzeRevenue Score:
    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: saravanakumarMember Level: BronzeRevenue Score:
    Hi firends,

    I really enjoy this project, I can improve my ideas with help of this projects. Thank u


    Author: RockyMember Level: SilverRevenue Score:
    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: RockyMember Level: SilverRevenue Score:
    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: Nushrat aliMember Level: BronzeRevenue Score:
    Hi Timmy

    Nice Job

    Thanks for Posting the source Code

    thank you very much

    Nushrat Ali Tyagi



    Author: ViggneshwarMember Level: SilverRevenue Score:
    Nice Project. It is very useful to me


    Author: venkatMember Level: GoldRevenue Score:
    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: jayachandMember Level: BronzeRevenue Score:
    Hi,

    It is very good just now i downloaded u r project if any problem means i will send u plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz help me
    thanks for project

    D.jayachand


    Author: PraneethaMember Level: BronzeRevenue Score:
    this good project ,but how can i start this project means step by step

    plz reply to my msg


    Author: PraneethaMember Level: BronzeRevenue Score:
    this good project ,but how can i start this project means step by step

    plz reply to my msg


    Author: mustafaMember Level: BronzeRevenue Score:
    Thanks, its nice project.

    ---------
    Mustufa Lotiya


    Author: Anusha kolluriMember Level: BronzeRevenue Score:
    Thank u
    its helpful


    Author: Anusha kolluriMember Level: BronzeRevenue Score:
    can anyone provide me documentation of the project?

    its urgent please


    Author: AfrozMember Level: BronzeRevenue Score:
    It's realy nice project but how can i deployed it?


    Author: Mohammad Shahidul Islam ChowdhuryMember Level: BronzeRevenue Score:
    Hi,

    It's nice project for programming learner.


    Author: Mohammad Shahidul Islam ChowdhuryMember Level: BronzeRevenue Score:
    Hi,

    This project will be helpful for every user.


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

    Return to Project Index

    Post New Project


    Related Projects



    dotNet Slackers   BizTalk Adaptors    Web Design

    it support

    Contact Us    Privacy Policy    Terms Of Use