Home > Store > Programming > .NET and Windows Programming

larger cover

Add To My Wish List

Share|

Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code

  • By
  • Published Sep 12, 2002 by Sams. Part of the Waite Group series.
    • Copyright 2003
    • Dimensions: 7-3/8" x 9-1/8"
    • Pages: 544
    • Edition: 1st
    • Book
    • ISBN-10: 0-672-32247-1
    • ISBN-13: 978-0-672-32247-1

Register your product to gain access to bonus material or receive a coupon.

  • Description
  • Downloads
  • Extras
  • Reviews
  • Sample Content

The topic combination of VB .NET and ADO.NET is unbeatable. VB .NET is the most popular language in which to code. And, every developer needs to understand ADO.NET to allow data to be accessed from a Web site. In this book Developers will be shown numerouse code examples that will illustrate how to program database driven applications within the .NET Framework. The book is aimed at both established and new VB Developers. Important topics covered include: Visual Studio development environment, ASP.NET applications, Windows Forms application, using VB .NET with ADO.NET, complex queries, security, COM interop., and application deployment.

Downloads

Visual Basic .NET Project Files - 2,844 kb -- VB.NET Project Files.zip

Web Code Samples - 316 kb -- Web Code Samples.zip

Customer Reviews

10 of 11 people found the following review helpful:
2.0 out of 5 stars Good examples, but many errors, May 23, 2003
By 
Mark in NJ (Princeton, NJ) - See all my reviews
Amazon Verified Purchase(What's this?)
This review is from: Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code (Paperback)
First of all, this book is not a reference. It is a book of samples and tutorials. It won't give you details about commands, objects or the nitty-gritty of why things work. It gives you examples of how to do things and only a very general discussion on how it works. It's up to you to learn the details from other sources. So you are best to purchase this with another more detailed reference that will give you the real low-down on ADO.NET.

Second and most troubling is that this book seems to be filled with errors. Some of their examples don't work. After following the steps in the book to the letter, your program won't run and you have to take time (sometimes minutes, sometimes hours) digging through other sources to figure out what this book didn't tell you so you can get things working.

This book answers many questions, but not all. Use it in conjunction with other materials.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


10 of 12 people found the following review helpful:
5.0 out of 5 stars Highly recommended, February 20, 2003
By 
Rick Sline (Houston, TX USA) - See all my reviews
(REAL NAME)   
Amazon Verified Purchase(What's this?)
This review is from: Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code (Paperback)
This book covers the material well, especially for those who are familiar with VB.NET and SQL Server as the book is "for the serious developer." There's very little of the book wasted on background material. Rather than getting bogged down in a lot of theoretical discussion, Barker dives right into examples, making the technical points as he illustrates the examples.

The material in the book flows well from a simple bound list example all the way to some complex Windows and Web examples. Throughout the book, the standard Northwind database is used. Essentially all of the code uses the generic OleDB approach so the code would work with either SQL Server or Access; Barker points out the few differences between using the two approaches.

The general approach in the book follows a format of stating a business problem, a Technique section where the approach is discussed, then a series of numbered Steps, a How It Works section that completes any necessary fine points and... Read more

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1.0 out of 5 stars Plagado de errores, los ejemplos no compilan., July 24, 2003
By 
SILVIA (Monterrey, Nuevo Leon Mexico) - See all my reviews
This review is from: Database Programming with Visual Basic .NET and ADO.NET: Tips, Tutorials, and Code (Paperback)
Ninguno de los ejemplos compila, uno tiene que revisar los errores del compilador para corregirlos y poder ejecutar el programa.

Unicamente tiene recetas de cocina, uno sigue la receta, corrige los errores y el programa funciona, pero no explica en ninguna parte por qué se utilizó cuál o tal función o método.

No se recomienda en absoluto, es una perdida de tiempo y de dinero.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Share your thoughts with other customers:
› See all 5 customer reviews...

Online Sample Chapters

Viewing Data with ADO.NET

Viewing Data with ADO.NET

Table of Contents



Introduction.


1. Developing Windows Forms Using Bound Controls.

Create a Bound List Box. Limit the Data Displayed in a Bound List Box. Bind and View Individual Text Boxes Based Off a Selected List Box Item. Edit and Update Data Using Bound Controls. Add and Delete Records Using Bound Controls. Take Care of Error Handling with Bound Controls. Put the Finishing Touches on a Data Bound Form. Bind Data to ComboBox and DataGrid Controls. Drill Down to Data in the DataGrid Control.



2. Creating SQL Server Database Objects from Visual Studio .NET.

Create a New SQL Server Database from Within Visual Studio .NET. Define Tables and Fields. Define a Primary Key and Other Indexes. Define Relations Between Tables. Define Defaults and Constraints. Create Views. Create Stored Procedures.



3. Viewing Data with ADO.NET.

Retrieve Data by Using the DataReader Object. Retrieve Results from SQL Server by Using the DataTable Object. Locate Records with the DataTable Object. Filter and Sort Records Using the DataView Object.



4. Manipulating Data with ADO.NET.

Edit Data and Update Changes That Are Made to an ADO.NET DataSet Object. Add and Delete Rows in a Dataset with ADO.NET. Execute Parameterized Stored Procedures in ADO.NET. Create and Execute On-the-Fly Batch Updates by Using ADO.NET.



5. Working with Data in Web Forms.

Use Bound Controls with Web Form. Validate Data Using Validation Controls. Populate DropDown and ListBox Controls. Display Data Using the Table Control. Display Data Using the Repeater Control. Display, Sort, and Page Data in the DataGrid Control. Add, Edit, and Delete Data Using the DataGrid Control. Hyperlink from a Row in the Data Grid to a Detail Page.



6. Creating Transact-SQL Commands.

Retrieve Unique Records Using Only a Select Query. Use Variables and Functions in T-SQL. Use Wildcards and Ranges of Values in a SQL Query. Find Records in a Table Without Corresponding Entries in a Related Table? Take Advantage of Using Subqueries. Create, Modify, and Delete Tables. Create a New Table with Data from Existing Tables? Create and Call SQL Server 2000 User-Defined Functions.



7. Performing Common Database Tasks Using SQL-DMO.

Create a Dialog Box to Connect to a New Database, Including Listing Available SQL Servers and Databases. Back Up and Verify a SQL Server Database. Restore a SQL Server Database. Transfer Tables Between SQL Server Databases. Create a Detach/Attach SQL Server Database Dialog Box.



8. Taking Advantage of Data-Driven Techniques.

Work with Data-Bound Multi-Select List Boxes Using Windows Forms. Use a Single Windows Form to Update Multiple Lookup Tables. Create a Point-and-Click SQL Server Query Tool for Users Using a Windows Form. Make a Generic Search Form in a Visual Basic .NET Desktop Application. Work with Data-Bound Multi-Select List Boxes Using Web Forms. Use a Single Web Form to Update Multiple Lookup Tables. Create a Point-and-Click Query Tool for Users Using a Web Form. Make a Generic Search Form in an ASP.NET Web Application.



9. Using Classes with Databases to Make Life Easier.

Define a Class in Visual Basic .NET. Create a Class That Implements the Interface You Defined. Use Visual Studio .NET Tools to Speed Up Writing ADO.NET Code. Control the Creation and Behavior of Classes. Implement the Methods That Update the Database. Validate Data Passed to Properties and Communicate Errors to Developers. Write Data Validation Code That Can Be Reused in Other Classes.



10. Creating Reports Using Crystal Reports.

Create a Report Using Crystal Reports Report Expert. Display a Report That Was Created. Add Calculated Fields to the Crystal Reports Report. Select Whether the Report Will Be Displayed, Printed, or Exported Using Visual Basic .NET Code. Determine Which Records Will Be Printed at Runtime. Print Labels and Control the Order in Which Records Will Be Printed. Create an Onscreen Report That Contains Hyperlinks.



11. Managing SQL Server Security.

Create Windows NT/2000 Users. Create Windows NT/2000 Groups. Establish a Windows NT/2000 Authentication Mode. Establish Mixed-Mode Authentication. Create a Standard Login. Create a Windows NT/2000 Login. Use a Fixed Server Role. Create a Database User Account. Use Statement Permissions. Use Object Permissions. Use Fixed Database Roles. Create Custom Database Roles. Create Application Roles.



12. Utilizing XML Data in Your Visual Basic .NET Applications.

Use XMLWriter to Create an XML Document. Use XMLReader to Read an XML Document. Work with the XML Document Object Model. Retrieve XML from SQL Server 2000. Work with Datasets and XML.



13. Creating XML Web Services.

Get Started with XML Web Services. Create a Simple XML Web Service Using Parameters. Consume XML Web Services. Pass a Dataset Back from an XML Web Service.



Appendix A. Desktop Development with ADO.

When to Use ADO (Local Database/Single Tier Applications). Looking At the ADO Object Models. Referencing the Type Libraries. Using the Connection Object. Working with the ADO Recordset Object. Executing a SQL Server Stored Procedure By Using ActiveX Data Objects. Executing Batch Updates with ADO and SQL Server. Creating SQL Server Objects with ActiveX Data Objects. Conclusion.



Index.

 
Add To Cart

Book  $39.99  $31.99

Usually ships in 24 hours.

This book includes free shipping!

Purchase Reward: One Month Free Subscription
By completing any purchase on InformIT, you become eligible for an unlimited access one-month subscription to Safari Books Online.

Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.

Other Things You Might Like

C# Puzzlers (Video Training)
C# Puzzlers (Video Training)
By
Jan 3, 2012
$35.00
HTML5 Developer's Collection (Collection), The
HTML5 Developer's Collection (Collection), The
By , ,
Dec 29, 2011
$40.79
Administering VMware Site Recovery Manager 5.0
Administering VMware Site Recovery Manager 5.0
By
Dec 28, 2011
$39.99
Informit Network