Building Datacentric Applications Learning Guide

Interested in creating datacentric applications? Drag-and-drop data binding in Visual Basic 2005 makes connecting to data sources easier than ever. Explore our huge collection of targeted resources to quickly get started and moving in the right direction.

TABLE OF CONTENTS    Quickstart    Expert Advice    Free Book Chapters    Hands-on Virtual Lab    Downloads and Code Samples    General ADO.NET    ADO.NET and SQL Server    Data and XML Namespaces    Data and Data Access    Table Adapters    Data Source Controls    Reference and Documentation    Forums and Newsgroups    More Learning Guides...

Take a moment to e-mail us to let us know what other guides you'd like to see on SearchVB.com.

Microsoft: "Visual Studio 2005 brings with it a host of powerful tools for building datacentric applications. First, there are some new objects that build on top of ADO.NET 1.0. These include a typed DataAdapter class that makes calling a stored procedure as easy as calling a function. The toolbox also contains a new grid control that is very easy to customize and control. Finally, the IDE contains a new Data Sources window that helps you manage these objects and create your user interface at design time."

Quickstart

Table of Contents

• Overview: Introduction to data access
(Microsoft)

• Free PDF Chapter: Building datacentric applications
(Microsoft)

• Chat Transcript: Visual Basic 2005 data enhancements
(Microsoft)

• Tutorials: Microsoft QuickStart Tutorials
(Microsoft)

Expert Advice	Table of Contents
You'll find much more expert advice in our Ask-the-Expert feature. If you have a question on 'XML and Data,' then pose your own question to expert Daniel Cazzulino. View all of our developer expert categories or click below for a sampling of expert advice...

• Advice: How to select and modify or delete a row in an XML file using XSL sheets?


• Advice: Hiding columns with database ID data?


• Advice: Which databases are supported in SQLXML?


• Advice: Editing datagrids, take two?


• Advice: Creating applications to access data via mobile phones?

Free Book: Introducing VB 2005

Table of Contents

Microsoft is offering a free eBook called Introducing Visual Basic 2005 for Developers. Be sure to read Chapter 4 on building datacentric applications.

• Introduction: Introduc ing Visual Basic 2005 for developers


• Chapter 1: Microsoft .NET Framework Primer for the Visual Basic Developer


• Chapter 2: Language enhancements for Visual Basic 2005


• Chapter 3: Visual Studio 2005 Integrated Development Environment


• Chapter 4: Building datacentric applications


• Chapter 5: Constructing user interfaces


• Chapter 6: Building Web applications


• Chapter 7: Microsoft .NET framework enhancements


• Chapter 8: Deploying applications

Virtual Lab: SQL Server and ADO.NET

Table of Contents

Microsoft says, "This virtual lab will show you how to build a Windows application with a data bound grid and how to execute a long-running query that would normally block the user interface. In addition, learn about the new features in ADO.NET 2.0 and the difference between writing your stored procedures in T-SQL versus managed code. You get a downloadable manual and a 90-minute block of time for each module."

• Module 1: Integration services


• Module 2: Introduction to SQL Server Management Studio


• Module 3: XML capabilities


• Module 4: SQL Server and ADO.NET (Lab A)


• Module 5: SQL Server and ADO.NET (Lab B)


• Module 6: T-SQL enhancements


• Module 7: Server management objects


• Module 8: Web services


• Module 9: SQL CLR integration


• Module 10: SQL query tuning

Downloads and Code Samples

Table of Contents

• Download: Collection of VB data access samples
(Microsoft)

• Download: Starter Kit: Movie Collection using data binding
(Microsoft)

• Download: MDAC Utility: Component Checker
(Microsoft)

• Download: Microsoft Data Access Components (MDAC) 2.8 SP1
(Microsoft)

• Download: Release manifest for MDAC 2.8 Service Pack 1
(Microsoft)

• Download: Microsoft Data Access Components (MDAC) 2.8
(Microsoft)

• Download: Release manifest for MDAC 2.8
(Microsoft)

• Sample: Data access application block for .NET, v2
(Microsoft)

• Sample: SQL Server 2005 samples
(Microsoft)

General ADO.NET

Table of Contents

• Article: Teach old data new tricks with the fully loaded advances in ADO.NET 2.0
(Microsoft)

• Article: Query notifications in ADO.NET 2.0
(Microsoft)

• Article: Using asynchronous command execution in ADO.NET 2.0
(Microsoft)

• Article: The WinFS Files: Divide et Impera
(Microsoft)

• Article: ADO.Net 2.0: Relative paths in ConnectionString
(Microsoft)

• Article: DataSet and DataTable in ADO.NET 2.0
(Microsoft)

