Loading

Enrollment System v1.0

Submitted by: 
Visitors have accessed this post 261704 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. You can benefit the use of a parent/child to grand child using a windows form and a datagridview in it.

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: http://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

None of the Files r being Opened in my PC.

How to Run Dis Project.

admin's picture

You need Visual Basic .NET 2008 and SQL Server 2000. Please view the video demo.

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...

hi,,can you help me code for pure sql in making database management enrollment system?here is my email [email protected]
thanks a lot

admin's picture

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

admin's picture

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

Hadal's picture

Hi there?

Have you solved your problem of Connecting VB with ACCESS? If NO then tell me I will mail you about this.

 

Regards

Al Hadi Khan

Regards
Al Hadi Khan

i dont want to loose you you are so handsome..

admin's picture

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

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

Hadal's picture

What Do You Mean By Your This Sentence?

Don't Wana Loose Meeee?

Regards
Al Hadi Khan

Could you help me out on how to connect access DB and Java ([email protected])

admin's picture

Come back anytime coz my friend will upload his source code about java database connectivity soon.

this is my email [email protected]

this is my email [email protected] pls help me to do this...

Please give me this . i realy need to solve many things

admin's picture

What do you want?

could anyone give me Electricity and post office project in visual basic. i need urgently..

Thanks i  advance..

Randeep singh

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.

admin's picture

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

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?

 

admin's picture

I never used VB 2008 Express edition but I think you're using this version and it does not have a crystal reports built in.

how to connect vb.net v2003 and sql server 2000

 

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

 

admin's picture

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

admin's picture

I need to know first where the data is coming from and going to.

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....

admin's picture

Sorry but I don't have a java code.

do u have that source code using VB.NET 2005 or VB6.0?? thnks.. more power

krammy_13

admin's picture

No. I don't have one for vb.net 2005 and vb 6.0.

Please upgrade to vb.net 2008.

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]

i need it..

reply immediately.

tnkx

admin's picture

Just convert the ms sql 2000 version included in this project.

Hey Dude,

Could I integrate the program to an access db. Or could you provide the version with the MsAccess?

admin's picture

You can use an Access database on this program but you need to manually change all the command.

As of this time I don't have time to create an MS Access backend.

ok din tong naicip nio ahhhhh

i really don't know...I am a begginer programmer in our thesis gruop.please help! thanks...

admin's picture

Even you question is totally beginner. What do you mean by dual table? If you want to create a table then use ms access. It is very easy to create a database table in ms access.

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]   

 

admin's picture

Please read FAQ.

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!

admin's picture

Download the source code above and study on how I use crystal reports in this program. You may also study this tutorial on how to debug a program.

Pages

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • 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.