WhitePaperCodeSampleMenu

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WhitePaperCodeSampleMenu.aspx.vb" Inherits="Members.WhitePaperCodeSampleMenu"%> WhitePaperCodeSampleMenu

DDG White Paper and Code Sample Menu

Title Type Comments

Leveraging ADO.NET for Windows and Web Solutions PowerPoint Slides Introduces ADO.NET for Access and SQL Server Databases

Introduction to VBA Word document Chapter from Programming Microsoft Access Version 2002

Class, Form, and Report Modules Word document Chapter from Programming Microsoft Access Version 2002

Creating and Managing Triggers Word document Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET

Creating Data-Aware Forms Word document Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET

Form Tips: Pitfalls to Avoid Word document White paper by Luke Chung, founder of FMS, Inc.

Inserting, Updating, and Deleting Rows Word document Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET

Introducing Total SQL Analyzer Pro Word document White paper by Luke Chung, founder of FMS, Inc.

Report Tips: Pitfalss to Avoid Word document White paper by Luke Chung, founder of FMS, Inc.

Data Manipulation With XML from IIS Virtual Directories Word document Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET

Access/Excel Interoperability Zip file Excerpt from Access/SQL Server/VB.NET Development Seminar with slides and code samples

Projects for: Leveraging ADO.NET for Windows and Web Solutions Zip file Project folders for PowerPoint presentation

Members Application -- Installment 1 Zip file Selected code samples and commentary describing the guiding principles for the DDG Members Web Site Application

Members Application -- Installment 2 Zip file Selected code samples and commentary describing the guiding principles for the DDG Members Web Site Application

Access 2003 Developers Preview Power Point Slides Preview of selected Access 2003 features of special interest to developers

MSDEExplorer1 article Word document An article explaining how to build custom explorers from Access for MSDE 2000 and SQL Server database servers.

MSDEExplorer1.adp An .adp file An .adp file coordinated with the MSDEExplorer1 article.

MSDEExplorer2_article
Word document
An article demonstrating how to browse and update tables in SQL Server databases from an Access form. No need for linked tables.

MSDEExplorer2.mdb An .mdb file An .mdb file coordinated with the MSDEExplorer2 article.

Programming Visual Basic .NET and ADO.NET for SQL Server and Access PowerPoint Slides A presentation that drills down on Visual Basic .NET programming for Access and SQL Server databases. Includes coverage of connections, commands, datareaders, data adapters, and parameters.

DVPADONETDataAccess Zip file Visual Studio .NET 2003 project folder with the code for implementing the samples discussed in the "Programming Visual Basic .NET and ADO.NET for SQL Server and Access" presentation.

PivotTables Article
Word document
A white paper illustrating practical techniques for using Pivot Tables with Microsoft Access.

PivotTables code samples An .mdb file An .mdb file that the PivotTables article references. This single file includes all the code samples for PivotTables article.

User-level security book excerpt Word document An excerpt from "Programming Microsoft Office Access 2003" describing the basics of user-level security.

Drill-down on Selected Windows Forms Controls
Power Point Slides
An introduction to the OpenFileDialog, ComboBox, ListBox, PictureBox, and DateTimePicker Windows Forms Controls for .NET Framework solutions.

Code Samples for "Drill-down on Selected Windows Forms Controls" Zip file Visual Studio .NET 2003 project folder with the code for implementing the samples discussed in the "Drill-down on Selected Windows Forms Controls" presentation.

Creating Web Services for SQL Server without Code Word document The SQL Server Web Services Toolkit is a benefit to SQL Server developers. It offers an easy way to re-use existing code in SQL Server database objects as Web methods in a Web service. This article shows you how to use the SQL Server Web Services Toolkit.

Creating SQL Server Tables with Access Projects Word document This article presents walkthroughs on how to create several types SQL Server tables from Access projects. It also explains why this knowledge is very valuable to forward-thinking Access developers.

Inserting, Updating, and Deleting with ASP.NET Word document This is an excerpt from "Programming Visual Basic .NET for Microsoft Access Databases". While the samples are explicitly for Access databases, they are readily adaptable to other databases, such as SQL Server.

Signing Access 2003 Database Solutions Word document Access 2003 introduces a new security model to guard against the dissemination of viruses through Access solutions. If your organization or your clients' organizations suffered from virus attacks, you may want to take advantage of this Access 2003 innovation.

Graphically and Programmatically Creating ADO.NET Objects for ASP.NET Pages Word document This excerpt from Programming Microsoft Visual Basic .NET for Microsoft Access Databases contrast graphical and programmatic means of creating ADO.NET objects based on Access databases for ASP.NET pages. The content in this excerpt dynamically formats controls on a page and lets users specify lookup arguments at run time.

