: .
:
3
4334
. .
:
..
___________
2014
. 2
.. 3
. 4
. 5
.. 5
. 7
Access. 14
( DataTable DataColumn) 16
DataRelation. 16
( DataRow) 16
DataAdapter 16
DBConnection DBCommand. 16
DataGridView.. 17
OleDbConnection - . 21
. 23
. 23
.. 27
.. 32
. 33
Form1. 33
. Access, .
, C#.
, , ().
, , , , .
. , , , . , , .
Access, , - .
, , .
, .
, , . .
, , , , , , . .
|
|
, , , , , , , .
.
, , , , . : , 500 . . , , , . . . , : 534322, 523498, 453478, 796475 .., , . , , . , .
. .
.
, , , , .. , , .
, (), , , :
1) : ;
2) : ;
3) : .
. , , . , , , ..
() , () .
, , , . .
, .
:
, . .
, . , () . () , .. .
|
|
() . , .2.1. 5 , 2 4.
, , , .
, , , , .
(, , ) .
, , . , . , , .
() , , .
- . - , , . . -, , , , . , , .
, ( relation ).
R D1D2... xDn d1,D2,..., Dn (n ³ 1), . D1, D2,..., Dn .
,
. - , , . , , .
, . , . , . , , . ER- , , , . - .
. relation () relationship ( ). , . () , .
|
|
, . (), , . . . (). , ( ) .
, , . - , ( ) . - , .
(. 3).
, . , , , .
, . , , , . , , ( ) ( ). , , . , . , .
().
1. (1) . - , , , .
2. (2) , . , .
3. (3) .
4. (4) .
Access
Access - , , (). , , (, , , ..). Access , .
|
|
- . , . (, DBMS - Database Management System) - , , , , , . , . - .
Access . ( ). , Access , , , , . Access , , , , , /, MEMO, , OLE. , .
Access . Access - , SQL Server. . Access ODBC (Open Database Connectivity), , SQL Server, Oracle, Sybase DB/2 IBM.
Access . , , .
MS Access - . . , . , - ( ), , , - .
, . Access .
Access , . , . , , , , , , . , .
, SQL , . . . , . .
- , , . , , , . . ( ActiveX), . , , .
|
|
( DataTable DataColumn)
DataTable DataSet. , DataTable DataColumn.
DataColumn - DataTable. DataColumn DataType, , DataColumn. , , . , DataTable, , .
DataRelation
DataSet Relations, DataRelationCollection, DataRelation. DataRelation ( - ()). , DataColumn.
( DataRow)
Rows DataTable () . . .
DataAdapter
DataSet - , . DataSet DataAdapter. - , , - . DataAdapter Fill() DataSet.