• Article: Additional new controls
(Microsoft)

• Article: ADO.NET 2.0 Feature Matrix
(Microsoft)

• Article: Asynchronous command execution in ADO.NET 2.0
(Microsoft)

• Article: Generic coding with the ADO.NET 2.0 Base Classes and Factories
(Microsoft)

• Article: New DataSet features in ADO.NET 2.0
(Microsoft)

• Article: Query notifications in ADO.NET 2.0
(Microsoft)

• Article: Schemas in ADO.NET 2.0
(Microsoft)

• Article: SqlConnectionStringBuilder, DataView, and more
(Microsoft)

• Article: Tracing data access
(Microsoft)

• Article: Writing Generic data access code in ADO.NET 2.0
(Microsoft)

• Article: XML Data Type support in ADO.NET 2.0
(Microsoft)

• Guide: Overview of ADO.NET
(Microsoft)

• Guide: Using .NET Framework data providers to access data
(Microsoft)

• Guide: Creating and using DataSets
(Microsoft)

• Guide: XML and the DataSet
(Microsoft)

• Guide: Creating and using DataTables
(Microsoft)

• Guide: Creating and using DataViews
(Microsoft)

• Guide: Accessing an ADO Recordset or Record from ADO.NET
(Microsoft)

• Guide: Sample ADO.NET scenarios
(Microsoft)

• Guide: Writing secure ADO.NET Code
(Microsoft)

• Guide: Implementing a .NET Framework data provider
(Microsoft)

ADO.NET and SQL Server

Table of Contents

• Article: ADO.NET and System.Transactions
(Microsoft)

• Article: New DataSet features in Visual Studio 2005
(Microsoft)

• Article: Managed data access inside SQL Server with ADO.NET and SQLCLR
(Microsoft)

• Article: New DataSet features in ADO.NET 2.0
(Microsoft)

• Article: Using CLR integration in SQL Server 2005
(Microsoft)

• Article: Handling XML just got easier
(Microsoft)

• Article: TableAdapters in Visual Studio 2005
(Microsoft)

• Online eLearning: Building data components in Microsoft Visual Studio 2005
(Microsoft)

• Online eLearning: Building managed code for SQL Server 2005
(Microsoft)

• Webcast: Drag-once data binding
(Microsoft)

• Attachment: The webcast above requires this TechSmith screen capture codec
(Microsoft)

• Webcast: Data sources window
(Microsoft)

• Collection: Visual Basic at the movies: Data and XML
(Microsoft)

• Webcast: SQL Server 2005 as a .NET runtime host
(Microsoft)

• Webcast: Obtaining data for a SQL Server 2005 Express database
(Microsoft)

• Webcast: Working with XML
(Microsoft)

Data and XML Namespaces

Table of Contents

• Namespace: System.Data


• Namespace: System.Data.Common


• Namespace: System.Xml


• Namespace: System.Data.SqlClient


• Namespace: System.Data.Oracle Client


• Namespace: System.Data.SqlTypes


• Namespace: System.Data.OleDb


• Namespace: System.Data.ODBC

Data and Data Access

Table of Contents

• PDC Demo: ADO.NET 2.0: Advanced data access patterns
(Microsoft)

• Article: Accessing data using Visual Basic
(Microsoft)

• Article: Data access tools in Visual Basic
(Microsoft)

• Article: About the Data Environment Designer
(Microsoft)

• Article: Writing reports with the Microsoft Data Report Designer
(Microsoft)

• Tutorial: Interacting with data in a Microsoft Jet/Microsoft Access database
(Microsoft)

• Tutorial: Create a DHTML application that interacts with SQL Server data
(Microsoft)

• Tutorial: Interacting with data in an ASCII text file
(Microsoft)

• Older technology: Converting from RDO 2.0 to ADO 2.0
(Microsoft)

• Older technology: Using Data Access Objects with remote databases
(Microsoft)

• Older technology: Using Remote Data Objects and the RemoteData control
(Microsoft)

Table Adapters

Table of Contents

• Article: TableAdapters in Visual Studio 2005
(Microsoft)

• Article: Table Mapping in Data Adapters
(Microsoft)

• Article: Mapping data-source columns to Dataset data-table columns
(Microsoft)

• Article: Table Mappings Dialog Box
(Microsoft)

• Article: Data Adapter preview dialog box
(Microsoft)

• Article: Generate Dataset Dialog Box
(Microsoft)

• Article: ADO.NET Data Adapters
(Microsoft)

• Article: Creating Data Adapters using Server Explorer
(Microsoft)

• Article: Introduction to Data Adapters
(Microsoft)

