?? notes.txt
字號:
Install demos and open in VS .NET 2003
Demo 1: MSAccess version of BankCustomerApp
- show load event with 3 steps: open, retrieve, close
- add try-catch-finally (throw ex in catch)
Demo 2: SqlServer version of BankCustomerApp
- open Query Analyzer and setup database with .sql file
- app has MSAccess code for data access
- same programming mode, differnet connection string & classes...
- rewrite to use SQL server:
- using SQL=...;
- sConnect = string.Format(揝erver={0};Database={1};{2}?
搇ocalhost?
揝ales?
揑ntegrated Security=SSPI?;
- use SQL classes (SqlConnection, etc)
- same programming model otherwise!
Demo 3: DataSet version of BankCustomerApp
- load event has code to fill dataset, iterate through to create customers and .add
- then open DataGrid version and show binding dataset to datagrid
Demo 4: Back to SqlServer version of BankCustomerApp
- look at code behind Delete selected menu item...
- standard Delete SQL...
- delimiters on text fields!
- escape of delimiter character!
- take out .Replace and delete kathie, watch it blow up...
- mention SQL injection attacks
######################
Demo 5: Back to DataSet version of BankCustomerApp
- look at code behind Save menu item
- run, modify existing, add new record, save, quit, rerun...
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -