|
Learn Step-by-step how to write the
application developed with Microsoft Visual Basic .Net but the Sql database manage and store data.
Classes used in this
Application: SqlDataAdapter,
SqlConnection, SqlCommand, DataSet,
TabControl,
DataGrid, ListView, ComboBox,
DataTimePicker, MainMenu, Timer, ImageList, PictureBox,
Label, TextBox,
Button.
- Name -
RBT Accounting Net
- Database
Software. (Accounting
& Stock)
- Developed with
Microsoft Visual Basic .Net but the Sql database manage and store data.
- The Sql database
name used - RBT ( primary database file - RBT_Data.mdf, transaction
log file - RBT_Log.ldf )
This Sql
database consists of five tables - ord_sales,
it_sales, chang, product and cust_comp Between
tables ord_sales and it_sales exist
one-to many relationship. - Functions:
Navigation, Add, Update , Search and
Animation.
- Project -
RBT Accounting Net and
those items
- Requirements:
Microsoft Visual Studio .Net and Microsoft SQL
2000
If you want to
run it:
- Remove the
read-only attribute of all files in the
folder - C:\RBT Accounting Net
-
Add the Sql database
stored in the
folder C:\RBT Accounting Net\Data
to the
SQL Server Entreprise Manager
- Run the
Microsoft Visual Studio .Net.
- From
File menu, choose Open
then choose Project
..., the Open Project
dialog box appears, select the RBT
Accounting Net.vbproj project file
(C:\RBT Accounting Net\RBT Accounting Net.vbproj)
and then click Open.
-
In this application, modify all SqlConnection strings to
point to a valid with your Microsoft SQL Server database
- From
Debug menu, choose and click
Start.
| |
After
running,
you can observe the following Forms design
...:
|
1. |
Main Form
|
|
The
design ..
1
Functions ...
Use the Menu items, to
call the application Forms included
|
|
2. |
Introductory Form
|
|
The
design ..
|
|
|
The
design .. |
|
Master-Details form, one-to-many relationship
between tables : ord_sales and it_sales
Function ...
Navigate between
the records of the tables: ord_sales and
it_sales
display.
| |
The
design ..
|
1st TabPage of TabControl control selected
|
|
2nd
TabPage of TabControl control selected |
 |
|
 |
|
List of Functions ...
Use DataTimePicker
control to add the dateNavigate
between the records of the table chang
Add new
record to the table
chang and update it
Show all record
of this table | |
The
design ..
|
1st TabPage of TabControl control selected
|
|
2nd
TabPage of TabControl control selected |
 |
|
 |
|
List of Functions ...
Navigate
between the records of the table cust_comp
Add new
record to the table cust_comp and update it
Show all record
of this table | |
The
design ..
|
1st TabPage of TabControl control selected
|
|
2nd
TabPage of TabControl control selected |
 |
|
 |
|
List of Functions ...
Navigate
between the records of the table product
Add new
record to the table product and update it
Show all record
of this table | |
The
design .. |

|
Function ...
Animation.
| |
|
|