Practical Database Programming with Visual Basic.NET

Overview

Unlike most database programming books, which overwhelm readers with large amount of code, this book employs a new, more reader-friendly approach. Now in a new edition updated with the latest tools and information, it lays out to readers, in particular college students, how to develop professional and practical database programs in Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0. This new approach allows readers to learn simpler ways of database programming, ...

See more details below
Paperback (New Edition)
$82.12
BN.com price
(Save 20%)$102.95 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (10) from $78.52   
  • New (7) from $82.11   
  • Used (3) from $78.52   
Practical Database Programming with Visual Basic.NET

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$58.99
BN.com price
(Save 42%)$102.95 List Price

Overview

Unlike most database programming books, which overwhelm readers with large amount of code, this book employs a new, more reader-friendly approach. Now in a new edition updated with the latest tools and information, it lays out to readers, in particular college students, how to develop professional and practical database programs in Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0. This new approach allows readers to learn simpler ways of database programming, and enables students to build professional and practical database programming with greater efficiency.

Read More Show Less

Product Details

  • ISBN-13: 9781118162057
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 6/19/2012
  • Edition description: New Edition
  • Edition number: 2
  • Pages: 900
  • Sales rank: 648,752
  • Product dimensions: 7.48 (w) x 9.15 (h) x 1.77 (d)

Meet the Author

YING BAI, PhD, is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University where he received the Grantsperson of the Year Award in 2009. A former senior software engineer in the field of automatic control and testing equipment, Dr. Bai is a Senior Member of IEEE and a member of ACM, and has published ten books and numerous papers on software engineering, interface programming, and fuzzy logic control.

Read More Show Less

Read an Excerpt

Click to read or download
Read More Show Less

Table of Contents

Preface xxv

Acknowledgments xxvii

Chapter 1 Introduction 1

Outstanding Features about This Book 2

Who This Book Is For 2

What This Book Covers 2

How This Book Is Organized and How to Use This Book 5

How to Use the Source Code and Sample Databases 6

Instructors and Customers Supports 8

Chapter 2 Introduction to Databases 10

2.1 What Are Databases and Database Programs? 11

2.2 Develop a Database 13

2.3 Sample Database 14

2.4 Identifying Keys 17

2.5 Define Relationships 19

2.6 ER Notation 21

2.7 Data Normalization 22

2.8 Database Components in Some Popular Databases 26

2.9 Create Microsoft Access Sample Database 34

2.10 Create Microsoft SQL Server 2008 Sample Database 44

2.11 Create Oracle 11g XE Sample Database 61

2.12 Chapter Summary 87

Chapter 3 Introduction to ADO.NET 91

3.1 The ADO and ADO.NET 91

3.2 Overview of ADO.NET 93

3.3 The Architecture of ADO.NET 94

3.4 The Components of ADO.NET 95

3.5 Chapter Summary 145

Chapter 4 Introduction to Language Integrated Query (LINQ) 149

4.1 Overview of Language Integrated Query 149

4.2 Introduction to LINQ Query 161

4.3 The Architecture and Components of LINQ 164

4.4 LINQ to Objects 168

4.5 LINQ to DataSet 179

4.6 LINQ to SQL 197

4.7 LINQ to Entities 210

4.8 LINQ to XML 215

4.9 Visual Basic.NET Language Enhancement for LINQ 227

44.10 Chapter Summary 236

Chapter 5 Data Selection Query with Visual Basic.NET 241

Part I Data Query with Visual Studio.NET Design Tools and Wizards 242

5.1 A Completed Sample Database Application Example 242

5.2 Visual Studio.NET Design Tools and Wizards 245

5.3 Query Data from SQL Server Database Using Design Tools and Wizards 257

5.4 Add and Utilize Visual Studio Wizards and Design Tools 265

5.5 Query and Display Data using the DataGridView Control 268

5.6 Use DataSet Designer to Edit the Structure of the DataSet 272

5.7 Bind Data to the Associated Controls in LogIn Form 274

5.8 Develop Codes to Query Data Using the Fill() Method 278

5.9 Use Return a Single Value to Query Data for LogIn Form 281

5.10 Develop the Codes for the Selection Form 284

5.11 Query Data from the Faculty Table for the Faculty Form 286

