Visual Basic 2005?????

1
CH08
2
??? ????
3
ADO.NET???????
?????
?????????????,?????????????????--????????
?????????,?????????????,??????????????????
?,??????????? ??????????????????(???????)?
?,???????????????????????????????????????????,????
?????????Binary Code,????????????????,????????????
??? ?????????????????,????????(???????)???
????????????
4
ADO.NET???????
????????????????,????????????(??????1999??????????
?)?????????????Access?SQL Server?Oracle???????????
??,?????????????
?????
???????????????,??????????????????,???????(??????
)????????????????????????
5
ADO.NET???????
?????
??????????,?????????(????????),????????????????? ?
?,???????????(???????????????????)
6
ADO.NET???????
??,???????,?????,??????????????,????Excel?sheet,??
???????????????????????????,??????????????????????
???
?????
???????,???????
??,?????????????????????????????,?????????????????
?,???????????????????????
?????????,????????(Data Column)
???????????????(Data Row)
7
ADO.NET???????
?????
?????????????????????,?????????????,?????????????
????????????5000????????(?????????????????????????
)
???????????????????,?????????????
8
ADO.NET???????
????VB.NET???????
????????????????,?????????????????????????????????
????,??????????????SQL??,?????????????????SQL?????
???????,????????????????????
??,Visual Basic 2005?????,???????????,????????????
?,??????????,?????????????????????????,????????,??
?????????,?Visual Basic 2005??????,????????????,??
???????????????,???????,??????????????????
9
ADO.NET???????
????VB.NET???????
????????????????,???TextBox?Label,?????ToolStrip(?
??)?????????????????????????,????????????????????,
?????????????????????,?????????
10
ADO.NET???????
????VB.NET???????
?????VS2005??????????,???????????????????????,????
????????,????????????
11
ADO.NET???????
??SQL??
???????,???????????SQL??,????????????????????????,
???????SQL Server 2005 Express?????,????????????
Select??
?????????Select??,???????????????????,????????????
??,??????,????????????(???????)????(view)?
??
12
ADO.NET???????
Select??
????????,????????SQL??????(CH08-01)?,????TextBox??
??Select??,?????????,???????????DataGridView?
???Select??,???????????????VB????,????View,??DataG
ridView?????
13
ADO.NET???????
Select??
Select?????????,?????Select???????Order By
????,????????????
????????????(???????????????,??????????),????????
?
14
ADO.NET???????
Select??
Order By????????,???,???,??????????Asc?Desc,??????
?????????(Asc)??????(Desc),?????,?Asc?????
??????????????,???????SQL??,??????????????????,???
???????,?????????????????
15
ADO.NET???????
Select??
??Order By??,Select??????????????,?????Where??????
?????????????
16
ADO.NET???????
Select??
???????????,??????Like???,?????????,??
??????Like????,??????????,???????,??????,??????
like '?'?????,???????????????????,??????????????
???,????????????,???????????????????,?????????
17
ADO.NET???????
Insert??
??????,?????????,???????,??????????
??
???,?SQL????,?????????????????????
??????????????,?????
18
ADO.NET???????
Delete??
Delete??????????,???????????,?????????????,?????
???Where??????Select????,??And, Or,
??Like????,?????????,??????????????,??
???????,????????????????????????????,???????
???where??,?????????,???????????????????
19
ADO.NET???????
Update??
Update???????????????,?????
?Delete????,?????Where??,?????????????????????????
?(???????????Set????)? ????????????????, ?????????
??, ??????????????
20
ADO.NET???????
Update??
???????
??Boolean??,??Yes?No????(???1?0)???
?????????????????(??????????,??????????)
21
ADO.NET???????
Update??
???????
??Boolean??,??Yes?No????(???1?0)???
??????,??????????5?????????????????????????????
22
ADO.NET???????
Update??
???????
??Boolean??,??Yes?No????(???1?0)???
?????????????10???,??????,????????????????????????
23
ADO.NET???????
????VB????????
????SQL Command
DataGridView
?????Select SQL Command?????(Data
View)?????DataGridView???
CH08-03??
24
ADO.NET???????
??DbAccess???????
?????????SQL Server 2005 Express????
??TextBox??Select??,????????DataTable?
25
ADO.NET???????
??DbAccess??????????
????????SQL??
26
ADO.NET???????
??DbAccess???ADO.NET?????
?????DbAccess????????????????,???????DbAccess?????
???????????,????????????????DbAccess????? ????????
?DbAccess???????? ????????????DbAccess????????????
??,??????????DataTable,???????,????DataTable?????,
????????????????????? ?.NET Framework??,??????????
ADO.NET??,ADO.NET??????????????????,??????????????
??????????????????????(???),??????????????????? ??
???????DataTable,??ADO.NET?????????
27
ADO.NET???????
DataTable?DataRow??
28
ADO.NET???????
????????????
cNorthWind.MDF
ShowData(ByVal id As Integer) ??N?????????
29
ADO.NET???????
30
ADO.NET???????
???????????????
cNorthWind.MDF
ToolStrip_btn_Save.Click
31
ADO.NET???????
32
ADO.NET???????
33
ADO.NET???????
????????????
cNorthWind.MDF
ToolStrip_btn_Delete_Click
34
ADO.NET???????
???????????,???????????????????,???????SQL????????