Programming Strings, Dates, and Classes with Visual Basic .NET PowerPoint Slides Powerpoint slides from the Core Programming Topics lesson from the Visually Learn Visual Basic .NET in 12 Hours DVD set.

Code samples for "Programming Strings, Dates, and Classes with Visual Basic .NET" Zip file Project folders for the Core Programming Topics lesson.

Introduction To XML Power Point Slides Powerpoint slides from a cut lesson on the Visually Learn Visual Basic .NET DVD set.

Code samples for "Introduction To XML" Zip file Project folder for the Introduction to XML lesson.

Access Forms and Reports PowerPoint file to download This is a 30-slide lesson from the Access, SQL Server, VB.NET Development Seminar materials. The slides present developer-oriented techniques for dynamically formatting forms, specifying recordset and record source properties at run time for forms and reports, and main/sub form along with subdatasheet techniques for showing data.

AccessFormsAndReports.mdb Access .mdb file An Access .mdb file that supports the Access Forms and Reports presentation.

AccessFormsAndReports.adp Access .adp file An Access .adp file that demonstrates how to use Access forms with SQL Server databases. See the Access Forms and Reports slides for the context for using the techniques.

Take the Express Train Word document This white paper gives you an in-depth look at the Express suite of compoments for Visual Basic database developers. These components include a new version of MSDE and other tools optimized to work with the database. You'll learn where to download the beta version for free as well as see samples showing how to use the Express components both graphically and programmatically.

Pivoting Data on a Web Page Word document Illustrates processing techniques for the PivotTable List control in web pages. The PivotTable List control is for cross-tabulation reports. This article describes the steps for creating cross-tabulation reports based on record sources in databases.

Pivoting Data on a Web Page Word document Illustrates processing techniques for the PivotTable List control in web pages. The PivotTable List control is for cross-tabulation reports. This article describes the steps for creating cross-tabulation reports based on record sources in databases.

Getting Started with T-SQL PowerPoint Slides These slides are from the first lesson in Rick Dobson's DVD titled "Beginners SQL Server 2000 T-SQL Programming on DVD". You'll get a very quick introduction to T-SQL programming for SQL Server 2000. In addition, the slides introduce and give step-by-step instructions for using: Query Analyzer, Enterprise Manager, and Books Online.

Code samples for Getting Started with T-SQL Zip file Code samples referred to in the Getting Started with T-SQL presentation.

Use VB.NET to Get Access Data Word document .NET is coming, if it not already here for you personally. The faster Access developers learn .NET, the faster they can benefit from it. This article tackles the topic of how to get Access data with VB.NET applications.

Code samples for Use VB.NET to Get Access Data Zip file Code samples referred to in the Use VB.NET to Get Access Data article.

Package Access 2003 Solutions Word document Access Developer Extensions, which ships as part of Visual Studio Tools for Office, includes a Packaging Wizard for Access 2003 Solutions. With the Packaging Wizard, you can distribute Access 2003 solutions to computers that do not have Access 2003 installed -- even over the Internet. This article shows you how and contains three download URLs with packaged solutions.

Program SQL Stored Procs, User-Defined Functions PowerPoint Slides Power Point slides highlighting the use of parameters with stored procs and user-defined functions. Solutions are presented for queries, inserts, and deletes. Query solution contrasts stored procs with user-defined functions.

T-SQL script file for Program SQL Stored Procs, User-Defined Functions Script file (.sql) T-SQL script file that demonstrates how to create and use stored procs and user-defined functions. Learn the syntax for iput parameters, output parameters, and return status values.

VB.NET project folder for Program SQL Stored Procs, User-Defined Functions Zip file VB.NET project that applies ADO.NET to SQL Server to input and retrieve values from stored procs and user-defined functions. The retrieved values also include row sets that display on Windows forms.

Program Login and User Accounts Word document If you are building SQL Server solutions with Access, you may one day need to add or drop users from a server or a database. This book excerpt shows two different approaches to this task. Pick the one that works best for you.

A First Look at SQL Server Express and SQL Express Manager PowerPoint Slides This Power Point Slide deck introduces Access and SQL Server developers to SQL Server Express, a free edition of SQL Server 2005. The presentation covers installation, using SQL Express to create T-SQL statements to run against SQL Server Express instances, and selected T-SQL 2005 innovations.

Code samples for A First Look at SQL Server Express and SQL Express Manager Zip file A collection of .sql files referred to by the A First Look at SQL Server Express and SQL Express Managers Power Point slide deck.

