Enrollment System v1.0

Submitted by: 
Visitors have accessed this post 280771 times.

This is a complete enrollment system that you can use in recording a students information. I started working with this project using MS Access. One of the best feature of this system is the use of a parent/child to grand child using Windows Form and a DataGridView control.

A must have features:

1. Automatic loading of subject/course from Regular Load table in Student's Information form under the School Year & Course tab.
2. A parameterized dataset in Student's Information form to search for lastname.
3. A combobox, button and checkbox inside a grid.
4. Regular Load masterfile.
5. Advance reports using stored procedure.

And a lot more.

I have provided a video tutorial so that questions will be minimize on this code. You can access it here: https://www.sourcecodester.com/blog/enrollment-system-v10-video-tutorial.html.

Note: You need VB.NET version 2008 and SQL Server 2000 or above in order to run this program.

To do list:

1. Auto increment IDNo.
2. Transcript of Records report - I hope somebody can help me of this report.


Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Unless you share your source code here.

There are a lot questions arises between these two giant Programming Languages, which is the most popular and which is easy to use and to deploy? You considered also, the costs...which is less and which is more?

HERE IS ONE OF THE SCENARIO HAPPENS TO ME, THINK ABOUT THIS SCENARIO.

OKAY, you are a freelance programmer/developer and somebody called you to create a program for them, with limited resources, for some situations, they have only two as in (2) computers in their office and they want you to build a system for them, let say invoicing system, the company is 2 years old and sales is getting high monthly, they are tired enough in creating the invoice in Excel sheets, the invoicing sheets are getting bigger and bigger. Unfortunately, they don't have any forms, they relied on automatic number based on Company Name Invoice Date, Current Month and a serial number. Say for example, ABC211009-0001, ABC211009-0002 and os on....the user creating this INVOICE NUMBER by copying the previous excel sheets, then saving it. and print the invoice in A4 Size bond paper, they are subjected to do this as they are in cost-saving stages, they are doing this for almost 2 years...fortunately, they have internet connection and planning to post their invoices to their specific cilents. they are doing this by converting the excel sheets into Acrobat format and send it to specific client via e-mail, that's why they want you to build a semi web database for invoicing and output them in professional acrobat files for specific clients, say for example, they want you to create a link that enable them to download the invoice. This is an straight forward scenario! in such a way that it will saved a lot of money for the company, you dont need a messenger to deliver the invoice...you don't even need the FEDEX/DHL to deliver your invoice...the company will saved a lot of money!

Now, the owner of the company called you (ASP.Net Developer using VB or C Sharp) and somebody (PHP/MySQL).

First, the owner of the company called you because they saw your ads in internet that you are doing a lot of programs in ASP.Net in a reasonable price and they explained everything to you(above scenario), every scenario and they want you to defend or rather explain what IDEA do you have for them in order to create such goals...

Second, they called PHP/MySQL Developer, they explained them also every scenario and seems to you that PHP/MySQL Developer is winning the bids.

You as a Freelance ASP.Net Developer / VB.Net Developer, what are you going to do? In order to win the BIDS?

========================================================================
This is a challenge to me, in fact, I should ignore the project, I am busy with my current projects, but I was thinking this a prestige...this is a trophy, this is a challenge, forget about the money..but this is a challenge and I must win. I was thinking that, once i created a program for them, then they will referred me to their clients in future time, you know what I mean...

Now, as ASP.Net Developer / VB.Net enthusiast, what are you going to do in order to win the bidding?

NOTE:
Ignore this article if you are not interested, or post your reply, this event actually happened to me, but I will not tell you what I did...but this is also a points to remember specially for the new comer in the world of freelance programming...I will not tell you what language that I used...but will tell you that the system is working like a charm...

mysql_connect("localhost", "root", "admin") or die(mysql_error());
echo "Connected to MySQL
";
mysql_select_db("test") or die(mysql_error());
echo "Connected to Database";
?>

Thanks to admin for posting this article...MABUHAYYYY!

That's a very good question.

It could be a great challenge to most of us dealing with different customers/clients. Back to the question, if you don't have enough experience, well most probably you will lost the battle in a short period of time. But if you have a lot of experience and a lot of programs (desktop/web) to show to your clients most likely you will catch them. But how about the other programmer. What if they had the same experience just like you?

Well there must be an extreme battle between the two of you. If I were the programmer either in both side (PHP or ASP.NET) I would have to develop a simple sample program so my client would try it for free. There is sometimes a psychological war here. If the client's like your system then you have an advantage of getting the project.

Well of course there are some so many factors to consider also. One is what is the knowledge of your client about computing? Are they knowledgeable enough on what language they prefer? If they have ASP.NET background then 100% sure you will win. But if they prefer PHP because they knew it or somebody has referred it then you know what will be the consequences.

If the clients don't have any knowledge in any language then you still have a good fight. One advantage that you need to talk to your client is the user's friendliness of the system. You can trick them by saying that ASP.NET will run on Windows OS unlike PHP will run on Linux. In this case you can say that "Hey client's are you ready to study linux and or hire somebody every time there is a system failure?". In this case they will think about the pros and cons.