5.12 Develop Codes to Query Data from the Faculty Table 289

5.12.1 Develop Codes to Query Data Using the TableAdapter Method 289

5.12.2 Develop Codes to Query Data Using the LINQ to DataSet Method 291

5.13 Display a Picture for the Selected Faculty 292

5.14 Query Data from the Course Table for the Course Form 295

5.15 Develop Codes to Query Data for the Course Form 300

5.16 Query Data from Oracle Database Using Design Tools and Wizards 304

Part II Data Query with Runtime Objects 311

5.17 Introduction to Runtime Objects 312

5.18 Query Data from Microsoft Access Database Using Runtime Object 315

5.19 Query Data from SQL Server Database Using Runtime Object 349

5.20 Query Data from Oracle Database Using Runtime Object 384

5.21 Chapter Summary 411

Chapter 6 Data Inserting with Visual Basic.NET 417

Part I Data Inserting with Visual Studio.NET Design Tools and Wizards 418

6.1 Insert Data into a Database 418

6.2 Insert Data into the SQL Server Database Using a Sample Project InsertWizard 420

6.3 Insert Data into the Oracle Database Using a Sample Project InsertWizardOracle 441

Part II Data Insertion with Runtime Objects 442

6.4 The General Runtime Objects Method 442

6.5 Insert Data into the SQL Server Database Using the Runtime Object Method 444

6.6 Insert Data into the Microsoft Access Database Using the Runtime Objects 453

6.7 Insert Data into the Oracle Database Using the Runtime Objects 461

6.8 Insert Data into the Database Using Stored Procedures 471

6.9 Insert Data into the Database Using the LINQ to DataSet Method 486

6.10 Chapter Summary 488

Chapter 7 Data Updating and Deleting with Visual Basic.NET 493

Part I Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards 494

7.1 Update or Delete Data Against Databases 495

7.2 Update and Delete Data for Microsoft SQL Server Database 498

7.3 Update and Delete Data for Oracle Database 511

7.4 Update and Delete Data for Microsoft Access Database 512

Part II Data Updating and Deleting with Runtime Objects 512

7.5 The Runtime Objects Method 513

7.6 Update and Delete Data for SQL Server Database Using the Runtime Objects 514

7.7 Update and Delete Data for Oracle Database Using the Runtime Objects 520

7.8 Update and Delete Data Against Database Using Stored Procedures 528

7.9 Chapter Summary 554

Chapter 8 Accessing Data in ASP.NET 559

8.1 What Is the .NET Framework? 560

8.2 What Is ASP.NET? 561

8.3 Develop ASP.NET Web Application to Select Data from SQL Server Databases 566

8.4 Develop ASP.NET Web Application to Insert Data into SQL Server Databases 598

8.5 Develop Web Applications to Update and Delete Data in SQL Server Databases 604

8.6 Develop ASP.NET Web Applications with LINQ to SQL Query 618

8.7 Develop ASP.NET Web Application to Select Data from Oracle Databases 628

8.8 Develop ASP.NET Web Application to Insert Data into Oracle Databases 636

8.9 Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases 642

8.10 Chapter Summary 653

Chapter 9 ASP.NET Web Services 657

9.1 What Are Web Services and Their Components? 658

9.2 Procedures to Build a Web Service 659

9.3 Build ASP.NET Web Service Project to Access SQL Server Database 666

9.4 Build ASP.NET Web Service Project to Insert Data into SQL Server Database 714

9.5 Build ASP.NET Web Service to Update and Delete Data for SQL Server Database 762

9.6 Build Windows-Based Web Service Clients to Consume the Web Services 783

9.7 Build Web-Based Web Service Clients to Consume the Web Services 793

9.8 Build ASP.NET Web Service Project to Access Oracle Database 804

9.9 Build Web Service Client Projects to Consume the Web Service 819

9.10 Build ASP.NET Web Service Project to Insert Data into Oracle Database 820

9.11 Build Web Service Client Projects to Consume the Web Service 836

9.12 Build ASP.NET Web Service to Update and Delete Data for the Oracle Database 838

9.13 Build Web Service Client Projects to Consume the Web Service 855

9.14 Chapter Summary 856

Homework 857

Index 860

About the Author 868

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)