Title	Type	Comments
Leveraging ADO.NET for Windows and Web Solutions	PowerPoint Slides	Introduces ADO.NET for Access and SQL Server Databases
Introduction to VBA	Word document	Chapter from Programming Microsoft Access Version 2002
Class, Form, and Report Modules	Word document	Chapter from Programming Microsoft Access Version 2002
Creating and Managing Triggers	Word document	Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET
Creating Data-Aware Forms	Word document	Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET
Form Tips: Pitfalls to Avoid	Word document	White paper by Luke Chung, founder of FMS, Inc.
Inserting, Updating, and Deleting Rows	Word document	Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET
Introducing Total SQL Analyzer Pro	Word document	White paper by Luke Chung, founder of FMS, Inc.
Report Tips: Pitfalss to Avoid	Word document	White paper by Luke Chung, founder of FMS, Inc.
Data Manipulation With XML from IIS Virtual Directories	Word document	Excerpt from Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET
Access/Excel Interoperability	Zip file	Excerpt from Access/SQL Server/VB.NET Development Seminar with slides and code samples
Projects for: Leveraging ADO.NET for Windows and Web Solutions	Zip file	Project folders for PowerPoint presentation
Members Application -- Installment 1	Zip file	Selected code samples and commentary describing the guiding principles for the DDG Members Web Site Application
Members Application -- Installment 2	Zip file	Selected code samples and commentary describing the guiding principles for the DDG Members Web Site Application
Access 2003 Developers Preview	Power Point Slides	Preview of selected Access 2003 features of special interest to developers
MSDEExplorer1 article	Word document	An article explaining how to build custom explorers from Access for MSDE 2000 and SQL Server database servers.
MSDEExplorer1.adp	An .adp file	An .adp file coordinated with the MSDEExplorer1 article.
MSDEExplorer2_article	Word document	An article demonstrating how to browse and update tables in SQL Server databases from an Access form. No need for linked tables.
MSDEExplorer2.mdb	An .mdb file	An .mdb file coordinated with the MSDEExplorer2 article.
Programming Visual Basic .NET and ADO.NET for SQL Server and Access	PowerPoint Slides	A presentation that drills down on Visual Basic .NET programming for Access and SQL Server databases. Includes coverage of connections, commands, datareaders, data adapters, and parameters.
DVPADONETDataAccess	Zip file	Visual Studio .NET 2003 project folder with the code for implementing the samples discussed in the "Programming Visual Basic .NET and ADO.NET for SQL Server and Access" presentation.
PivotTables Article	Word document	A white paper illustrating practical techniques for using Pivot Tables with Microsoft Access.
PivotTables code samples	An .mdb file	An .mdb file that the PivotTables article references. This single file includes all the code samples for PivotTables article.
User-level security book excerpt	Word document	An excerpt from "Programming Microsoft Office Access 2003" describing the basics of user-level security.
Drill-down on Selected Windows Forms Controls	Power Point Slides	An introduction to the OpenFileDialog, ComboBox, ListBox, PictureBox, and DateTimePicker Windows Forms Controls for .NET Framework solutions.
Code Samples for "Drill-down on Selected Windows Forms Controls"	Zip file	Visual Studio .NET 2003 project folder with the code for implementing the samples discussed in the "Drill-down on Selected Windows Forms Controls" presentation.
Creating Web Services for SQL Server without Code	Word document	The SQL Server Web Services Toolkit is a benefit to SQL Server developers. It offers an easy way to re-use existing code in SQL Server database objects as Web methods in a Web service. This article shows you how to use the SQL Server Web Services Toolkit.
Creating SQL Server Tables with Access Projects	Word document	This article presents walkthroughs on how to create several types SQL Server tables from Access projects. It also explains why this knowledge is very valuable to forward-thinking Access developers.
Inserting, Updating, and Deleting with ASP.NET	Word document	This is an excerpt from "Programming Visual Basic .NET for Microsoft Access Databases". While the samples are explicitly for Access databases, they are readily adaptable to other databases, such as SQL Server.
Signing Access 2003 Database Solutions	Word document	Access 2003 introduces a new security model to guard against the dissemination of viruses through Access solutions. If your organization or your clients' organizations suffered from virus attacks, you may want to take advantage of this Access 2003 innovation.
Graphically and Programmatically Creating ADO.NET Objects for ASP.NET Pages	Word document	This excerpt from Programming Microsoft Visual Basic .NET for Microsoft Access Databases contrast graphical and programmatic means of creating ADO.NET objects based on Access databases for ASP.NET pages. The content in this excerpt dynamically formats controls on a page and lets users specify lookup arguments at run time.
Programming Strings, Dates, and Classes with Visual Basic .NET	PowerPoint Slides	Powerpoint slides from the Core Programming Topics lesson from the Visually Learn Visual Basic .NET in 12 Hours DVD set.
Code samples for "Programming Strings, Dates, and Classes with Visual Basic .NET"	Zip file	Project folders for the Core Programming Topics lesson.
Introduction To XML	Power Point Slides	Powerpoint slides from a cut lesson on the Visually Learn Visual Basic .NET DVD set.
Code samples for "Introduction To XML"	Zip file	Project folder for the Introduction to XML lesson.
Access Forms and Reports	PowerPoint file to download	This is a 30-slide lesson from the Access, SQL Server, VB.NET Development Seminar materials. The slides present developer-oriented techniques for dynamically formatting forms, specifying recordset and record source properties at run time for forms and reports, and main/sub form along with subdatasheet techniques for showing data.
AccessFormsAndReports.mdb	Access .mdb file	An Access .mdb file that supports the Access Forms and Reports presentation.
AccessFormsAndReports.adp	Access .adp file	An Access .adp file that demonstrates how to use Access forms with SQL Server databases. See the Access Forms and Reports slides for the context for using the techniques.
Take the Express Train	Word document	This white paper gives you an in-depth look at the Express suite of compoments for Visual Basic database developers. These components include a new version of MSDE and other tools optimized to work with the database. You'll learn where to download the beta version for free as well as see samples showing how to use the Express components both graphically and programmatically.
Pivoting Data on a Web Page	Word document	Illustrates processing techniques for the PivotTable List control in web pages. The PivotTable List control is for cross-tabulation reports. This article describes the steps for creating cross-tabulation reports based on record sources in databases.
Pivoting Data on a Web Page	Word document	Illustrates processing techniques for the PivotTable List control in web pages. The PivotTable List control is for cross-tabulation reports. This article describes the steps for creating cross-tabulation reports based on record sources in databases.
Getting Started with T-SQL	PowerPoint Slides	These slides are from the first lesson in Rick Dobson's DVD titled "Beginners SQL Server 2000 T-SQL Programming on DVD". You'll get a very quick introduction to T-SQL programming for SQL Server 2000. In addition, the slides introduce and give step-by-step instructions for using: Query Analyzer, Enterprise Manager, and Books Online.
Code samples for Getting Started with T-SQL	Zip file	Code samples referred to in the Getting Started with T-SQL presentation.
Use VB.NET to Get Access Data	Word document	.NET is coming, if it not already here for you personally. The faster Access developers learn .NET, the faster they can benefit from it. This article tackles the topic of how to get Access data with VB.NET applications.
Code samples for Use VB.NET to Get Access Data	Zip file	Code samples referred to in the Use VB.NET to Get Access Data article.
Package Access 2003 Solutions	Word document	Access Developer Extensions, which ships as part of Visual Studio Tools for Office, includes a Packaging Wizard for Access 2003 Solutions. With the Packaging Wizard, you can distribute Access 2003 solutions to computers that do not have Access 2003 installed -- even over the Internet. This article shows you how and contains three download URLs with packaged solutions.
Program SQL Stored Procs, User-Defined Functions	PowerPoint Slides	Power Point slides highlighting the use of parameters with stored procs and user-defined functions. Solutions are presented for queries, inserts, and deletes. Query solution contrasts stored procs with user-defined functions.
T-SQL script file for Program SQL Stored Procs, User-Defined Functions	Script file (.sql)	T-SQL script file that demonstrates how to create and use stored procs and user-defined functions. Learn the syntax for iput parameters, output parameters, and return status values.
VB.NET project folder for Program SQL Stored Procs, User-Defined Functions	Zip file	VB.NET project that applies ADO.NET to SQL Server to input and retrieve values from stored procs and user-defined functions. The retrieved values also include row sets that display on Windows forms.
Program Login and User Accounts	Word document	If you are building SQL Server solutions with Access, you may one day need to add or drop users from a server or a database. This book excerpt shows two different approaches to this task. Pick the one that works best for you.
A First Look at SQL Server Express and SQL Express Manager	PowerPoint Slides	This Power Point Slide deck introduces Access and SQL Server developers to SQL Server Express, a free edition of SQL Server 2005. The presentation covers installation, using SQL Express to create T-SQL statements to run against SQL Server Express instances, and selected T-SQL 2005 innovations.
Code samples for A First Look at SQL Server Express and SQL Express Manager	Zip file	A collection of .sql files referred to by the A First Look at SQL Server Express and SQL Express Managers Power Point slide deck.