|
Learn Step-by-step how to write the application - APP-VBNet
developed with Microsoft Visual Basic .Net.
Classes used in this Application:
OleDbConnection, OleDbDataAdapter,
OleDbCommand,
DataSet, TabControl, ListView, ComboBox,
MainMenu, Timer, PictureBox, Label, TextBox,
Button.
- Name -
APP-VBNet.
- Database
Software.
- Developed with
Microsoft Visual Basic .Net.
- Uses the Microsoft
Access database file - KJV2002.mdb.
The KJV2002 database file stores Part of
Bible data. - (4 books of Bible, every book has a title
and consists of several chapters and every
chapter consists of several verses) The
database consists of one table - BibleTable. The
table stores more then 31100 records and each record consists of
five fields - Book, Title,
Chapter, Verse and
TextData: - The Book field
stores the oders of the books - (4 books). - The
Title field stores the titles of all books. -
The Chapter field stores the orders of all
chapters. - The Verse field stores the orders
of all verses. - The Textdata field stores the
contents of all verses.
- Functions:
View , Search, Show Form and
Animation.
-
Project -
APP-VBNet and those items
- Requirements:
Microsoft Visual Studio .Net.
If you want to
run it:
- .
- Remove the
read-only attribute of all files in the
folder - C:\APP-VBNet
- Run the
Microsoft Visual Studio .Net.
- From
File menu, choose Open
then choose Project
..., the Open Project
dialog box appears, select the
APP-VBNet.vbproj project file
(C:\APP-VBNet\APP-VBNet.vbproj)
and then click Open.
- From
Debug menu, choose and click
Start.
| |
After
running, you
can observe the following Forms design ...:
The design .. |
 |
List of Functions ...
To
call the Form - Book. - Book.vb. - (From
Info menu menu, click Book)
To
call the Form - About - About.vb. - (From
Info menu menu, click
About)
To
unload the current project. - (From
Info menu menu, click Exit
)
|
|
The design ..
|
1st TabPage selected of TabControl control.. |
 |
2nd TabPage selected of TabControl control.. |
 |
|
List of Functions ...
To display
any records of KJV2002 database into the Record data boxes.
To move
the current record position to the first,
last, next, or previous record. - (Click
the navigation buttons )
To call
the Form - About, About.vb. - (Click the
button About)
To unload
the current Form. - (Click the button Close)
To search
By word: - (1st TabPage of TabControl
selected)
Type
a word - (length > 1
characters) in the
TextBox, the
Button -
Search set enable.
Click
the Button Search, two types
of information appear:
- A
list of
information about all
records of the KJV2002
database include the word
you specified will
appears in the ListView control -
(each list item stores
the order of the record
corresponding and the
values of Book field,
Title field, Chapter
field and Verse field in
this record).
- The
number of the records
found.
|
Select
an item of the ListView, the
record corresponding to
the item selected displays into the Record
data boxes.
Use the Button View, to select one of
four different views this items can be shown
in the Listview control
|
To search
By address: - (2nd TabPage of TabControl
selected)
- The
Title ComboBox
stores the titles
of the books - ( 4books).
Select
an item:
- In
this ComboBox,
displays the item
selected.
- In
the Book
ComboBox,
displays the order
of the book corresponding to the item
selected.
- The
Chapter ComboBox
stores all
chapters orders
of this book and in the
current string displays
the 1st chapter
order.
- The
Verse ComboBox
stores all verses
orders of the 1st
chapter and in the
current string displays
the 1st verse
order.
- Into
the Record data
boxes,
displays the 1st
record of this
book.
|
- The
Book ComboBox
stores the orders
of all books. Select
an item:
- In
the Title
ComboBox,
displays the title
of the book corresponding to the item
selected..
- In
the Book
ComboBox,
displays the item
selected.
- The
Chapter ComboBox
stores all
chapters orders
of this book and in the
current string displays
the 1st chapter
order.
- The
Verse ComboBox
stores all verses
orders of the 1st
chapter and in the
current string displays
the 1st verse
order.
- Into
the Record data
boxes,
displays the 1st
record of this
book.
|
- The
Chapter ComboBox
stores all
chapters orders corresponding
to the order Book displays in
the Book ComboBox. Select
an item:
- In
this ComboBox,
displays the item
selected.
- The
Verse ComboBox
stores all verses
orders corresponding to the
item selected and in the
current string displays
the 1st verse
order.
- Into
the Record data
boxes, displays
the 1st record of the
book chapter.
|
- TheVerse
ComboBox
stores all
verses orders
of the chapter
corresponding to the
items display in the
Chapter and Book ComboBoxes.
Select
an item:
- In
this ComboBox,
displays the item
selected.
- Into
the Record data
boxes,
displays the record
corresponding to the item
selected.
|
|
|
|
The design .. |
 |
List of Functions ...
To display
information about the KJV2002 database.
To call
the Form Biography - Biography vb. - (Click
the button Biography)
To unload
the current Form. - (Click the button Done)
|
|
The design .. |
 |
List of Functions ...
Animation.
Biography data.
To unload
the current Form. - (Click the button Done
)
|
|
|
|