Practical database programming with Visual Basic.NET:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Cambridge [u.a.]
Cambridge Univ. Press
2009
|
| Edition: | 1. publ. |
| Subjects: | |
| Online Access: | lizenzfrei lizenzfrei lizenzfrei Contributor biographical information Publisher description Table of contents only Inhaltsverzeichnis |
| Item Description: | Includes index |
| Physical Description: | xxix, 796 S. graph. Darst. 26 cm |
| ISBN: | 9780521885188 0521885183 9780521712354 0521712351 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035473397 | ||
| 003 | DE-604 | ||
| 005 | 20090702 | ||
| 007 | t | ||
| 008 | 090507s2009 d||| |||| 00||| eng d | ||
| 010 | |a 2007050326 | ||
| 020 | |a 9780521885188 |c hbk |9 978-0-521-88518-8 | ||
| 020 | |a 0521885183 |c hbk |9 0-521-88518-3 | ||
| 020 | |a 9780521712354 |c pbk |9 978-0-521-71235-4 | ||
| 020 | |a 0521712351 |c pbk |9 0-521-71235-1 | ||
| 035 | |a (OCoLC)435643604 | ||
| 035 | |a (DE-599)GBV551983108 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 | ||
| 050 | 0 | |a QA76.73.B3 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Bai, Ying |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Practical database programming with Visual Basic.NET |c Ying Bai ; Satish Bhalla (chapters contributor) |
| 250 | |a 1. publ. | ||
| 264 | 1 | |a Cambridge [u.a.] |b Cambridge Univ. Press |c 2009 | |
| 300 | |a xxix, 796 S. |b graph. Darst. |c 26 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 630 | 0 | 4 | |a Microsoft Visual BASIC |
| 650 | 0 | |a Microsoft Visual BASIC | |
| 650 | 0 | |a BASIC (Computer program language) | |
| 650 | 0 | |a Microsoft .NET | |
| 650 | 0 | |a Database design | |
| 650 | 4 | |a BASIC (Computer program language) | |
| 650 | 4 | |a Database design | |
| 650 | 4 | |a Microsoft .NET | |
| 650 | 0 | 7 | |a Anwendungsprogramm |0 (DE-588)4395354-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Programmierung |0 (DE-588)4076370-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
| 689 | 0 | 1 | |a Anwendungsprogramm |0 (DE-588)4395354-2 |D s |
| 689 | 0 | 2 | |a Programmierung |0 (DE-588)4076370-5 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Bhalla, Subhash |d 1956- |e Sonstige |0 (DE-588)104274476 |4 oth | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html |y Contributor biographical information |z lizenzfrei | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html |y Publisher description |z lizenzfrei | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html |y Table of contents only |z lizenzfrei | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html |3 Contributor biographical information | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html |3 Publisher description | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html |3 Table of contents only | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017393214&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-017393214 | ||
Record in the Search Index
| _version_ | 1804138933781528576 |
|---|---|
| adam_text | Contents
Preface
page
xxvii
Acknowledgments
xxix
1.
Introduction
1
1.1
Outstanding Features of This Book
2
1.2
Whom This Book Is For
2
1.3
What This Book Covers
3
1.4
How This Book Is Organized and How to Use This Book
5
1.5
How to Use the Source Code and Sample Databases
6
1.6
Instructor and Customer Support
7
1.7
Homework Solutions
8
2.
Introduction to Databases
10
2.1
What Are Databases and Database Programs?
11
2.1.1
File Processing System
11
2.1.2
Integrated Databases
12
2.2
Developing a Database
13
2.3
Sample Database
14
2.3.1
Relational Data Model
14
2.3.2
Entity-Relationship
(ER)
Model
17
2.4
Identifying Keys
18
2.4.1
Primary Key and Entity Integrity
18
2.4.2
Candidate Key
19
2.4.3
Foreign Keys and Referential Integrity
19
2.5
Define Relationships
19
2.5.1
Connectivity
19
2.6 ER
Notation
23
2.7
Data Normalization
23
2.7.1
First Normal Form
24
2.7.2
Second Normal Form
24
2.7.3
Third Normal Form
25
vii
viii Contents
2.8
Database Components in Some Popular Databases
26
2.8.1
Microsoft Access Databases
28
2.8.1.1
Database File
29
2.8.1.2
Tables
29
2.8.1.3
Queries
29
2.8.2
SQL Server Databases
30
2.8.2.1
Data Files
30
2.8.2.2
Tables
30
2.8.2.3
Views
31
2.8.2.4
Stored Procedures
31
2.8.2.5
Keys and Relationships
31
2.8.2.6
Indexes
32
2.8.2.7
Transaction Log Files
32
2.8.3
Oracle Databases
33
2.8.3.1
Data flies
33
2.8.3.2
Tables
33
2.8.3.3
Views
34
2.8.3.4
Stored Procedures
34
2.8.3.5
Indexes
35
2.8.3.6
Initialization Parameter Files
35
2.8.3.7
Control Files
35
2.8.3.8
Redo Log Files
36
2.8.3.9
Password Files
36
2.9
Create Microsoft Access Sample Database
36
2.9.1
Create the Login Table
36
2.9.2
Create the Faculty Table
37
2.9.3
Create the Other Tables
39
2.9.4
Create Relationships Among Tables
41
2.10
Create Microsoft SQL Server
2005
Sample Database
41
2.10.1
Create the Login Table
48
2.10.2
Create the Faculty Table
49
2.10.3
Create Other Tables
50
2.10.4
Create Relationships Among Tables
55
2.10.4.1
Create Relationship Between the Login
and Faculty Tables
56
2.10.4.2
Create Relationship Between the Login
and Student Tables
58
2.10.4.3
Create Relationship Between the Faculty
and Course Tables
59
2.10.4.4
Create Relationship Between the Student
and StudentCourse Tables
60
2.10.4.5
Create Relationship Between the Course
and StudentCourse Tables
61
2.11
Create Oracle
10g XE
Sample Database
62
2.11.1
Create the Login Table
64
2.11.2
Create the Faculty Table
68
2.11.3
Create Other Tables
72
Contents
2.11.4
Create
the Foreign Keys for
Tables
74
2.11.4.1
Create the Foreign Key Between the Login
and Faculty Tables
74
2.11.4.2
Create the Foreign Key Between the Login
and Student Tables
79
2.11.4.3
Create the Foreign Key Between the Course
and Faculty Tables
80
2.11.4.4
Create the Foreign Key Between the
StudentCourse and Student Tables
80
2.11.4.5
Create the Foreign Key Between the
StudentCourse and Course Tables
82
2.12
Chapter Summary
84
2.13
Homework
84
3.
Introduction to AD0.NET
87
3.1
ADOandADO.NET
87
3.2
OverviewofADO.NET
88
3.3
The Architecture of ADO.NET
89
3.4
The Components of ADO.NET
91
3.4.1
The Data Provider
91
3.4.1.1
The ODBC Data Provider
92
3.4.1.2
The OLE
DB
Data Provider
93
3.4.1.3
The SQL Server Data Provider
93
3.4.1.4
The Oracle Data Provider
93
3.4.2
The Connection Class
94
3.4.2.1
The Open() Method of the Connection Class
96
3.4.2.2
The CloseO Method of the Connection Class
97
3.4.2.3
The Dispose() Method of the Connection
Class
97
3.4.3
The Command and Parameter Classes
98
3.4.3.1
The Properties of the Command Class
99
3.4.3.2
The Constructors and Properties of the
Parameter Class
99
3.4.3.3
Parameter Mapping
100
3.4.3.4
The Methods of the ParameterCollection
Class
102
3.4.3.5
The Constructor of the Command Class
104
3.4.3.6
The Methods of the Command Class
105
3.4.3.6.1
The ExecuteReader Method
105
3.4.3.6.2
The ExecuteScalar Method
106
3.4.3.6.3
The ExecuteNonQuery Method
106
3.4.4
The DataAdapter Class
107
3.4.4.1
The Constructor of the DataAdapter Class
108
3.4.4.2
The Properties of the DataAdapter Class
108
3.4.4.3
The Methods of the DataAdapter Class
108
3.4.4.4
The Events of the DataAdapter Class
109
3.4.5
The DataReader Class
110
Contents
3.4.6
The DataSet Component
113
3.4.6.1
The DataSet Constructor
115
3.4.6.2
The DataSet Properties
115
3.4.6.3
The DataSet Methods
115
3.4.6.4
The DataSet Events
115
3.4.7
The DataTable Component
118
3.4.7.1
The DataTable Constructor
119
3.4.7.2
The DataTable Properties
120
3.4.7.3
The DataTable Methods
120
3.4.7.4
The DataTable Events
122
3.5
Chapter Summary
124
3.6
Homework
125
4.
Data Selection Query with Visual Basic.NET
129
PART I Data Query with Visual Basic.NET Design Tools
and Wizards
130
4.1
A Completed Sample Database Application Example
130
4.2
Visual Basic.NET
2005
Design Tools and Wizards
133
4.2.1
Data Components in the Toolbox Window
133
4.2.1.1
DataSet
134
4.2.1.2
DataGridView
135
4.2.1.3
BindingSource
135
4.2.1.4
BindingNavigator
136
4.2.1.5
TableAdapter
136
4.2.2
Data Sources Window
137
4.2.2.1
Add New Data Source
137
4.2.2.2
Data Source Configuration Wizard
138
4.2.2.3
DataSet Designer
143
4.3
Build a Sample Database Project
-
Select Wizard
144
4.3.1
Application User Interface
145
4.3.1.1
The Login Form
145
4.3.1.2
The Selection Form
147
4.3.1.3
The Faculty Form
147
4.3.1.4
The Course Form
148
4.3.1.5
The Student Form
149
4.4
Add and Utilize Visual Basic Wizards and Design Tools
151
4.4.1
Add and Configure a New Data Source
151
4.5
Query and Display Data Using the DataGridView
Control
155
4.5.1
View the Entire Table
155
4.5.2
View Each Record or the Specified Columns
157
4.6
Use DataSet Designer to Edit the Structure
of the DataSet
159
4.7
Bind Data to Associated Controls in the Login Form
161
4.8
Develop Code to Query Data Using the Fill() Method
165
4.9
Use Return a Single Value to Query Data for the Login
Form
168
Contents
4.10
Coding for the Selection Form
171
4.11
Bind Data to the Associated Controls in the Faculty Form
173
4.12
Develop Code to Query Data Using the Fill() Method
175
4.13
Display Pictures for the Faculty Form
178
4.13.1
Modify the Code for the Select Button Event
Procedure
179
4.13.2
Create a Function to Select the Matched Faculty
Image
180
4.14
Binding Data to Associated Controls in the Course Form
181
4.15
Develop Code to Query Data for the Course Form
185
PART II Data Query with Runtime Objects
189
4.16
Introduction to Runtime Objects
189
4.16.1
Procedure of Building a Data-Driven Application
Using Runtime Objects
191
4.17
Build a Microsoft Access Database Project
-
AccessSelectRTObject
192
4.17.1
Query Data Using Runtime Objects for the Login
Form
192
4.17.1.1
Declare the Runtime Objects
193
4.17.1.2
Connect to the Data Source with the
Runtime Object
193
4.17.1.3
Coding for Method
1:
Using DataSet-
TableAdapter to Query Data
194
4.17.1.4
Coding for Method
2:
Using the
DataReader to Query Data
196
4.17.1.5
Clean Up the Objects Used
197
4.17.2
Coding for the Selection Form
199
4.17.3
Query Data Using Runtime Objects for the Faculty
Form
199
4.17.4
Query Data Using Runtime Objects for the Course
Form
207
4.17.5
Query Data Using Runtime Objects for the Student
Form
219
4.17.5.1
Coding for the Student Form_Load Event
Procedure
219
4.17.5.2
Coding for the Student Select Button Event
Procedure
220
4.18
Build an SQL Server Database Project
-
SQLSelectRTObject
226
4.18.1
Migrating from Access to SQL Server and Oracle
Databases
226
4.18.2
Query Data Using Runtime Objects for the Login
Form
229
4.18.2.1
Declare the Runtime Objects
230
4.18.2.2
Connect to the Data Source with the
Runtime Object
231
xii Contents
4.18.2.3
Coding for Method
1:
Using the
TableAdapter to Query Data
232
4.18.2.4
Coding for Method
2:
Using the
DataReader to Query Data
233
4.18.3
Coding for the Selection Form
235
4.18.4
Query Data Using Runtime Objects for the Faculty
Form
235
4.18.5
Query Data Using Runtime Objects for the Course
Form
239
4.18.6
Retrieve Data from Multiple Tables Using Joined
Tables
240
4.18.7
Query Data Using Runtime Objects for the Student
Form
245
4.18.8
Query Data Using Stored Procedures
246
4.18.8.1
Create the Stored Procedure
247
4.18.8.2
Call the Stored Procedure
248
4.18.8.3
Query Data Using Stored Procedures
for the Student Form
249
4.18.9
Query Data Using More Complicated Stored
Procedures
258
4.18.10
Query Data Using Nested Stored Procedures
263
4.19
Build a Sample Oracle Database Project
-
OracleSelectRTObject
266
4.19.1
Install Oracle Database
10g
Express Edition
266
4.19.2
Configure the Oracle Database Connection String
267
4.19.3
Query Data Using Runtime Objects for the Login
Form
268
4.19.3.1
Declare the Runtime Objects
269
4.19.3.2
Connect to the Data Source with the
Runtime Object
269
4.19.3.3
Coding for Method
1:
Using the
TableAdapter to Query Data
270
4.19.3.4
Coding for Method
2:
Using the
DataReader to Query Data
272
4.19.4
Coding for the Selection Form
273
4.19.5
Query Data Using Runtime Objects for the Faculty
Form
274
4.19.6
Query Data Using Runtime Objects for the Course
Form
277
4.19.7
Stored Procedures in the Oracle Database
Environment
280
4.19.7.1
The Syntax of Creating a Stored Procedure
in Oracle
280
4.19.7.2
The Syntax for Creating a Package in
Oracle
281
4.19.8
Create the Faculty-Course Package for the Course
Form
283
Contents xiii
4.19.9
Query Data Using the Oracle Package for the
Course Form
286
4.20
Chapter Summary
294
4.21
Homework
295
5.
Data Insertion with Visual Basic.NET
301
PART I Data Insertion with Visual Basic.NET Design Tools
and Wizards
302
5.1
Insert New Data into a Database
302
5.1.1
Insert New Records into a Database Using
the Table Adapter. Insert Method
303
5.1.2
Insert New Records into a Database Using the
TableAdapter.Update Method
304
5.2
Insert Data into the Access Database Using a Sample
Project
-
Insert Wizard
304
5.2.1
Create a New Project Based on the Sample Wizards
Project
305
5.2.2
Application User Interfaces
305
5.2.3
Create the Insert Faculty Form Window
305
5.2.4
Validate Data Before the Data Insertion
308
5.2.4.1
Visual Basic Collection and .NET Framework
Collection Classes
308
5.2.4.2
Validate Data Using the Generic Collection
309
5.2.5
Initialization and Termination Coding for the Data
Insertion
312
5.2.6
Build the Insert Query
314
5.2.6.1
Configure the TableAdapter and Build the
Data Insertion Query
314
5.2.7
Develop Code to Insert Data Using the
TableAdapter.Insert Method
315
5.2.8
Develop Code to Insert Data Using the
TableAdapter.Update Method
318
5.2.9
Validate Data After the Data Insertion
322
5.2.9.1
Develop Code to Retrieve the Newly Inserted
Records
323
5.2.9.2
Data Binding for All
Faculty-Information-Related TextBoxes
324
5.2.9.3
Develop Codes to Display the Newly Inserted
Faculty Photo
327
5.3
Insert Data into the SQL Server Database Using a Sample
Project
-
SQLInsertWizard
330
5.3.1
Modify the Existing Project to Create a New Data
Insertion Project
331
5.3.2
Create a New Form Window to Insert Data for the
Course Form
331
5.3.3
Project Initialization and Data Validation Before
Data Insertion
332
xiv Contents
5.3.4
Configure
the TableAdapter and Build the Data
Insertion Query
336
5.3.5
Develop the Code to Insert Data Using the
TableAdapter.Insert Method
337
5.3.6
Perform Data Bindings for the Insert Course
Form Window
341
5.3.7
Develop the Code to Insert Data Using the
TableAdapter.Update Method
342
5.3.8
Data Validation for Newly Inserted Records
344
5.3.8.1
Develop Code to Perform the Data
Validation
345
5.3.8.2
Use the Select Button in the Course Form to
Perform the Data Validation
348
5.3.9
Insert Data into the Database Using Stored
Procedures
349
5.3.9.1
Create the Stored Procedure Using the
TableAdapter Query Configuration Wizard
350
5.3.9.2
Modify the Code to Perform the Data
Insertion Using the Stored Procedure
350
5.4
Insert Data into the Oracle Database Using a Sample
Project OraclelnsertWizard
352
PART II Data Insertion with Runtime Objects
353
5.5
The Runtime Object Method
353
5.6
Insert Data into the SQL Server Database Using the
Runtime Object Method
355
5.6.1
Insert Data into the Faculty Table for the SQL Server
Database
355
5.6.1.1
Add a Data Insertion Form Window
-
Insert
Faculty Form
355
5.6.1.2
Develop the Code to Insert Data into the
Faculty Table
357
5.6.1.2.1
Validate Data Before the Data
Insertion and Startup Coding
357
5.6.1.2.2
Insert Data into the Faculty Table
361
5.6.1.2.3
Validate Data After the Data
Insertion
365
5.6.2
Insert a New Faculty Photo
369
5.6.3
Insert Data into the Microsoft Access Database
Using Runtime Objects
372
5.6.3.1
Modify the Imports Commands
373
5.6.3.2
Modify the Database Connection String
373
5.6.3.3
Modify the Login Query Strings
374
5.6.3.4
Modify the Faculty Query String
375
5.6.3.5
Modifications to Other Forms
377
5.6.4
Insert Data into the Oracle Database Using Runtime
Objects
379
Contents xv
5.6.4.1
Add the Reference and Modify the Imports
Commands
380
5.6.4.2
Modify the Database Connection String
380
5.6.4.3
Modify the Login Query Strings
381
5.6.4.4
Modify the Faculty Query String
383
5.6.4.5
Modifications to Other Forms
384
5.7
Insert Data into the Database Using Stored Procedures
386
5.7.1
Insert Data into the SQL Server Database Using
Stored Procedures
386
5.7.1.1
Add an Insert Data Form Window
-
Insert
Course Form
386
5.7.1.2
Develop Stored Procedures for the SQL
Server Database
388
5.7.1.3
Develop Code to Call Stored Procedures to
Insert Data into the Course Table
390
5.7.1.3.1
Validate Data Before the Data
Insertion and Startup Coding
390
5.7.1.3.2
Develop Code to Call Stored
Procedures
393
5.7.1.3.3
Validate Data After the Data
Insertion
396
5.7.2
Insert Data into the Oracle Database Using Stored
Procedures
397
5.7.2.1
Develop Stored Procedures in the Oracle
Database
398
5.7.2.2
Develop Code to Call Stored Procedures to
Insert Data into the Course Table
401
5.7.2.2.1
Validate Data Before the Data
Insertion and Startup Coding
401
5.7.2.2.2
Develop Code to Call Stored
Procedures
401
5.7.2.2.3
Validate Data After Data Insertion
405
5.8
Chapter Summary
405
5.9
Homework
406
6.
Data Updating and Deleting with Visual Basic.NET
411
PART I Data Updating and Deleting with Visual Basic.NET
Design Tools and Wizards
412
6.1
Update or Delete Data from Databases
413
6.1.1
Updating and Deleting Data from Related Tables in
a DataSet
413
6.1.2
Update or Delete Data from a Database by Using
TableAdapter DBDirect Methods
414
6.1.3
Update or Delete Data from a Database by Using the
TableAdapter.Update Method
414
6.2
Update and Delete Data from an Access Database by
Using the Sample Project AccessUpdateDeleteWizard
415
xvi Contents
6.2.1
Create
a New Project Based on the InsertWizard
Project
416
6.2.2
Application User Interfaces
416
6.2.2.1
Modify the Faculty Form Window
416
6.2.2.2
Bind Data for All Text Boxes of the Faculty
Form Window
417
6.2.3
Validate Data Before Data Updating and
Deleting
418
6.2.4
Build Update and Delete Queries
418
6.2.4.1
Configure TableAdapter and Build the Data
Updating Query
418
6.2.4.2
Build the Data Deletion Query
419
6.2.5
Develop Code to Update Data by Using the
TableAdapter DBDirect Method
420
6.2.5.1
Coding Modifications
420
6.2.5.2
Startup Coding
421
6.2.5.3
Update Coding
421
6.2.6
Develop Code to Update Data by Using the
TableAdapter.Update Method
423
6.2.7
Develop Code to Delete Data by Using the
TableAdapter DBDirect Method
425
6.2.8
Develop Code to Delete Data by Using the
TableAdapter.Update Method
426
6.2.9
Validate the Data After Data Updating and
Deleting
427
6.3
Update and Delete Data from a SQL Server Database by
Using the Sample Project SQLUpdateDeleteWizard
430
6.4
Update and Delete Data from an Oracle Database by
Using the Sample Project OracleUpdateDeleteWizard
433
PART II Data Updating and Deleting with Runtime Objects
434
6.5
The Runtime Object Method
434
6.6
Update and Delete Data from an SQL Server Database by
Using Runtime Objects
436
6.6.1
Update Data in the Faculty Table for the SQL Server
Database
436
6.6.1.1
Modify the Faculty Form Window
437
6.6.1.2
Modify the Original Coding in the Faculty
Form
438
6.6.1.2.1
Modify the Coding for the Faculty
Form
438
6.6.1.3
Develop Code to Update Data
441
6.6.1.4
Validate the Data Updating
443
6.6.2
Delete Data from the Faculty Table for the SQL
Server Database
443
6.6.2.1
Develop Code to Delete Data
444
6.6.2.2
Validate the Data Updating and Deleting
445
Contents xvii
6.7 Update
and Delete Data for an
Oracle
Database by Using
Runtime Objects
447
6.7.1
Add the Oracle Namespace Reference and Modify
the Imports Command
449
6.7.2
Modify the Connection String and Query String for
the Login Form
449
6.7.2.1
Modify the Connection String in the Form
Load Event Procedure
449
6.7.2.2
Modify the SELECT Query String in the
TabLogln Button Event Procedure
449
6.7.2.3
Modify the SELECT Query String in the
ReadLogln Button Event Procedure
450
6.7.3
Modify the Query Strings for the Faculty Form
450
6.7.3.1
Modify the SELECT Query String for the
Select Button Event Procedure
450
6.7.3.2
Modify the UPDATE Query String for the
Update Button Event Procedure
451
6.7.3.3
Modify the DELETE Query String for the
Delete Button Event Procedure
451
6.7.4
Modify the Query Strings for the Course Form
451
6.7.4.1
Modify the SELECT Query String for the
Select Button Event Procedure
451
6.7.4.2
Modify the SELECT Query String for the
CourseList Event Procedure
452
6.7.5
Modify the Query Strings for the Insert Faculty
Form
452
6.7.6
Other Modifications
452
6.8
Update and Delete Data from a Database by Using Stored
Procedures
454
6.8.1
Update Data in an Access Database by Using Stored
Procedures
455
6.8.1.1
Modify the Existing Project
455
6.8.1.1.1
Modify the Imports Command and
Connection String
456
6.8.1.1.2
Modify the Query Strings for the
Login Button Event Procedures
456
6.8.1.1.3
Modify the Query Strings for the
Select and Update Button Event
Procedures
456
6.8.1.1.4
Other Modifications
457
6.8.1.2
Create Stored Procedures in the Access
Database
457
6.8.1.3
Call the Stored Procedure to Update the
Faculty Information
459
6.8.1.4
Confirm the Faculty Information Updating
460
6.8.2
Update Data for an SQL Server Database by Using
Stored Procedures
462
xviii Contents
6.8.2.1
Modify the Existing Project to Create a New
Project
462
6.8.2.2
Develop the Stored Procedure in the SQL
Server Database
465
6.8.2.3
Call the Stored Procedure to Perform the
Data Updating and Validate the Updated
Information
467
6.8.3
Update Data for an Oracle Database by Using Stored
Procedures
469
6.8.3.1
Modify the Existing Project to Create a New
Project
469
6.8.3.2
Develop the Stored Procedure in the Oracle
Database
472
6.8.3.3
Call the Stored Procedure to Perform the
Data Updating and Validation
475
6.8.4
Delete Data from the Oracle Database by Using
Stored Procedures
476
6.8.4.1
Create the Stored Procedure in the Oracle
Database
477
6.8.4.2
Develop the Code to Call the Stored
Procedure to Delete Records
480
6.9
Chapter Summary
481
6.10
Homework
482
7.
Accessing Data in ASP.NET
487
7.1
What Is the .NET Framework?
488
7.2
WhatIsASP.NET?
489
7.2.1
ASP.NET Web Application File Structure
491
7.2.2
ASP.NET Execution Model
491
7.2.3
What Really Happens When a Web Application Is
Executed?
492
7.2.4
The Requirements to Test and Run the Web Project
493
7.3
Develop an ASP.NET Web Application to Select Data
from SQL Server Databases
494
7.3.1
Create the User Interface
-
Login Form
495
7.3.2
Develop the Code to Access and Select Data from
the Database
496
7.3.3
Validate the Data in the Client Side
501
7.3.4
Create the Second User Interface
-
Selection Page
502
7.3.5
Develop the Code to Open the Other Pages
503
7.3.6
Create the Third User Interface
-
Faculty Page
505
7.3.7
Develop the Code to Select the Desired Faculty
Information
508
7.3.7.1
Develop the Code for the Page-Load Event
Procedure
508
7.3.7.2
Develop the Code for the Select Button Event
Procedure
509
Contents xix
7.3.7.3
Develop the Code for Other Procedures
510
7.3.8
Create the Fourth User Interface
-
Course Page
514
7.3.8.1
The AutoPostBack Property of the List Box
Control
515
7.3.9
Develop the Code to Select the Desired Course
Information
516
7.3.9.1
Coding for the Course Page Loading and
Ending Event Procedures
517
7.3.9.2
Coding for the Select Button s Click Event
Procedure
519
7.3.9.3
Coding for the SelectedlndexChanged Event
Procedure of the List Box Control
522
7.3.9.4
Coding for Other User-Defined Procedures
523
7.4
Develop an ASP.NET Web Application to Select Data
from Oracle Databases
525
7.4.1
Modify the Connection String in the Login
Page
526
7.4.2
Modify the Query String in the Login Page
527
7.4.3
Modify the Query String in the Faculty Page
528
7.4.4
Modify the Query String in the Course Page
530
7.5
Develop an ASP.NET Web Application to Insert Data into
SQL Server Databases
534
7.5.1
Create a New Web Page
-
Insert.aspx
534
7.5.2
Develop the Code to Perform the Data Insertion
Functionality
535
7.5.2.1
Develop the Code for the PageJLoad and
Back Button Event Procedures
536
7.5.2.2
Develop the Code for the Insert Button s
Click Event Procedure
537
7.5.2.3
Develop the Code for Other Procedures
539
7.5.3
Validate the Data Insertion
539
7.6
Develop an ASP.NET Web Application to Insert Data into
Oracle Databases
544
7.6.1
Create the Insert Web Page and Develop the Code
545
7.6.1.1
Modifications to Imports Commands and
Page_Load Event Procedure
546
7.6.1.2
Modifications to the Code of Subroutines and
Procedures
546
7.6.2
Modify the Code for the Faculty Page
548
7.7
Develop Web Applications to Update and Delete Data in
SQL Server Databases
551
7.7.1
Application User Interfaces
552
7.7.2
Modify the Code for the Faculty Page
552
7.7.3
Develop the Code for the Update Button Event
Procedure
553
7.7.4
Develop the Code for the Delete Button Event
Procedure
557
xx Contents
7.7.4.1
Relationships Between Five Tables in Our
Sample Database
557
7.7.4.2
Data Deletion Sequence
558
7.7.4.3
Use the Cascade Deleting Option to Simplify
the Data Deletion
559
7.7.4.4
Create the Stored Procedure to Perform the
Data Deletion
561
7.7.4.5
Develop the Code to Call the Stored
Procedure to Perform the Data Deletion
564
7.8
Develop an ASP.NET Web Application to Update and
Delete Data in Oracle Databases
567
7.8.1
Modify the Project to Perform the Data Updating
567
7.8.1.1
Modifications to the Select Button s Click
Event Procedure
567
7.8.1.2
Add the Code to the Update Button and
UpdateParameters Procedures
568
7.8.2
Develop Stored Procedures to Perform the Data
Deletion
570
7.8.2.1
Delete an Existing Record from the Faculty
Table
571
7.8.2.2
Develop the Codes for the Delete Button s
Click Event Procedure
572
7.8.2.3
Validate the Data Deleting Actions
574
7.8.2.4
The On Delete Cascade Constraint in the
Data Table
575
7.9
Chapter Summary
577
7.10
Homework
578
8.
ASP.NET Web Services
582
8.1
What Are Web Services and Their Components?
583
8.2
Procedures to Build a Web Service
585
8.2.1
The Structure of a Typical Web Service Project
585
8.2.2
The Real Considerations When Building a Web
Service Project
586
8.2.3
Procedures to Build an ASP.NET Web Service
587
8.3
Build an ASP.NET Web Service Project to Access an SQL
Server Database
588
8.3.1
Files and Items Created in the New Web Service
Project
588
8.3.2
A Feeling of the HelloWorld Web Service Project as
It Runs
590
8.3.3
Modify the Default Web Service Project
594
8.3.4
Create a Base Class to Handle Error Checking for
Our Web Service
595
8.3.5
Create the Real Web Service Class
596
8.3.6
Add Web Methods into Our Web Service
Class
597
Contents xxi
3.3.7
Develop the Code for Web Methods to Perform the
Web Services
598
8.3.7.1
Web Service Connection Strings
598
8.3.7.2
Modify the Existing Web Method
600
8.3.7.3
Develop the Code to Perform the Database
Queries
602
8.3.7.4
Develop the Code for Subroutines Used in the
Web Method
604
š.3.8
Develop a Stored Procedure to Perform the Data
Query
607
8.3.8.1
Develop the Stored Procedure
WebSelectFacultySP
607
8.3.8.2
Add Another Web Method to Call the Stored
Procedure
608
5.3.9
Use DataSet as the Returning Object for the Web
Method
609
5.3.10
Build Windows-Based Web Service Clients to
Consume the Web Services
612
8.3.10.1
Create a Web Service Proxy Class
612
8.3.10.2
Develop the Graphical User Interface for
the Windows-Based Client Project
614
8.3.10.3
Develop the Code to Consume the Web
Service
616
8.3.10.3.1
Develop the Code for the
Form_Load Event Procedure
617
8.3.10.3.2
Develop the Code for the Select
Button s Click Event Procedure
618
8.3.10.3.3
Develop the Code for Other
Subroutines
619
8.3.10.3.4
Develop a Subroutine ShowFaculty
to Display the Faculty Image
621
5.3.11
Build Web-Based Web Service Clients to Consume
the Web Service
623
8.3.11.1
Create a New Web Site Project and Add an
Existing Web Page
624
8.3.11.2
Add a Web Service Reference and Modify
the Web Form Window
624
8.3.11.3
Modify the Code for the Related Event
Procedures
625
8.3.11.3.1
Modify the Code in the Page-Load
Event Procedure
626
8.3.11.3.2
Modify the Code in the Select
Button Event Procedure
626
8.3.11.3.3
Add Three User-Defined
Subroutines
628
8.3.11.3.4
Modify the Code for the Back
Button Event Procedure
629
xxii Contents
8.3.12
Deploy the Completed Web Service to Production
Servers
630
8.3.12.1
Copy Web Service Files to the Virtual
Directory
631
8.3.12.2
Publish a Precompiled Web Service
632
8.4
Build an ASP.NET Web Service Project to Insert Data into
an SQL Server Database
633
8.4.1
Modify an Existing Web Service Project
633
8.4.2
Web Service Project Development Procedure
635
8.4.3
Develop and Modify the Code for the Code-Behind
Page
635
8.4.3.1
Develop and Modify the First Web Method
-
SetSQLInsertSP
636
8.4.3.2
Develop the Second Web Method
-
GetSQLInsert
640
8.4.3.3
Develop and Modify the Third Web Method
-
SQLInsertDataSet
642
8.4.3.4
Develop the Fourth Web Method
-
GetSQLInsertCourse
647
8.4.3.4.1
Create the Stored Procedure
WebSelectCourseSP
648
8.4.3.4.2
Develop the Code to Call This Stored
Procedure
649
8.4.4
Build Windows-Based Web Service Clients to
Consume the Web Services
653
8.4.4.1
Create a Web Service Proxy Class
653
8.4.4.2
Develop the Graphical User Interface for the
Client Project
654
8.4.4.3
Develop the Code to Consume the Web
Service
657
8.4.4.3.1
Develop the Code to Initialize and
Terminate the Client Project
657
8.4.4.3.2
Develop the Code to Insert a New
Course Record into the Database
658
8.4.4.3.3
Develop the Code to Perform the
Inserted Data Validation
662
8.4.4.3.4
Develop the Code to Get the
Detailed Information for a Specific
Course
666
8.4.5
Build Web-Based Web Service Clients to Consume
the Web Services
668
8.4.5.1
Create a New Web Site Project and Add an
Existing Web Page
669
8.4.5.2
Add a Web Service Reference and Modify the
Web Form Window
670
8.4.5.3
Modify the Code for the Related Event
Procedures
671
Contents xxiii
8.4.5.3.1
Modify the Code in the PageXoad
Event Procedure
672
8.4.5.3.2
Develop Code for the Insert Button
Event Procedure
673
8.4.5.3.3
Develop Code for the TextChanged
Event Procedure of the CourselD
Text Box
674
8.4.5.3.4
Modify the Code in the Select
Button s Click Event Procedure
675
8.4.5.3.5
Modify the Code in the
SelectedlndexChanged Event
Procedure
678
8.4.5.3.6
Modify the Code in the Back
Button s Click Event Procedure
680
8.5
Build an ASP.NET Web Service to Update and Delete
Data in an SQL Server Database
682
8.5.1
Modify an Existing Web Service Project
682
8.5.2
Modify Related Web Methods
683
8.5.2.1
Modify the Web Method from
SetSQLInsertSP to SQLUpdateSP
684
8.5.2.2
Modify the Web Method GetSQLInsert to
GetSQLCourse
686
8.5.2.3
Modify the Web Method
GetSQLInsertCourse to
GetSQLCourseDetail
687
8.5.2.4
Add a New Web Method
-
SQLDeleteSP
689
8.5.3
Develop Two Stored Procedures
-
WebUpdateCourseSP and WebDeleteCourseSP
691
8.5.3.1
Develop the Stored Procedure
WebUpdateCourseSP
691
8.5.3.2
Develop the Stored Procedure
WebDeleteCourseSP
693
8.6
Build Windows-Based Web Service Clients to Consume the
Web Services
702
8.6.1
Modifications to the File Folder and Project Files
702
8.6.2
Add a New Web Reference to Our Client Project
703
8.6.3
Modifications to the Graphical User Interface
704
8.6.4
Modifications to the Code for the Different Event
Procedures
705
8.6.4.1
Modify the Code for the Form_Load Event
Procedure and Form-Level Variables
705
8.6.4.2
Develop the Code for the Update Button
Event Procedure
706
8.6.4.3
Develop the Code for the Delete Button
Event Procedure
707
8.6.4.4
Modify the Code for the Select Button Event
Procedure
708
xxiv Contents
8.6.4.5
Modify the Code for the
SelectedlndexChanged Event Procedure
709
8.7
Build Web-Based Web Service Clients to Consume the
Web Services
713
8.7.1
Create a New Web Site Project and Add an Existing
Web Page
714
8.7.2
Add a Web Service Reference and Modify the Web
Form Window
714
8.7.3
Modify the Code for the Related Event Procedures
and Subroutines
716
8.7.3.1
Modify the Code for the Page-Load Event
Procedure
716
8.7.3.2
Develop Code for the Update Button Event
Procedure
716
8.7.3.3
Develop Code for the Delete Button s Click
Event Procedure
717
8.7.3.4
Modify Code for the Select Button Event
Procedure and Related Subroutines
719
8.7.3.5
Modify Code for the SelectedlndexChanged
Event Procedure of the Course List Box
Control and Related Subroutines
720
8.8
Build an ASP.NET Web Service Project to Access an
Oracle Database
724
8.8.1
Build a Web Service Project
-
WebServiceOracleSelect
725
8.8.2
Modify the Connection String
726
8.8.3
Modify the Namespace Directories
726
8.8.4
Modify the Web Method GetSQLSelect and Related
Subroutines
726
8.8.5
Modify the Web Method GetSQLSelectSP and
Related Subroutines
728
8.8.5.1
Modifications to the Stored Procedure
WebSelectFacultySP
729
8.8.5.2
Modifications to the Code for the Web
Method GetSQLSelectSP
733
8.8.6
Modify the Web Method GetSQLSelectDataSet
734
8.9
Build Web Service Clients to Consume the Web Service
WebServiceOracleSelect
739
8.10
Build an ASP.NET Web Service Project to Insert Data into
an Oracle Database
740
8.10.1
Build a Web Service Project
-
WebServiceOraclelnsert
740
8.10.2
Modify the Connection String
741
8.10.3
Modify the Namespace Directories
741
8.10.4
Modify the Web Method SetSQLInsertSP and
Related Subroutines
742
Contents xxv
8.10.5
Modify the Web Method GetSQLInsert and Related
Subroutines
744
8.10.6
Modify the Web Method SQLInsertDataSet
746
8.10.7
Modify the Web Method GetSQLInsertCourse and
Related Subroutines
748
8.11
Build Web Service Clients to Consume the Web Service
WebServiceOraclelnsert
757
8.12
Build an ASP.NET Web Service to Update and Delete
Data in an Oracle Database
758
8.12.1
Build a Web Service Project
-
WebServiceOracleUpdateDelete
758
8.12.2
Modify the Connection String
759
8.12.3
Modify the Namespace Directories
759
8.12.4
Modify the Web Method SQLUpdateSP and
Related Subroutines
760
8.12.4.1
Develop the Stored Procedure
UpdateCourse_SP
762
8.12.5
Modify the Web Method GetSQLCourse and
Related Subroutines
765
8.12.6
Modify the Web Method GetSQLCourseDetail and
Related Subroutines
766
8.12.7
Modify the Web Method SQLDeleteSP
768
8.12.7.1
Develop the Stored Procedure
WebDeleteCourseSP
770
8.13
Build Web Service Clients to Consume the Web Service
WebServiceOracleUpdateDelete
774
8.14
Chapter Summary
775
8.15
Homework
776
Index
781
|
| any_adam_object | 1 |
| author | Bai, Ying |
| author_GND | (DE-588)104274476 |
| author_facet | Bai, Ying |
| author_role | aut |
| author_sort | Bai, Ying |
| author_variant | y b yb |
| building | Verbundindex |
| bvnumber | BV035473397 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.B3 |
| callnumber-search | QA76.73.B3 |
| callnumber-sort | QA 276.73 B3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)435643604 (DE-599)GBV551983108 |
| discipline | Informatik |
| edition | 1. publ. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02789nam a2200625 c 4500</leader><controlfield tag="001">BV035473397</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20090702 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">090507s2009 d||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2007050326</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780521885188</subfield><subfield code="c">hbk</subfield><subfield code="9">978-0-521-88518-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0521885183</subfield><subfield code="c">hbk</subfield><subfield code="9">0-521-88518-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780521712354</subfield><subfield code="c">pbk</subfield><subfield code="9">978-0-521-71235-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0521712351</subfield><subfield code="c">pbk</subfield><subfield code="9">0-521-71235-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)435643604</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV551983108</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.73.B3</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bai, Ying</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Practical database programming with Visual Basic.NET</subfield><subfield code="c">Ying Bai ; Satish Bhalla (chapters contributor)</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. publ.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Cambridge [u.a.]</subfield><subfield code="b">Cambridge Univ. Press</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxix, 796 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="c">26 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Visual BASIC</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft Visual BASIC</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">BASIC (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft .NET</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">BASIC (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft .NET</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Anwendungsprogramm</subfield><subfield code="0">(DE-588)4395354-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Programmierung</subfield><subfield code="0">(DE-588)4076370-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Anwendungsprogramm</subfield><subfield code="0">(DE-588)4395354-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Programmierung</subfield><subfield code="0">(DE-588)4076370-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bhalla, Subhash</subfield><subfield code="d">1956-</subfield><subfield code="e">Sonstige</subfield><subfield code="0">(DE-588)104274476</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html</subfield><subfield code="y">Contributor biographical information</subfield><subfield code="z">lizenzfrei</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html</subfield><subfield code="y">Publisher description</subfield><subfield code="z">lizenzfrei</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html</subfield><subfield code="y">Table of contents only</subfield><subfield code="z">lizenzfrei</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html</subfield><subfield code="3">Contributor biographical information</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html</subfield><subfield code="3">Publisher description</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017393214&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-017393214</subfield></datafield></record></collection> |
| id | DE-604.BV035473397 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T21:36:04Z |
| institution | BVB |
| isbn | 9780521885188 0521885183 9780521712354 0521712351 |
| language | English |
| lccn | 2007050326 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-017393214 |
| oclc_num | 435643604 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | xxix, 796 S. graph. Darst. 26 cm |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | Cambridge Univ. Press |
| record_format | marc |
| spelling | Bai, Ying Verfasser aut Practical database programming with Visual Basic.NET Ying Bai ; Satish Bhalla (chapters contributor) 1. publ. Cambridge [u.a.] Cambridge Univ. Press 2009 xxix, 796 S. graph. Darst. 26 cm txt rdacontent n rdamedia nc rdacarrier Includes index Microsoft Visual BASIC BASIC (Computer program language) Microsoft .NET Database design Anwendungsprogramm (DE-588)4395354-2 gnd rswk-swf Programmierung (DE-588)4076370-5 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 s Anwendungsprogramm (DE-588)4395354-2 s Programmierung (DE-588)4076370-5 s DE-604 Bhalla, Subhash 1956- Sonstige (DE-588)104274476 oth http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html Contributor biographical information lizenzfrei http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html Publisher description lizenzfrei http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html Table of contents only lizenzfrei http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html Contributor biographical information http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html Publisher description http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html Table of contents only Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017393214&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Bai, Ying Practical database programming with Visual Basic.NET Microsoft Visual BASIC BASIC (Computer program language) Microsoft .NET Database design Anwendungsprogramm (DE-588)4395354-2 gnd Programmierung (DE-588)4076370-5 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| subject_GND | (DE-588)4395354-2 (DE-588)4076370-5 (DE-588)4113276-2 |
| title | Practical database programming with Visual Basic.NET |
| title_auth | Practical database programming with Visual Basic.NET |
| title_exact_search | Practical database programming with Visual Basic.NET |
| title_full | Practical database programming with Visual Basic.NET Ying Bai ; Satish Bhalla (chapters contributor) |
| title_fullStr | Practical database programming with Visual Basic.NET Ying Bai ; Satish Bhalla (chapters contributor) |
| title_full_unstemmed | Practical database programming with Visual Basic.NET Ying Bai ; Satish Bhalla (chapters contributor) |
| title_short | Practical database programming with Visual Basic.NET |
| title_sort | practical database programming with visual basic net |
| topic | Microsoft Visual BASIC BASIC (Computer program language) Microsoft .NET Database design Anwendungsprogramm (DE-588)4395354-2 gnd Programmierung (DE-588)4076370-5 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| topic_facet | Microsoft Visual BASIC BASIC (Computer program language) Microsoft .NET Database design Anwendungsprogramm Programmierung Datenbanksystem |
| url | http://www.loc.gov/catdir/enhancements/fy0809/2007050326-b.html http://www.loc.gov/catdir/enhancements/fy0809/2007050326-d.html http://www.loc.gov/catdir/enhancements/fy0809/2007050326-t.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017393214&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT baiying practicaldatabaseprogrammingwithvisualbasicnet AT bhallasubhash practicaldatabaseprogrammingwithvisualbasicnet |