A
Micro project On
“Book shop management system”
Submitted By
Tanisha Ajit Phalke (07)
Munajja Dalimbkar(18)
Om Salunkhe(55)
Guided By
Mrs. P. N. Kale
Diploma Course in Computer Technology
(As per directives of I Scheme, MSBTE)
Sinhgad Institutes
Sinhgad Technical Education Society’s
SOU.VENUTAI CHAVAN POLYTECHNIC PUNE – 411041
ACADEMIC YEAR 2023-2024
Maharashtra State Board of Technical Education
Certificate
This is to certify that Ms.Tanisha Phalke with Roll No. 07 of Semester IV of Diploma in
Computer Technology of Institute Sou. Venutai Chavan Polytechnic (Code: 0040) has
successfully completed the Micro-Project in GUI Application Development Using VB.
NET (22034) for the academic year 2023-2024 as prescribed in the curriculum.
Program Code: CM Course Code: CM/4/I
Place: SVCP, Pune Enrolment No: 2200400283
Date: Exam Seat No: 173001
Mrs. P.N. kale Mrs A. V. Kurkute Dr.(Mrs.)M. S. Jadhav
Course Teacher Head of Department Principal
Maharashtra State Board of Technical Education
Certificate
This is to certify that Ms.Munajja Dalimbkar with Roll No. 18 of Semester IV of
Diploma in Computer Technology of Institute Sou. Venutai Chavan Polytechnic
(Code: 0040) has successfully completed the Micro-Project in GUI Application
Development Using VB. NET (22034) for the academic year 2023-2024 as prescribed in
the curriculum.
Program Code: CM Course Code: CM/4/I
Place: SVCP, Pune Enrolment No: 2200400303
Date: Exam Seat No: 173019
Mrs. P.N. Kale Mrs A. V. Kurkute Dr.(Mrs.)M. S. Jadhav
Course Teacher Head of Department Principal
GUI Application Development using Vb.net(2241) Book Shop Management System
Maharashtra State Board of Technical Education
Certificate
This is to certify that Mr. Om Salunkhe with Roll No. 55 of Semester IV of
Diploma in Computer Technology of Institute Sou. Venutai Chavan Polytechnic
(Code: 0040) has successfully completed the Micro-Project in GUI Application
Development Using VB. NET (22034) for the academic year 2023-2024 as
prescribed in the curriculum.
Program Code: CM Course Code: CM/4/I
Place: SVCP, Pune Enrolment No: 2200400442
Date: Exam Seat No: 173109
Mrs. P.N. Kale Mrs A. V. Kurkute Dr.(Mrs.)M. S. Jadhav
Course Teacher Head of Department Principal
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
ANNEXURE-I
Micro-Project Proposal
A Billing System for D-Mart
1.0 Aim of the Micro-Project:
Aim of the Micro-Project is to create a Billing System using VB.Net.
2.0 Intended Course Outcome:
a. Use visual Studio IDE to design application
b. Develop GUI Application form controls and its events
c. Appy Object Oriented concepts in GUI application.
d. Use Data Access controls to store data in database and retrieve it.
e. Use Data binding in GUI application.
3.0 Proposed Methodology:
This Micro-Project aims at creating a Billing System by implementing
various features of VB.Net.
I. Study the concept of VB.Net programming
II. Study various syntax and functions
III. Study to create console application
IV. Make program of given criteria
V. Prepare the final report.
4.0 Action Plan:
Sr. Details of activity Planned Planned Name of responsible
No start date finish date team members
1 Searching the topic for 22/02/2023 23/02/2023 Munajja Dalimbkar
micro- project
2 Choosing the topic for 01/03/2023 02/03/2023 Munajja Dalimbkar
micro-project
3 Searching the information 08/03/2023 15/03/2023 Tanisha Phalke
on topic
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
4 Working on the examples 16/03/2023 23/03/2023 Tanisha Phalke
of the topic
5 Cross checking and 27/03/2023 29/03/2023 Om Salunkhe
correcting the
Examples
6 Preparing the report 05/04/2023 06/04/2023 Tanisha Phalke
Making changes and 12/04/2023 13/04/2023 Om Salunkhe
7 corrections in the Report
8 Final submission 19/04/2023 20/04/2023 Munajja Dalimbkar
5.0 Resources required:
Sr. Name of the Qty
No resource/ material Specifications
1 Computer System 48GB RAM, 1
Windows 11 OS
2 Operating systems Windows 11 ,64 bit 1
operating System
3 Software Visual studio 2022 1
6.0 Team members:
S. No. Roll No. Name of Student
1 07 Tanisha Phalke
2 18 Munajja Dalimbkar
3 55 Om Salunkhe
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
ANNEXURE-II
Micro-Project Proposal
1.0 Rationale:
A Billing system is essential for businesses to accurately record financial
transactions, streamline invoicing processes, ensure timely payments, enhance
customer satisfaction, comply with regulations, integrate with accounting software,
scale with business growth, control costs, and analyze data for insights and
optimization.
2.0 Aim of the Micro-Project:
Aim of the Micro-Project is to create a Book Shop Management System using
VB.NET.
3.0 Course Outcomes Addressed:
a) Use visual Studio IDE to design application.
b) Apply Object Oriented concepts in GUI Application.
4.0 Literature Review:
The program demonstrate the following function,
a) Control structure (Nested If-Else)
b) Looping commands(While loop)
A. Control structure (Nested If-Else):
The nested if-else statement is used when there are multiple conditions
that need to be checked in program. It allows to check series of conditions
and execute different code blocks based on the result of evaluation.
Syntax:
If condition1 Then
Executable code………
……………..
Else if condition2 Then
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
Executable code………
…………….
Else
Executable code……….
…………….
End If
B. While loop
A while loop in programming is a control flow statement that repeatedly executes
a block of code as long as a specified condition is true. Here's the basic structure
of a while loop in most programming languages.
Syntax:-
While (condition)
{
Executable code…….
…….
}
End while
5.0 Actual Methodology Followed:
This Micro-Project aims at implementing by connecting database and various
buttons in Quiz.
Study the concept of VB.Net programming
Study various syntax and functions.
Study to create windows form application
Study to connect windows form application to database
Study to create application to store and retrieve data from database
Make program of given criteria
Prepare the final report.
6.0 Resources Required:
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
Sr. Name of the Qty
No resource/ material Specification
1 Computer System 8 GB RAM, 1
Windows 11 OS
2 Operating systems Windows11 ,64 bit 1
operating System
3 Software Visual studio 2022 1
7.0 Source Code:
Imports System.Data.SqlClient
Public Class MainForm
Private connectionString As String = "Your_Connection_String_Here"
Private Sub MainForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load
LoadBooks()
End Sub
Private Sub LoadBooks()
Try
Using connection As New SqlConnection(connectionString)
connection.Open()
Dim query As String = "SELECT * FROM Books"
Dim adapter As New SqlDataAdapter(query, connection)
Dim booksTable As New DataTable()
adapter.Fill(booksTable)
DataGridViewBooks.DataSource = booksTable
End Using
Catch ex As Exception
MessageBox.Show("Error loading books: " & ex.Message)
End Try
End Sub
Private Sub ButtonAddBook_Click(sender As Object, e As EventArgs) Handles
ButtonAddBook.Click
' Code to add new book to the database
' Example:
' Dim addBookForm As New AddBookForm()
' addBookForm.ShowDialog()
' LoadBooks()
End Sub
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
Private Sub ButtonUpdateBook_Click(sender As Object, e As EventArgs) Handles
ButtonUpdateBook.Click
' Code to update book information
' Example:
' If DataGridViewBooks.SelectedRows.Count > 0 Then
' Dim bookID As Integer =
Convert.ToInt32(DataGridViewBooks.SelectedRows(0).Cells("ID").Value)
' Dim updateBookForm As New UpdateBookForm(bookID)
' updateBookForm.ShowDialog()
' LoadBooks()
' Else
' MessageBox.Show("Please select a book to update.")
' End If
End Sub
Private Sub ButtonDeleteBook_Click(sender As Object, e As EventArgs) Handles
ButtonDeleteBook.Click
' Code to delete a book
' Example:
' If DataGridViewBooks.SelectedRows.Count > 0 Then
' Dim bookID As Integer =
Convert.ToInt32(DataGridViewBooks.SelectedRows(0).Cells("ID").Value)
' DeleteBook(bookID)
' LoadBooks()
' Else
' MessageBox.Show("Please select a book to delete.")
' End If
End Sub
Private Sub DeleteBook(bookID As Integer)
Try
Using connection As New SqlConnection(connectionString)
connection.Open()
Dim query As String = "DELETE FROM Books WHERE ID = @ID"
Dim command As New SqlCommand(query, connection)
command.Parameters.AddWithValue("@ID", bookID)
command.ExecuteNonQuery()
MessageBox.Show("Book deleted successfully!")
End Using
Catch ex As Exception
MessageBox.Show("Error deleting book: " & ex.Message)
End Try
End Sub
End Class
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
8.0 Output:
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
9.0 Conclusion:
We learnt to design a Book Shop Management System using VB.NET; also we
learnt some important functions and their properties.
10.0 Reference :
1. https://www.proprofs.com/quiz-school/story.php?title=general-informationquiz
2. https://en.wikipedia.org/wiki/Quiz
Department of Computer Technology 2023-24
GUI Application Development using Vb.net(2241) Book Shop Management System
Department of Computer Technology 2023-24
