1. .
SQL Server Management Studio. \Microsoft SQL Server \SQL Server Management Studio.
- Connect to Server.
- (Connect).
- SQL Server Management Studio.
- .
- . . .
- . .
- : Ļ . SecurityDB. . . NT AUTHORITY\ ʻ.
- ʻ.
- SQL Server Management Studio. SecurityDB.
SecurityDB .
2. User_tbl SecurityDB.
-
- . , .
- , ID , . . , .
- ID . , . ID . () . 1. , ID 1, - 2, 3 ..
- ID . , .
- User_tbl . , , . .
|
|
- , . User_tbl ʻ
- , .
3. User_tbl .
- User_tbl User_tbl 200 .
- Microsoft SQL Server Management Studio . User_tbl, . Admin Me , .
- User_tbl , .
4. Microsoft Visual Studio
- SQL Server Browser ( SQL ) , Microsoft SQL Server. SQL Server Configuration Manager ( SQL ), Microsoft SQL Server. /Microsoft SQL Server 2012/ / SQL Server .
SQL :
- SQL , Microsoft SQL Server SQL Server, . SQL .
: , , SQL Server , SQL Server Configuration Manager, .
- Microsoft Visual Studio 2012, /Microsoft Visual Studio 2012/ Microsoft Visual Studio 2012.
- Microsoft Visual Studio 2012 ( ).
- .
, .
- Visual C#\Windows, Windows Forms. WSR_GIA_ , , ʻ.
5. SecurityDB.
- \ .
.
- . . .
|
|
- . , 养.
- , Microsoft SQL Server .
- SQL . Windows. Ļ SecurityDB.
- . , , .
- ʻ. , + .
- . . , : .
- . . .
- .
- , / / .
6. .
- Form1. , .
- :
Name ( ) | Authorization_frm |
StartPosition( ) | CenterScreen |
Text ( ) |
- Label, TextBox Button ( , - ), , .
- , .
Label1 | Text ( ) | |
Label2 | ||
TextBox1 | Name ( ) | |
TextBox2 | ||
Button1 | ||
Button1 | Text ( ) | |
Label1 | Font () | 14 |
Label2 | ||
TextBox1 | ||
TextBox2 | ||
Button1 | ||
TextBox2 | PasswordChar ( ) |
- .
7. LINQ to SQL.
- LINQ to SQL. , WSR_GIA_Serkova , , .
- LINQ to SQL, : Users.dbml .
- LINQ. , . User_tbl , .
8. .
- . , WSR_GIA_Serkova , , Windows.
- : Admin_frm.cs .
|
|
- Text Admin_frm .
- , Admin_frm , , , FormClosing .
- FormClosing ( ). .
9. .
- . , WSR_GIA_Serkova , , Windows.
- : Root_frm.cs.
- Text Root_frm .
- , Root_frm , , , FormClosing .
- FormClosing ( ). .
10. / . . . .
- . Click ().
- , .
- UsersDataContext, LINQ to SQL, Users- . (Users), . .
- , .
( ) | ||
Admin | ||
Root |
( ) | ||
SSS | . , | |
Root |
11. /, .
- . Click (). , .
- , .
.
( ) | ||
Root | . , | |
Root | ||
Root | ||
Root | . |
12. 1 .
- . Click (). , .
- , .
.
|
|
( ) | |||
Me | 30 ( ) | . |
13. .
- . , WSR_GIA_Serkova , , Windows.
- : UpdatePass.cs.
- Text UpdatePass .
- 4 Label, 3 TextBox Button ( , - ), , .
- , .
Label1 | Text ( ) | , . . 14 |
Label2 | ||
Label3 | ||
Label4 | ||
Button1 | ||
Label1 | ForeColor ( ) | |
Label1 | Font () | 14 |
Label2 | ||
Label3 | ||
Label4 | ||
TextBox1 | ||
TextBox2 | ||
Button1 | ||
Label1 | MaximumSize ( ) |
- .
14. , , .
- . Click (). , .
15. , 14 . - .
- UpdatePass. Click (). button1_Click, . , .
- button1_Click, .
- , UpdatePass , , , FormClosing .
- FormClosing ( ). .
-
- . Click (). , .
- , .
( ) | |||
Ivan | 14 |
( ) | |||
( ) | |||
! |