35
ADO.NET???????
??????
??????????????????,??????,????????????????? ?????,
????????????,?????????,????Insert??,??????????????
?? ?????????????
36
ADO.NET???????
37
ADO.NET???????
????
?????????????????,?????????????????,???????? ?????
??????,?????????????????,?????????,????????ShowDat
a?????????,???????????
38
ADO.NET???????
????
cNorthWind.MDF
btn_search_Click (Search.vb)
39
ADO.NET???????
40
ADO.NET???????
41
ADO.NET???????
????????????
42
ADO.NET???????
?????????
getByte????image??(???????) ,?????Byte()??(?????
??),????????image????????
43
ADO.NET???????
???? ????????
44
ADO.NET???????
DbAccess??
????,?????DbAccess????????????????,???????DbAccess
????????????????,????????????????DbAccess?????
45
ADO.NET???????
ADO.NET?????????
46
ADO.NET???????
ADO.NET???????????(????????)
47
ADO.NET???????
ADO.NET???????????
Data Source?????????,?????????SQL
Express???,????????AttachDbFilename?????? Integrat
ed Securitytrue???????????????????,??????,??????
????????????????
ADO.NET???????,????????,??????????????????????????
????
48
ADO.NET???????
SqlDataAdapter???????????(conn)?????SQL??,??Fill??
,??????(DataView)??dt
??DataAdapter?????
??SqlDataAdapter???Fill?????SQL??(?????????conn???
??????????????),??????????,????????????,????DataT
able????????????????
49
ADO.NET???????
???????????????,???DataCommand????????DbAccess????
,???ExecuteCmd??Method????
??DataCommand???SQL??
??????ExecuteCmd????????
50
ADO.NET???????
8-5-3 ??DataCommand???SQL??
????????6-21?,??????SqlCommand??,??SQL???????????P
rivate????????Conn,?????(?SQL?????_at_...??????)????p
arameter????8????SqlCommand(dc)????,?????SqlComman
d???ExecuteNonQuery???????SQL???
51
ADO.NET???????
???????
??.NET??????????????,???????????????????.NET????,?
???????????,?????????????????????,??????Windows???
????????????? ???XML???,????????????????????????,?
???????,?ADO.NET??XML????,????ADO?????????.NET
Framework??ADO.NET,?WEB???????????,???????????????
????ADO.NET?ADO?????????????,????????????????? ???
??????????????????,?????????????????,?????????????
?????????(????????????),?????????????????????????
,????,?????MSN?Skype???P2P????,???????????????????
?????????????????????????????????????????(???????
?????????,MSN?????????????),???????,???????,??????
????????,??????????????
52
ADO.NET???????
???????
?????????(????)?????????????,??????????????,??????
????????? ????ADO.NET?????DataTable??(??DataSet??)
??????????????????????????????????,??????????(????
??????????..)?????????,???????????????????????????
,???????????? ???ADO.NET??????????SOA ( ??????
Service-Oriented Architecture)???????,????????????
????DataTable?,???WebServices??,?????????????(????
?????),??????????????? ????,????????????,???????ED
I??(??????)??SCM(?????)??,?????????,??????????????
,?????????????