Buy Practical Database Programming with Visual Basic.NET
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer programming / software engineering > Object-oriented programming (OOP) > Practical Database Programming with Visual Basic.NET
Practical Database Programming with Visual Basic.NET

Practical Database Programming with Visual Basic.NET


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Practical Database Programming with Visual Basic.NET The most up-to-date Visual Basic.NET programming textbook—covering both fundamentals and advanced-level programming techniques—complete with examples and solutions Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge). Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition: Covers both fundamentals and advanced database programming techniques Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies Includes downloadable programming codes and exercise questions This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.

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

About 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.


Best Sellers


Product Details
  • ISBN-13: 9781118162057
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Wiley-IEEE Press
  • Height: 236 mm
  • No of Pages: 896
  • Returnable: N
  • Weight: 1370 gr
  • ISBN-10: 1118162056
  • Publisher Date: 29 Jun 2012
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Spine Width: 61 mm
  • Width: 193 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Practical Database Programming with Visual Basic.NET
John Wiley & Sons Inc -
Practical Database Programming with Visual Basic.NET
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Practical Database Programming with Visual Basic.NET

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!