|
Learn Step-by-step how
to write the application - Web_VBnet developed with Microsoft
Visual Basic .Net.
Classes used in
this Application: OleDbConnection,
OleDbDataAdapter, OleDbCommand,
DataSet,
Label,
TextBox, Button, LinkButton, DataGrid and ...
- ASP.NET Web
Application,- name - Web_VBnet .
- Database Software
...
- Developed with
Microsoft Visual Basic .Net.
- Uses the Microsoft
Access database file -
Web_VBnet .mdb.
The Web_VBnetdatabase file stores
3 tables ...
- Project -
Web_VBnet and
those items
this
Web application
Web_VBnet consist of
5
forms. |
 | |
- Requirements:
Microsoft Visual Studio .Net.
If
you want to run it:
When you open
a Web project,
the system opens it using the
Web access method (file share or FrontPage Server Extensions)
- Remove the
read-only attribute of all files in the folder
- http://localhost/Web_VBnet
- Run the
Microsoft Visual Studio .Net.
- On the File menu, point to
Open,
and then choose
Project
From
Web.
- In the Open
Project
From Web
dialog box appears, select the web project http://localhost/Web_VBnet/Web_VBnet.vbproj, and then click OK
Note
enter the URL of the
Web server
where the project
is located
- From
Debug menu, choose and click
Start.
Note
The Web project
opens and its files are listed in Solution Explorer. If the
project
could not be opened, an error message is shown that allows you to try
another Web access method or to work offline.
|
| |
After
running,
you can observe the following Forms design
...:
The
design .. |
 |
List of Functions ...
To Show the Data Web
page - Dataweb_book.aspx, select the Hyperlink
control stored the text ' To show the booknote Table
with Page numbers & Edit ' .
To Show the Data Web page - Dataweb_personal.aspx,
select the Hyperlink control stored the text ' To
show the personal Table with Navigation buttons & Edit '.
To Show the Data Web page - Dataweb_booknote.aspx,
select the Hyperlink control stored the text ' To
show the booknote Table with Navigation buttons, Edit & Add '.
To Show the Web page - web_search.aspx, select the
Hyperlink control stored the text ' To show the
Categories Table with Search '. | |
|
|
|
The design ... |
|
 |
|
Data web Form
page, to show the records of Table booknote,
size of DataGrid page = 5 lines ...
Uses
the Microsoft Access database file -
Web_VBnet .mdb, this database stores the
table - booknote Each record consists of
6 fields.
The records uf
this Table: bookid, first_name, father_name, name,
country, sity.
List of
Functions ...
navigation operation using 10
LinkButtons ...
modify/edit
current record,
Cancel operation,
Update operation,
Link with the
main web page
|
| |
| |
|
|
1. |
book_note.vb |
|
|
The design ... |
|
 |
|
Data web Form
page, to show the records of Table personal,
size of DataGrid page = 5 lines .
Uses
the Microsoft Access database file -
Web_VBnet .mdb, this database stores the
table - - personal. Each record consists of
6 fields.
The records uf
this Table: stores the personal_id, first_name, name, sex,
birth, country.
List of
Functions ...
navigation to the First, previous, Next or Last page
modify/edit
current record,
Cancel operation,
Update operation,
Link to the
main web page
|
| |
|
|
|
|
|
|
|
The design ... |
|
 |
|
Data web Form
page, to show the records of Table personal,
size of DataGrid page = 5 lines .
Uses
the Microsoft Access database file -
Web_VBnet .mdb, this database stores
the table -booknote. Each record consists of
6 fields.
The records uf
this Table: bookid, first_name, father_name, name,
country, sity.
List of
Functions ...
navigation to the First, previous,
Next or Last page
add new record,
modify/edit
current record,
Cancel operation,
Update operation,
Link to the
main web page
| |
|
|
|
The design
... |
 |
Data web Form
page with Search operation, if the
search operation is positif, the DataGrid control
appears storing list of records corresponding ...
Uses
the Microsoft Access database file -
Web_VBnet .mdb, this database stores
the table - Categories. Each record of this table consists of
3 fields.
The records of
this Table: categoryid, categoryName, Description Type
any word at the box - (Type the search word(s)) and then
click the button Go (The search operation begin
...). If any records of the
Categories Table include in the field
Description these words
you specified. The datagrid
control stores the searching record(s) and display
the Search criteria ...
Note
The web page stores test exemples ...
Function ...
| | | |
|
|
|
|
| |
|