ADO.NET - , (disconnected) .NET. .
.
1.
FormEmployee . FormEmployee , , . 11.1.
. 11.1. FormEmployee
.11.5.
11.5
FormEmployee
Text/Items | |||
SplitContainer | splitContainerEmployee | ||
Label | labelListEmployee | ||
listBox | listBoxEmployee | ||
Label | labelSurname | ||
Label | labelName | ||
Label | labelPatronymic | ||
Label | labelJobRole | ||
Label | labelStatus | ||
Label | labelAccess | ||
label | labelNetName | ||
textBox | textBoxNetName | ||
textBox | textBoxSurname | ||
textBox | textBoxName | ||
textBox | textBoxPatronymic | ||
comboBox | comboBoxJobRole | ||
comboBox | comboBoxStatus | , , , , , | |
comboBox | comboBoxAccess | , , , , | |
menuItem | menuItemAction | "" | |
menuItem | menuItemUndo | "" | |
menuItem | menuItemNew | "" | |
menuItem | menuItemEdit | "" | |
menuItem | menuItemSave | "" | |
menuItem | menuItem | "" | |
menuItem | menuItemReport | "" | |
menuItem | menuItemReport1 | " " | |
menuItem | menuItemReport2 | " " |
1. SplitContainer . 11.2. 1 labelListEmployee listBoxEmployee .11.3, , . 11.5, - 2 . 11.1. FormEmployee . 11.1 Tab.
. 11.2. FormEmployee
TabIndex ( TextBox ComboBox) Properties (.11.4)
|
|
. 11.4. TabIndex
TabIndex Tab Order Wizard View/Tab Order .11.5. TabIndex .
. 11.5.
Tab . 11.6.
2. "", "" .
, ( ) ( ).
. 11.6. Tab Order Wizard
3. "", "" , .
DisplayReadOnly. DisplayReadOnly , . ( ) TextBox ReadOnly true, comboBox - Enabled false. DisplayReadOnly :
public void DisplayReadOnly(){this.textBoxSurname.ReadOnly = true;this.textBoxName.ReadOnly = true;this.textBoxPatronymic.ReadOnly = true;this.textBoxNetName.ReadOnly = true;this.comboBoxJobRole.Enabled = false;this.comboBoxStatus.Enabled = false;this.comboBoxAccess.Enabled = false;}4. DisplayEdit , :
/// public void DisplayEdit(){this.textBoxSurname.ReadOnly = false;this.textBoxName.ReadOnly = false;this.textBoxPatronymic.ReadOnly = false;this.textBoxNetName.ReadOnly = false;this.comboBoxJobRole.Enabled = true;this.comboBoxStatus.Enabled = true;this.comboBoxAccess.Enabled = true;}5. Load.
( /) FormEmployee DisplayReadOnly ( Load), , DisplayEdit - .
6. FormEmployee.
DisplayReadOnly() DisplayEdit() , .
7. , DisplayReadOnly(bool readOnly), readOnly : readOnly true, , false, - .
FormEmployee.
"" Windows- FormEmployee "", "", "", "" "", "".
|
|
"", Windows- FormEmployee , .. "".
"", Windows- FormEmployee "". , "", "" "", "", "".
FormEmployee . .
MenuItemEnabled(bool itemEnabled), MenuItemContextEnabled (bool itemEnabled) StripButtonEnabled(bool itemEnabled).
Enabled ToolStripMenuItem, - Enabled ToolStripButton.
, FormEmployee.
, , DisplayForm.
private void DisplayForm(bool mode){DisplayReadOnly(mode);MenuItemEnabled(mode);MenuItemContextEnabled(mode);StripButtonEnabled(mode); }"" FormEmployee.
1. FormEmployee
2. "", "" .
3. "", "" , .
4. Load.
5. .
1. TextBox?
2. ButtonBase?
3. CheckedListBox ?
4. ?
5. , ?
3-4, 11-12].
12
ADO.NET
: ADO.NET Visual Studio IDE. , DataSet Windows - .
1. .
2. DataSetEmployee dsEmployee, daJobTitle daEmployee.
3. Fill DataSet.
4. .
5. .
6. .
1.
. . 12.1 .
. 12.1.
|
|
1. , :
- Employee;
- JobTitle.
2. Employee . 12.2
12.2
Employee
EmployeeID | smallint | |
JobRoleID | smallint | |
EmployeeSurname | varchar(50) | |
EmployeeName | varchar(20) | |
EmployeePatronymic | varchar(20) | |
EmployeeStatus | int | |
Access | varchar(20) | |
NetName | varchar(20) | |
Birthday | Smalldatetime | |
FirstDate | smalldatetime |
EmployeeID, , , .. IDENTITY MS SQL Server AutoNumber MS Access. JobRoleID , . JobTitle.
JobTitle . 12.3.
12.3
JobTitle
JobRoleID | smallint | |
JobRoleName | varchar(50) |
MS SQL Server 2005.
3. . Tools/Connect to Database. AddConnection .12.2.
. 12.2. AddConnection
4. "Server name" , ( 12.2MYHOME-8834E210\DOLJENKO). Select or enter database name - , . 2.2.
5. "Test Connection". .12.3.
. 12.3. Microsoft Data Link
Server Explorer View/ Server Explorer ALT+CTRL+S ( 12.4.).
. 12.4. Server Explorer
6. DataSet. Project/Add New Item... (. 12.5).
. 12.5.
7. DataSet Add New Ite m 12.6 DataSetEmployee.
. 12.6. DataSet
Add DataSetEmployee, .12.7.
. 12.7. DataSet
8. Employee JobTitle DataSet Server Explorer .12.8.
. 12.8. DataSet
, Fill GetData.
DataSetEmployee , Employee JobTitle ( ) (, MS SQL Server).
9. DataSetEmployee. , Employee JobTitle :
AutoIncrement = true;AutoIncrementSeed = -1;AutoIncrementStep = -1;AutoIncrement true , AutoIncrementSeed AutoIncrementStep. . , -1, -2, -3 .., , .. . AutoIncrementSeed AutoIncrementStep -1, , , . DataSet , MS SQL Server 2005 , , DataSet, , .
|
|
10. AutoIncrement, AutoIncrementSeed AutoIncrementStep EmployeeID Employee . 12.9.
. 12.9. EmployeeID
11. JobTitleID JobTitle. AutoIncrement, AutoIncrementSeed AutoIncrementStep
12. DataSetEmployee , FormEmployee.cs.
DataSetEmployee dsEmployee = new DataSetEmployee();DataSetEmployeeTableAdapters.EmployeeTableAdapter daEmployee = new Project_4_01.DataSetEmployeeTableAdapters.EmployeeTableAdapter();DataSetEmployeeTableAdapters.JobTitleTableAdapter daJobTitle = new Project_4_01.DataSetEmployeeTableAdapters.JobTitleTableAdapter();13. dsEmployee , , daEmployee daJobTitle, DataSetEmployee - dsEmployee( Employee, MS SQL Server 2005). dsEmployee Employee EmployeeFill():
public void EmployeeFill(){ daJobTitle.Fill(dsEmployee.JobTitle); daEmployee.Fill(dsEmployee.Employee); MessageBox.Show(" Fill ");}EmployeeFill() DataAdapter Fill, (JobTitle Employee) dsEmployee . Fill DataAdapter DataSet, dsEmployee.JobTitle dsEmployee.Employee.
MessageBox.Show EmployeeFill , .
EmployeeFill Load FormEmployee, "".
2.
1. listBoxEmployee, , EmployeeSurname Employee. , FormEmployee_Load.
this.listBoxEmployee.DataSource = this.dsEmployee1;this.listBoxEmployee.DisplayMember ="Employee.EmployeeSurname";Windows- FormEmployee : textBoxSurname, textBoxName, textBoxPatronymic textBoxNetName. Employee dsEmployee. , dsEmployee. , DataBindings TextBox.
2. textBoxSurname , FormEmployee_Load.
textBoxSurname.DataBindings.Add("Text", dsEmployee, "Employee.EmployeeSurname");3. .
4. textBoxName, textBoxPatronymic textBoxNetName .
Employee Access () , comboBoxAccess.
5. comboBoxAccess :
this.comboBoxAccess.Items.AddRange(new object[] {" ", ""," ", " ", "", ""});6. ( Employee) Access comboBoxAccess. , TextBox, DataBindings
|
|
7. : , , , , , , . comboBoxStatus
Employee EmployeeStatus () (0, 1, 2, 3, 4, 6), comboBoxStatus . DataSet comboBoxStatus. . dsEmployee EmployeeStatus (Item) comboBoxStatus.
8. bmEmployee BindingManagerBase ormEmployee:
BindingManagerBase bmEmployee;9. bmEmployee FormEmployee, BindingContext Employee, , :
public FormEmployee(){InitializeComponent(); bmEmployee = this.BindingContext[dsEmployee1, "Employee"];// PositionChanged - // . Employee DataSet dsEmployee bmEmployee.PositionChanged = new EventHandler(BindingManagerBase_PositionChanged);}10. , (pos) Employee Text comboBoxStatus Items (sel), EmployeeStatus Employee.
private void BindingManagerBase_PositionChanged(object sender, EventArgs e){ int pos = ((BindingManagerBase)sender).Position; int sel = (int)dsEmployee.Employee[pos].EmployeeStatus; this.comboBoxStatus.Text = this.comboBoxStatus.Items[sel].ToString();}11. .
12. comboBoxJobRole JobTitle, Employee JobRoleID. ( JobTitle) . Employee.
DataBindings ComboBox ControlBindingsCollection. Add .
Add :
PropertyName - , ;
DataSource - ;
DataMember - .
13. comboBoxJobRole JobTitle ( - ), , .
comboBoxJobRole.DataSource = this.dsEmployee.JobTitle;comboBoxJobRole.DisplayMember = "JobRoleName";comboBoxJobRole.ValueMember = "JobRoleID";14. comboBoxJobRole JobRoleID Employee ( ),
comboBoxJobRole.DataBindings.Add("SelectedValue", dsEmployee,"Employee.JobRoleID"); , . 12.10..
. 12.10. ( )
1. DataSetEmployee, dsEmployee, daJobTitle daEmployee, Fill.
2. , , .
3. dsEmployee .
4. listBoxEmployee, , EmployeeSurname Employee.
5.
1. ADO.NET?
2. BindingContext?
3. , ADO.NET?
4. Data.Set?
5. ADO.NET ?
[3-4, 11-12].
1.
: .
. . : DVD, MPEG4, Blu-Ray, HD-DVD. . . : , . . : ; , /; .
- ( ) , , , .
- . (. . ., , ) .
( ). . : ; . . , , , . / , . /, . : . .
. , , . , .
( , 12 ) , . , . 12 , .
, . , , . , . , , . 12 , .
2.
: .
.
.
. . - , ( ).
. . , . , . .
"" . . .
, , , , : " ", " ", " ", " ", " ", " ", " ", " ".
, , , . , , . , , , . .
3.
: .
. () . (, , ) , (, ). , . , , .
. , .
" " . 10 . , . .
( ).
, .
: , .
4.
: .
"." web- .
. (. . ., , ) ( ).
, , , , . , . : , , , , 1-2-3 , vip- . . . , . , , , . : / / . web- .
. : , , , , , , , ( / ), , , ( / / / ). 12 .
. : / / ; ; ; ; ; . , . , , , , , , , , ( / / / ). 12 , , .
, , . , ( , ) "". / "" , . 5 , " ", , , , . 4 "" , , . . , , ( ).
5. -
: . -
- . . - ( ). , . "9" .
. , - "". - "". , ( ""). - . ( ), - "". , - "". , . , - "", . "", - . , - "" "". , - "". .
, , , . - "" . "" .
, "9". - , () , "" . , . , "" ( ), - "", "" . , - "" . - "" . , . "" "000". . "000" , "". "000", .
6.
: .
, , . : , , .
. " " , , , , . , . , , .
, , . . .
- . , , , , . . , , , , , . : , . . , . , . .
, . , . - . - . .
, , , . , , . ( ). (, , ) . . , . - . . 12 .
: , : . , , .
(, , ). - , . : , , , , , .
7.
: .
. : , , , , , , . , .
. , . . , , . , . , . . , .
(100, 200, 500, 1000, 5000, 10000 ). , . . , , . , " ". , . , .
, . .
, , , . , , , .
8. -
: . -
. web- . , . web-. , . (, , , . .) . .
, -, , . , , -. (, , . .). , ( / / ). , ( ) . 5 , . - . . - , . ( ). , , .
, . 15 , .
9.
: .
(, ). : , ; , .
, (): , , , , , , . , , . ( ).
. , , . . , , . , , , . , . , .
, . , - . , .
. . - , , .
:
;
;
;
.
, , , .
10. Web-
: . Web-
Web- . , . . . , , , . .
( ). - , . ( ).
, . , 20 , 20 . . , . , . () , . . -, . , .
Web. , , . , , ( ). , .
. , . , , . , .
, - () - . . , , . , , .
, , .
11. , .
12 ѻ.
13 .
14 .
15 .
16 ,
17 .
18 .
19 .
20 .
21 .
22 .
23 .
24 .
25
2