Microsoft Microsoft Visual Basic.NET
(OnePoint) ( URL Web Copyright 2005 Microsoft Corporation. All rights reserved. MicrosoftWindowsVisual Basic Visual Studio Microsoft Corporation
Microsoft Microsoft Visual Basic.NET Visual Basic.NET Microsoft MicrosoftVisual Basic.NET Visual Basic.NET Microsoft MicrosoftVisual Basic.NET Visual Basic.NET Microsoft Visual Basic.NET Windows Visual Basic.NET Windows
1 Visual Basic.NET...1 1.1 ADO.NET...2 1.2 ADO.NET...9 2...14 2.1...15 2.2...18 3 Visual Basic.NET ADO.NET...23 3.1...24
1Visual Basic.NET 1
1.1 ADO.NET Data Objects DAO ActiveX Data Object ADO Visual Basic.NET ADO.NET DAO ADO Visual Basic.NET ADO.NET DAO DAO JET (.mdb) DAO JET Open Data Base Connectivity ODBC ODBC 2000 DAO 2000 ADO DAO JET JET ODBC Microsoft SQL Server SQL Server Oracle 1 DAO 2
ADO ADO Object Linking and Embedding Data Base OLE DB ADO OLE DB 2000 ADO DAO DAO ADO ADO OLE DB SQL Server Oracle XML 2 ADO 3
ADO.NET.NET Framework Microsoft.NET XML Web.NET Framework 3.NET Framework 1.NET Framework Web Windows Web ADO.NET.NET ADO.NET.NET Framework SQL Server XML HTTP Visual Basic.NET ADO.NET ADO DAO ADO.NET Visual Basic.NET ADO.NET SQL Server Oracle XML 4
4Visual Studio.NET ADO.NET.NET Framework ADO.NET.NET Framework ADO..NET.NET Framework Web http://www.microsoft.com/japan/msdn/netframework/default.aspx ADO.NET http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/cpguide/ html/cpconoverviewofadonet.asp 5
ADO.NET ADO.NET.NET Framework 2 5ADO.NET.NET Framework.NET Framework NET Framework 2 NET Framework.NET Framework Data Provider for SQL Server.NET Framework Data Provider for OLE DB.NET Framework Data Provider for ODBC.NET Framework Data Provider for Oracle SQL Server 7.0 SQL Server OLE DB OLE DB ODBC ODBC Oracle 6
3.NET Framework XML XML DataTables DataRelation 6 7
ADO.NET ADO.NET ADO.NET http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/cpguide/html/cpconad onetarchitecture.asp.net Framework http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/cpguide/html/cpconad onetproviders.asp ADO.NET DataSet http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/cpguide/ html/cpcontheadonetdataset.asp 8
1.2 ADO.NET Visual Basic.NET ADO.NET DAO ADO ADO.NET DAO ADO DAO ODBC 7 DAO ADO 9
Visual Basic.NET ADO.NET ADO.NET ADO.NET 8Visual Basic.NET ADO.NET 10
DAO ADO GUI 9 Visual Basic.NET ADO.NET ADO.NET 10Visual Basic.NET 11
DAO ADO DAO ADO DAO XML XML DAO 11 DAO ADO Visual Basic.NET ADO.NET XML XML ADO.NET XML Windows Web ADO.NET 12
12Visual Studio.NET XML 13
2 Visual Studio.NET 14
2.1 DAOADOADO.NET DAO DAO DBEngine Jet ODBC 13DAO 15
ADO ADO DAO Connection 14ADO 16
ADO.NET ADO.NET ADO ADO.NET.NET Framework DataSet.NET Framework SQL Server OLE DB ODBC ADO.NET DataSet ADO.NET XML XML DataSet XML XML DataSet DataSet 15ADO.NET 17
2.2 DAO ADO Visual Basic.NET Visual Basic.NET SQL Server DAO DAO 1 DAO 18
ADO ADO 2 ADO 19
Visual Basic.NET Visual Basic.NET 3Visual Basic.NET ADO.NET DAO Database SQL Server ) ODBC ADO Connection SQL Server Microsoft OLE DB Provider for SQL ServerSQLOLEDB ADO.NET SqlConnection SQL Server.NET Framework Data Provider for SQL Server OLE DB ODBC SQL Server ADO ADO.NET DAO ODBC 20
DAO Recordset MoveNext ADO Recordset DAO Recordset DAO MoveNext ADO.NET SqlDataAdapter DataSet SqlDataAdapter DataSet SQL Server SqlDataAdapter Fill DataSet DataSet DataSet For Each...Next DAO Recordset Edit Update ADO Recordset Update DAO ADO.NET DataSet BeginEdit ( )EndEdit( ) SQL Server SqlDataAdapter Update SqlDataAdapter SelectCommand InsertCommand DeleteCommand UpdateCommand TableMappings SQL SqlCommandBuilder SQL DAO Database Close ADO Connection Close ADO.NET SqlConnection Close 21
4 DAO ADO ADO.NET Database Connection SqlConnection ODBC SQL Server SQL Server OLE DB.NET Framework SQL Server Recordset Recordset SqlDataAdapter DataSet MoveNext MoveNext Recordset Recordset SqlDataAdapter DataSet Edit Update DataSet Update Database Connection SqlConnection SqlDataAdapter Close Close Close ADO.NET ADO.NET ADO.NET http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vbcon/html/vboriadon etconnections.asp ADO.NET DataSet http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/cpguide/html/cpconcr eatingusingdatasets.asp 22
3Visual Basic.NET ADO.NET Visual Basic.NET ADO.NET 23
3.1 Visual Basic.NET ADO.NET ADO.NET SQL Server GUI Visual Studio.NET [ (J)] Visual Basic Windows [OK] 1 2 3 16 5 5 No 1 DataGrid1 2 Button1 3 Button2 24
SQL GUI DataGrid1 1. [ ][ ] SqlDataAdapter 17 SqlDataAdapter 2. [ (N)>] 18 25
3. [ (C)...] 19 4. Microsoft OLE DB Provider for SQL Server [ (N)>>] 20 26
5. 6 [ (T)] [OK] [ (N)>] 21 6 WINSV (N): (P): (S) sa sa (D): SampleDB 6. SQL (S) [ (N)>] 22 27
7. SQL [ (Q)...] 23 8. M_STAFF [ (A)] 24 9. [ (C)] 28
10. * [OK] 25 11. (W) [ (A)...] 26 29
12. SQL INSERTUPDATE DELETE (G) [OK] 27 13. [ (N)>] 28 14. [ (F)] 29 30
15. [ ] 30 16. SqlDataAdapter1 SqlConnection1 31 SqlDataAdapter1 SqlConnection1 http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vbcon/html/vbtskcreat ingdataadaptersusingwizard.asp http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vsintro7/html/vburfa DODataSetCommandConfigurationWizard.asp http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vdbt7/html/dvconstruc tureofretrievalqueries.asp [SQL ] http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vsintro7/html/vxurfad vancedsqlgenerationoptionsdialogbox.asp 31
1. 32 2. (N) [OK] 33SqlDataAdapter1 3. SqlDataAdapter1 DataSet11 34 DataSet11 32
[ ] http://www.microsoft.com/japan/msdn/library/default.asp?url=/japan/msdn/library/ja/vsintro7/html/vxurfge neratedatasetclassdialogbox.asp DataSet11 DataGrid1 DataGrid1 [DataMember] M_STAFF [DataSource] DataSet11 35DataGrid1 7DataGrid1 DataMember M_STAFF DataSource DataSet11 33
Button1 Button2 34
1. [ (D)][ (S)] 36 2. 37 35
3. 38 4. 39 36
Visual Basic.NET ADO.NET ADO.NET XML SQL SELECT INSERTUPDATEDELETE.NET ADO.NET 37