|
Learn Step-by-step how
to write the application - Web_VCnet developed with Microsoft Visual
C# .Net.
Classes used in
this Application: OleDbConnection,
OleDbDataAdapter, OleDbCommand,
DataSet,
Label, TextBox, Button,
LinkButton, DataGrid and ...
- ASP.NET Web
Application,- name - Web_VCnet .
- Database
Software ...
- Developed with
Microsoft Visual C# .Net.
- Uses the Microsoft
Access database file -
Web_VCnet .mdb.
The
Web_VCnetdatabase file stores 3 tables ...
- Project -
Web_VCnet and those
items
this Web
application
Web_VCnet 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_VCnet
- 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_VCnet/Web_VCnet.csproj,
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_VCnet .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_VCnet .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_VCnet .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_VCnet .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 ...
| | | |
|
|
|
|
| |
|