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.
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 |
|
|
View all of our developer expert categories or click below for a sampling of expert advice... |
||
You'll find much more expert advice in our
- 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 Visual Basic 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
VISIT OUR AJAX 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 currently resides
in sunny Florida with his wife and daughter.