• Article: Creating Data Adapters using a wizard
(Microsoft)

• Article: Creating and configuring Data Adapters manually
(Microsoft)

Data Source Controls

Table of Contents

• Part 1: Data Source Controls: The Basics
(Microsoft)

• Part 2: Data Source Controls: Parameters
(Microsoft)

• Part 3: Data Source Controls: Asynchronous data access
(Microsoft)

• Part 4: Data Source Controls: Caching
(Microsoft)

• Part 5: Data Source Controls: Design time functionality
(Microsoft)

• Article: Introduction to Visual Studio Data Designer Extensibility (DDEX)
(Microsoft)

• Article: New DataSet features in Visual Studio 2005
(Microsoft)

Reference and Documentation

Table of Contents

• Reference: Visual Basic reference
(Microsoft)

• Reference: .NET Framework reference information
(Microsoft)

• Reference: Visual Basic language specification
(Microsoft)

• Guide: Program structure and code conventions
(Microsoft)

• Guide: Visual Basic language features
(Microsoft)

• Guide: Object-oriented programming in Visual Basic
(Microsoft)

• Documentation: Accessing data
(Microsoft)

• Documentation: Introduction to distributed applications and data integration
(Microsoft)

• Documentation: Data Walkthroughs
(Microsoft)

• Documentation: Connecting to data sources with ADO.NET
(Microsoft)

• Documentation: ADO.NET Datasets
(Microsoft)

• Documentation: ADO.NET Data Adapters
(Microsoft)

• Documentation: Filtering and sorting in Datasets
(Microsoft)

• Documentation: Relationships in ADO.NET Datasets
(Microsoft)

• Documentation: Performing database operations directly
(Microsoft)

• Documentation: Concurrency control in ADO.NET
(Microsoft)

• Documentation: Data access technologies
(Microsoft)

• Documentation: Overview of visual database tools
(Microsoft)

• Documentation: Data design
(Microsoft)

Forums and Community

Table of Contents

• Where peers share know-how and experience: ITKnowledge Exchange
(SearchVB.com)

• Forums: .NET Framework Data Access and Storage
(Microsoft)

• Forums: .NET Development General
(Microsoft)

• Forums: Windows Forms Data Controls and Databinding
(Microsoft)

• Forums: Web Services
(Microsoft)

• Forums: SQL Server Integration Services
(Microsoft)

• Forums: SQL Data Mining
(Microsoft)

• Forums: SQL Server Data Access
(Microsoft)

• Forums: Visual Basic General
(Microsoft)

• Forums: Visual Basic Language
(Microsoft)

• Forums: Visual Basic IDE
(Microsoft)

• Web |  Usenet  microsoft.public.data.ado


• Web |  Usenet  microsoft.public.data.ado.rds


• Web |  Usenet  microsoft.public.data.odbc

 Return to Table of Contents

VISIT OUR AJAX LEARNING GUIDE
VISIT OUR VISUAL STUDIO 2005 TEAM SYSTEM LEARNING GUIDE
VISIT OUR C# 2005 LEARNING GUIDE
VISIT OUR ASP.NET 2.0 LEARNING GUIDE
VISIT OUR VISUAL BASIC 2005 LEARNING GUIDE
VISIT OUR .NET MIGRATION LEARNING GUIDE
VISIT OUR MOBILE AND WIRELESS DEVELOPMENT LEARNING GUIDE

	ABOUT THE AUTHOR
	Brent Sheets is a former Senior Editor at TechTarget and a frequent contributor to SearchVB.com. He founded and managed the popular Visual Basic Web Directory website until it was acquired by TechTarget in 2000 and relaunched as SearchVB.com. Brent offers tips and tweaks about Apple technology at Mactoids.com.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT .NET Framework database programming best practices Windows 7 for developers Microsoft's Oslo modeling platform, the M language and .NET Using the Visual Studio 2005 DataSet Designer to build a data access layer Windows Developments: Product news February 2008 Oracle updates data access components for Visual Studio 2008 Reporting tool now supports Word 2007 and VS 2008 Windows Developments: Product news, January 2008 Choose the right .NET data provider, optimize application performance Windows Developments: Product news, December 2007 The fallacy of the data layer -- or, a new architectural model for software designs .NET tutorials, guides and quizzes New features in Windows 7 bring new UI considerations for developers Free book from Microsoft brings patterns and practices to .NET VBScript Tutorial Ajax Learning Guide LINQ Learning Guide F# Programming Fast Guide Agile Development Learning Guide .NET User Groups Learning Guide Visual Studio 2008 Learning Guide SharePoint 2007 Learning Guide

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary