Enrollment System v1.0

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

hey....buddy plz tell me wether can we open it with vb2005 and sql 2005.......i m not able to open ... wat do i do...plz...reply...as fast as u can...

You need VB.NET version 2008 and SQL Server 2000 or above.

THANKS

 Hello My Name is Rafi Shaida,

Please I want Connect Microsoft Access With Visual Basic 6.0 and i want to delete, Update, insert and connect Data Grid of VB6.0 With Ms Access Please Replay To Me In One Or Two Days But Coding of These Things.....

          Good Bye...

           Best Regards...

 

at first Active ... Microsoft ActiveX Object 2.6 and after use the code, in form module, public con as ADODB.Connection public Rs as ADODB.Recordset Form_Load() set con = new adodb.connection con.open "Provider=Microsoft.jet.oledb.4.0; Data Source =" & app.path & "\account.mdb" Rs.open "Select * from tblpay",con,addopenkeyset,addlockpessimistec End sub ' here is have Connection With Database Record Table. ' You Can Use Code.. VB6 .. ' any kind of information.. visit: My facebook account. [email protected]

Please I have the problem with vb6.0 and ms access the problem is to Connect vb6.0 with ms access and how to delete update insert and connect the vb6's datagrid with ms access table if you replay these codings i will be very happy from you

My Name is Rafi Shaida

Send these Things on my Email Address   :  [email protected]     and mobile number is       (0092) 303 84 42 863

If you need a very simple application that can insert, update, delete, and read a record then I suggest you take a look at this source code: 

http://www.sourcecodester.com/visual-basic/multi-column-combobox-datagrid.html

In reply to by Anonymous (not verified)

LOLs! :)) :D =)) :P

You have to contact this guy asap if you don't want to lose him.

In reply to by Anonymous (not verified)

What Do You Mean By Your This Sentence?

Don't Wana Loose Meeee?

I am working on a project where i need to connect connect 4 databases (MYSQL, ORACLE, Microsoft SQL Server, ACCESS) to common front end using VB>NET. So I need ODBC drivers for all these databases. It is a data integration project using ETL. The dat displayed in the front end would be transferred to a Data ware house. Please can you be of help.

In reply to by Anonymous (not verified)

You can find each of this driver at the respective website of every product. Go to www.mysql.com for MySQL, www.oracle.com for Oracle. Microsoft ODBC is already included by default.

I like it

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

i have vb2005 express edition

In reply to by Anonymous (not verified)

Please check your sql server if its running. or check your connection if u are using sql server as a remote database.

I am working with VB2008, Crystal Reports 2008.

I tried opening your source code but I have Crystal Reports Issues.

Something like CrystalDecisions.x.x .

Do I need to install any other app?

 

where can i get (local) (windowsNP) in enterprise manager in ms sql server 2000... please reply asap....... i really need this.. hehehe ty...

 

In reply to by Anonymous (not verified)

You are very polite! My goodness! Next time don't be too rush. Clarify your question again. :P

hi,

the code below is used to insert a single record.can you please tell me how to insert multiple records in the same code using a "for" loop...i have not worked in VB before.so,can u please give me the required code...please help...

Set connect = CreateObject ("ADODB.Connection")
connect.open "DSN=OPTUMETL;Driver= Oracle in OraHome92;Server=urnts1.uhc.com;UID=OPTUMETL;PWD=OPTUMETL"
Reporter.ReportEvent 0, "Database connection", "Successfully connected to URNTS1"
Set objRecordset = CreateObject("ADODB.Recordset")
' Stmt to execute the code
query="INSERT INTO STG_CARE.ASSESSMENTANSWER(ANSWERID, ANSWERGROUPID, ANSWERTEXT, DISPLAYSEQUENCE, ISEXCLUSIVENO, ISEXCLUSIVEYES,
CREATEBY, CREATEDATE, UPDATEBY, UPDATEDATE, RECORDSTATUS, RECORDVERSION, RECORDSOURCE, SYNCDATE, RECORDUNIQUEID,
PARENTRECORDUNIQUEID, AUDIT_CREAT_DT, AUDIT_UPDATE_DT, SRC_SYSTEM_ID)VALUES(95149, 95052, 'Yes (Red Flag)', 10, 0, 0, 1, TO_DATE('11/10/2005
01:05:29 PM','DD/MM/YYYY HH12:MI:SS PM'), 1, TO_DATE('11/10/2005 01:05:29 PM','DD/MM/YYYY HH12:MI:SS PM'), 0, 1, 0, TO_DATE('01/01/1900 12:00:00
AM','DD/MM/YYYY HH12:MI:SS PM'), 0, NULL, TO_DATE('18/08/2008 06:06:16 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2008 06:09:13 AM','DD/MM/YYYY
HH12:MI:SS PM'), 'CARE')"
msgbox query
Set objResults = connect.Execute(query) ' Cmd used to execute the sql
'
Reporter.ReportEvent 0, "Query execution", "Executed query successfully"
'
'objResults.Close

nice system.

hi...do you have any project using java with access connectivity.......please  reply immediately...i hav to submit in coll....bnye...waiting for ur reply....

i need a project that i can improve on for my finial year project i am not much of a programme but i can try with java and or c++ or if u have any project designing website

my email is [email protected]

ok din tong naicip nio ahhhhh

Hi !

I am shrikant. I got one project. I want to create 3 tables Student Id , Cat codes And Enrollment   tables. In Enrollment table i want enter all the details of student. like .Student Id, Student name , mail id, adress, Amount paid and balance amount.. after that in cat code table  Stu. Id , cad code and Issu date.  in cat code  table if the student will paid all the fees then using coding one mail will be sent to student mail id ( mail is  ur three CAt Code is ..... something) if the student is not paid money then in mail only one cat code id will be send... is it possible ..... if it is possible then plz send me the some sample coding for this project..

my mail id is 

[email protected]   

 

i am a beginner.

i'm using visual basic in  visual studio, i already have made crystal reports in visual studio,but i dont how to load the crystal report when running the system. I also dont know how specify the data that should be reported...I'm using odbc as my connector to my database.

please...somebody help!

Add new comment