But if you are a PHP programmer you would say also that PHP is free, linux is free, and everything is free. Unlike windows it is a commercial product.

Hehehe. And the battle will not just end by the topic above. A lot of things we need to study in order to win a project.

Any thoughts about this topic is highly appreciated.

i have problem in Visual Basic,... i nid a program of STUDENT INFORMATION
that contains
STUDENT NUMBER
LAST NAME
FIRST NAME
MIDDLE NAME
COURSE
YEAR AND SECTION
AGE
ADDRESS
TELEPHONE NUMBER

AND THEY HAVE 5 COMMAND BUTTONS
cmdADD
cmdEDIT
cmdSAVE
cmdDELETE
cmdEXIT

pls help me,... hirs my e-mail [email protected] thanks in advance

how to download it..........

pls..help me in making a simple profile sytem...pls..i nid as soon as poosible.??tnx

codes for simple system of accounting????

I have some problem when i connect my dbms to vb. can you tell me simplest method for retrieveing , updateing , deleting record from dbms. Plz help me
Gouri Shankar
Email : [email protected]

Please study Database Programming Made Easy.

hi sir,

i have a project of documenting our enrolment system but the problem is i dont know how to make dfd can you help me. tnx!

I've read all their questions and and your answers. Hmm.. I'm not being "Mayabang" or so.. but maybe.. you're already making those kind of projects.. you should have studied more.. some of their questions are already taught in class before you get the Database subject.. and you can't answer it.. and with one of them asking how to use your application.. maybe.. you should have given them the procedure rather than telling them to just "Run it, study, debug, play around with it...etc....".. you should have included a study guide or so.. XD

Hi body...

With all the stuff I am sharing here I cannot make a documentation for every project I have uploaded here. If you do not know how to play around with the source code it's better you buy a book or listen to your instructor and ask question.

But if you have time to make a documentation for this, then you are welcome to do so.

And for your information I have created a tutorial called Database Programming Made Easy as a general reference to learn how to program rather than making a study guide for every project.

Think about the time I have to spend working on this...

Regards

do you have a youtube the tutorials of enrollment system the tutorials please...from the start...the step bey step please,...do it tnx

The "Admin" thinks that he know it all. check your grammar please! yes you have you ways but way far to be pro but this is your site this is your world and you say what you want to say and do what you want to do but just a piece of advise you don't have to say your "Great" to be "Great" just be "Great" and do it. for you guys who need assistance on your respective projects you can check this
site:http://www.hotscripts.com/category/asp-net/
http://www.daniweb.com/forums/thread272.html
http://visualbasic.about.com/od/learnvba/l/aa030803e.htm
http://www.tek-tips.com/faqs.cfm?fid=3735

and use google.com helps a lot.

To Mr. Disappointed.

G'day Mr. disappointed.

How I wish I have enough money so I can hire somebody to proofread my English grammar especially in replying to your comments. Mr. Disappointed, I do not mean to disappoint you. LOL.

Mr. Disappointed, I did not share my code here for the sake of “English Grammar”. I created this website to help my fellow programmer. And yes this is my world. Without this I am not what I am now. I don’t know if it is a correct grammar. LOL

But Mr. Disappointed I did not say also that I am “GREAT”. Who said that I am great? And I don’t even consider myself as pro. Pro-tekal lg ni akon. Hahaha…

And yes the website you have shared here is very nice. Especially google. Because when somebody searches for keyword my website is in the search results.

And by the way Mr. Disappointed, did you share some of your work? Share it so we can benefit from it.

‘till next time Mr. Disappointed.

Bye…bye…take good care always…

nice project its useful to others...

hi sir..just want to ask if you know how to encrypt the username and password in the database using vb.net?my professor is requiring us to encrypt the entered username and password during the creation of new user and when the new user login,the username and password should be decrypted.
hope you can help me.tnx.

This would be my next project. Wait until I finish it. But I'm so kinda busy right now and I don't know when to finish this one.

He is really disappointed...lol, Hotscripts.com seems to be nice, tek-tips is also the same, but never shared their entire projects to the user itself, and besides, they will give a simple task whici nothing to do with you....this is the problem of their sites...

I SHARE KO DIN KAYA ANG MGA PROJECTS KO DITO....SPECIALLY SOME OF MY PHP/MySQL projects and ASP.Net projects, not that much good, but very interesting...

Hehehe. Most of the people who scrutinize me is filipino. I don't know kung ano ang kinakain ng mga yan...

Salamat pare if you can share something here specially PHP/MySQL.

Well, then why not? I have to organize first my files, then I will post some of my works in PHP/MySQL, specially in Joomla, Drupal and Smarty...

But first of all, here are some important things that beginner must exercise::

How to connect to the database.

How to put up or set up your own web server thru IIS (Windows XP or Windows Vista) or XAMMP.

How to use parameters.

Basic form and command button.

How to call your header and bottom into your index page.

Basic knowledge in Query, SQL Dump, PDO etc.

Basic knowledge in Change Mode Settings (Read, Write and Update)

Loopings or IF-THEN-ELSE in PHP.

Server Side Includes, when to use it?

Differentiation between PHP 3.0, 4.0 and 5.0

MySQL 5.XX, MySQL Community Server, MySQL Paradigm

MySQL and PHPMyAdmin

When to use OOP (Object Oriented Programming) in PHP.

The CAPTCHA in PHP/MySQL.

PHP MVC Framework and entities.

CMS (Content Management System), What is CMS? Difference between ASP.Net CMS and PHP/MySQL CMS. When to use it?

Open source (GPL as in General Public License or GNU)

Just for your info, Duke University, Harvard University, Reuters and even CNN they are using PHP/MySQL and then why?

What is the secrets behind the success of PHP?

and so on and so forth........

Thanks pare. I am a fans of CMS also. Someday I will share also some of my knowledge about it. I am prioritizing desktop programming right now.

Well, that could be a big help to our fellow programmers.

Hey dude nice project,

But I have one question for you,

Can any how, we can use Java class\ Jar file in VB , Vb. application,

Did you try that ?
Thanks

I think you can't.

Hi, I don't have Crystal Reports installed
in my machine. What can I do in order to be able to build your project ?

Thanks in advance.

Download the 90 days trial version of VB.NET professional or team edition.

hope it works...

i've downloaded you hotel reservation system..and i'm trying to read the codes..the problem is I can't understand it.haha i have my thesis this sem. and I should finish it on or before sept. 15..but i'm not that good in programming though im an IT student.haha i made use of VB.NET..can you help me w/that?? by the way, it's Student Information and Scheduling System..pls..email me..thanks alot! :)

HA-HA-HA din! ...Joke lang po...lol

Hi,

I have a question regarding windows form grading system.
The basic function of my Grading System is for the Teacher to have a template for their grading requirement.

Do i need to have a MS ACCESS Template Database to be use by my application, since my application is offline?

If not, then what is the file type to be save the current work in the application and re opening it some other time?

Hope your not confuse.

Thanks

Actually I'm totally confuse. Template in ms access is different from the template of excel.

I bit you don't have any knowledge about programming. If this is the case, you need a database storage in which ms access is the answer.

Can you please help me how to use this enrollment system?
Thanks!
Are there any tutorials?

I downloaded it already, so how can I use it? Are there any tutorials? Thanks!

Run it, study, debug, play around with it...etc....

Can you post some codes about saving, opening files using vb.net?

Files? as in txt file? Most of my code are database driven so I don't have code for this.

Please can you help me finish our TOR system using VB6..
Can you give a sample GUI..
Thanks!

As you can see in my enrollment system I don't have a transcript of records report because it's very hard to create this in crystal reports. I have however a transcript of records in ms access version but I don't want to share this.

Creating "Detailed Reports" such as Transcripts of records etc, taks a lot of time in Crystal Report, but creating this kind of entity in MS Access is very easy, what I did recently, I've just Linked the data to MS Access via ODBC Connect, once I have the data in MS Access then you can play around...the worse is if the user don't have MS Access, then what you are going to do? Well, here what I did, everytime, the data passes to MS Access, I've just created a program that convert them or output them to Acrobat / .pdf format.

Here's what i did, when you compiled or created run-time version version of MS Access, you can distribute it as many as you can, igonore about the license on it, but before that, you need to create a program that converting MS Access reports to Acrobat / .pdf format. Once it is done, the reports looks very professional, and by the way, some of my reports outputted to Acrobat format, I'm just passing the Crytal Reports and outputted every reports to Acrobat format, the report is fine, very professional, you can e-mail them instantly, send them thru fax, upload load to your webserver, etc...this is what I did, I dont know, if you have any idea, then good! but for me, designing a much complicated reports requires a lot of variations.

Yes you are right. And your technique is a good example. I even played around with Report viewer but I decided to do this all in MS Access.

anu po database password?

di ko po mabuksan :D

salamat !

'ON & OFF'

hi!! gud pm..sir i need the codes on how to identify the old and new student..patulong naman po..

. hello Sir can you please send me the code of the enrollment system for the improvement of the system that we made, ..
thanks...!!!

how to make an enrollment system using java.net?...can you help us...!!!!?

hai sir!!! can you give us the source code for our computerized enrolment system for our thesis? you can email to [email protected] the success of our thesis greatly depends on your hands. we dont have the other reference. your help is greatly appreciated.. thanks.

hi there...I will make an automated enrollment system for my thesis. hope you can assist me with some of my queries..thanks!

katÜ

I can help you with few lines of code. But not the whole program. Just ask your question here if you have one.

i'm about to make a thesis regarding an automated enrollment system...hope you can assist me...thanks..

Hello...guys,

As a newbie in SQL Server, hope this site help me for I'd been stuck here for a week.

I already have the ODBC file connecting to sql server 2005. Using a local pc linking tables works fine but when trying to link those odbc tables from other pc it was already failed.

Can someone me please....and send me the whole batch of files for tutorial or code if required.

Thanks in advance.

Pages

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.