MSDN Magazine: Data Access rss

All MSDN Magazine Topics
  • .NET Visualization: Visualizing Information with .NET
    Laurence Moroney - August 2009
    Having the capability to draw pictures usually isn’t enough for a good information visualization platform. The key to building a visualization platform is capabilities such as interactivity, generating metadata, and overlaying related data. You need a level of flexibility that lets you render any data in any way at any time.

  • Entity Framework: N-Tier Application Patterns
    Daniel Simmons - August 2009
    This article examines n-tier patterns for success and some of the key APIs and issues specific to the Entity Framework. It also provides a sneak peak at features coming in the Microsoft .NET Framework 4 that should make n-tier development significantly easier.

  • EF Data Access: EF v2 and Data Access Architecture Best Practices
    Tim Mallalieu - August 2009
    Developers deploy a wide variety of development philosophies and architecture styles. This article explores three common perspectives on application development and describes how the Entity Framework can be employed in each. Specifically, the article looks at the forms-centric, model-centric, and code-centric development styles and their relationship to the Entity Framework.

  • Toolbox: Data Snapshots, Subversion, Source Code Organization and More
    Scott Mitchell - August 2009
    If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.

  • Scale Out: Distributed Caching On The Path To Scalability
    Iqbal Khan - July 2009
    Developers frequently face issues related to scalability bottlenecks when they have applications that need to handle a lot of load. This article describes the role of a distributed cache in building scalable applications.

  • Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More
    Scott Mitchell - July 2009
    If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

  • Velocity: Build Better Data-Driven Apps With Distributed Caching
    Aaron Dunnington - June 2009
    Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.

  • Data Services: Access Your Data On Premise Or In The Cloud With ADO.NET Data Services
    Elisa Flasko - May 2009
    In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.

  • Dynamic WPF: Create Flexible UIs With Flow Documents And Data Binding
    Vincent Van Den Berghe - April 2009
    Flow documents offer enormous flexibility in arranging text layout and pagination, but they don’t support data binding, so you can’t dynamically change content. Here we build a component to solve that problem.

  • Sync Up: Manage Your Data Effectively With The Microsoft Sync Framework
    James Yip - April 2009
    Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.

  • Data Points: Using Silverlight 2 With ADO.NET Data Services
    John Papa - April 2009
    ADO.NET Data Services and Silverlight make a powerful combination, but to make them work well together, there are a few things you need to understand. Here, John Papa explains.

  • Patterns in Practice: Persistence Patterns
    Jeremy Miller - April 2009
    Here we examine data persistence patterns to help you determine which best suits your needs. We look at a number of patterns, including the Active Record, the Data Mapper, the Repository, the Identity Map, the Lazy Loading, and the Virtual Proxy.

  • Database Development: Introducing New Features In The VSTS Database Edition GDR
    Jamie Laflen and Barclay Hill - March 2009
    This article describes features introduced in the GDR for Visual Studio Team Server Database Edition.

  • .NET Interop: Automate Acceptance Testing With IronRuby
    Ben Hall - March 2009
    Acceptance testing verifies that the system under development meets the customer’s requirements. Learn the benefits here.

  • Foundations: Writing More Efficient ItemsControls
    Charles Petzold - March 2009
    Here Charles Petzold explains several techniques for improving the performance of ItemsControls.

  • Data Points: Syndicated Data And Isolated Storage In Silverlight
    John Papa - February 2009
    Here we build a syndicated news reader application to illustrate the use of isolated storage and data syndication in Silverlight.

  • Cutting Edge: Managing Dynamic Content Delivery In Silverlight, Part 2
    Dino Esposito - February 2009
    This month Dino continues his look at managing dynamic Silverlight content by discussing caching and isolated storage.

  • Under The Table: Spatial Data Support In SQL Server 2008
    Bob Beauchemin - February 2009
    New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

  • Visual Studio OBA Tools: Simplify OBA Development With Interop API Extensions
    Andrew Whitechapel, Phillip Hoff, and Vladimir Morozov - December 2008
    To introduce you to VSTO Power Tools Office interop API extensions, we’ll walk through the development of an application that automates Outlook, Excel, and Word.

  • SOA Data Access: Flexible Data Access With LINQ To SQL And The Entity Framework
    Anthony Sneed - December 2008
    Building a data access layer using LINQ to SQL and the ADO.NET Entity Framework allows you to decouple your application from the persistence technology you're using.

  • Advanced Basics: The ObservableCollection Class
    Ken Getz - December 2008
    Ken Getz shows how the CollectionChanged event lets you reflect changes to your underlying data source in your bound data controls.

  • ASP.NET AJAX 4.0: New AJAX Support For Data-Driven Web Apps
    Bertrand Le Roy - October 2008
    Here is an ASP.NET AJAX data-driven Web application that takes the best features from server- and client-side programming to deliver an efficient, user-friendly experience.

  • Basic Instincts: Dynamic Data Entry With XML Literals
    Beth Massi - October 2008
    Learn how to use Windows Presentation Foundation (WPF), XAML, and the deep XML support in Visual Basic to generate user interfaces dynamically.

  • Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008
    Kent Tegels - September 2008
    Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

  • Prism: Patterns For Building Composite Applications With WPF
    Glenn Block - September 2008
    We introduce you to the benefits of building composite applications with the Composite Application Guidance for WPF from Microsoft patterns & practices.

  • Data Services: Create Data-Centric Web Applications With Silverlight 2
    Shawn Wildermuth - September 2008
    ADO.NET Data Services provide Web-accessible endpoints that allow you to filter, sort, shape, and page data without having to build that functionality yourself.

  • Advanced Basics: The LINQ Enumerable Class, Part 2
    Ken Getz - September 2008
    This month Ken digs deeper into the System.Linq.Enumerable class and shows readers how to perform some magic data operations using System.Linq.Enumerable.

  • Foundations: Dependency Properties And Notifications
    Charles Petzold - September 2008
    Windows Presentation Foundation dependency properties don’t always play well with others. Learn how you can compensate for their lack of notification events.

  • Data 2.0: Expose And Consume Data in A Web Services World
    Elisa Flasko and Mike Flasko - August 2008
    The goal of the ADO.NET Data Services Framework is to create a simple REST-based framework for exposing and consuming data-centric services easily.

  • Basic Instincts: Increase LINQ Query Performance
    Jared Parsons - August 2008
    Jared Parsons demonstrates a technique to achieve maximum performance from LINQ queries on large sets of data in order to create a responsive user interface.

  • Data Services: Develop Robust and Scalable Apps with SQL Server Data Services
    David Robinson - July 2008
    Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.

  • ADO.NET: Achieve Flexible Data Modeling with the Entity Framework
    Elisa Flasko - July 2008
    Here the author answers questions regarding the Entity Framework and provides an understanding of how and why it was developed.

  • Data and WPF: Customize Data Display with Data Binding and WPF
    Josh Smith - July 2008
    Here we present techniques for programmatic and declarative data binding and display with Windows Presentation Foundation.

  • Editor's Note: Flex Your Data
    Ted Neward - July 2008
    Filling in for Editor-in-Chief Howard Dierking, Ted Neward lends some insight into the state of data collection and manipulation.

  • Toolbox: Easy Wiki Hosting, Scott Hanselman’s blog, and Snagging Screens
    Scott Mitchell - July 2008
    Host a wiki the easy way, get the screen shots you need and mark them up, and read about LINQ this month in Toolbox.

  • Data Points: The Entity Framework in Layered Architectures
    John Papa - July 2008
    Here we build a solution that fits the Entity Framework into an n-tier architecture that uses WCF and WPF and the MVP pattern.

  • Advanced Basics: The LINQ Enumerable Class, Part 1.
    Ken Getz - July 2008
    Presented here is the LINQ Enumerable class, which allows you to manipulate data in any class that implements IEnumerable(Of T).

  • Office Apps: Integrate VSTO with SharePoint Content Types
    Steve Fox - May 2008
    See how to build a document-level Visual Studio Tools for Office customization and integrate it with a content type in SharePoint.

  • MOSS 2007: Automate Web App Deployment with the SharePoint API
    E. Wilansky, P. Olszewski, and R. Sneddon - May 2008
    Learn how to automate custom SharePoint application deployments, use the SharePoint API, and avoid the hassle of custom site definitions.

  • Toolbox: Database Audit Logs, Joel on Software, Code Handouts, and More
    Scott Mitchell - May 2008
    This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.

  • Data Points: Entity Framework Q&A
    John Papa - May 2008
    The Entity Framework is a hot topic, but how do you know when to use EntityClient, Object Services, Entity SQL, or LINQ? Find out here.

  • Cutting Edge: ListView Tips and Tricks
    Dino Esposito - April 2008
    This month, use nested ListView controls to create hierarchical views of data and extend the eventing model of the ListView by deriving a custom ListView class.

  • Test Run: Testing SQL Stored Procedures Using LINQ
    Dr. James McCaffrey - April 2008
    Language Integrated Query makes lots of things easier. Here we put LINQ, or more specifically the LINQ to SQL provider, to use testing SQL stored procedures.

  • Data Points: Standard Query Operators with LINQ
    John Papa - March 2008
    LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.

  • Data Points: Designing an Entity Data Model
    John Papa - February 2008
    With the Entity Framework, developers are given more flexibility by being able to design around a conceptual model rather than a relational data model. To get started, you need to know how to design an Entity Data Model. John Papa walks you through that process.

  • SQL Server: Uncover Hidden Data to Optimize Application Performance
    Ian Stirk - January 2008
    SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.

  • Data Points: Accessing Data from a Mobile Application
    John Papa - January 2008
    This month John Papa takes a look at developing a mobile application that can access data on your application server.

  • Data Points: Data Binding in WPF
    John Papa - December 2007
    WPF is one of the most important new technologies in the .NET Framework 3.0. This month John Papa introduces its data binding capabilities.

  • Toolbox: Manage databases, easier FTP, and clustered caching
    Scott Mitchell - October 2007
    This month's products include DatabaseSpy, FileZilla, NCache, and more.

  • Data Points: Common Table Expressions
    John Papa - October 2007
    In T-SQL, views and derived tables serve similar purposes and have their advantages. But when working with SQL Server 2005,there's a third option--using Common Table Expressions (CTEs). John Papa explains.

  • Foundations: Workflow Communications
    Matt Milner - September 2007
    Matt Milner introduces the Windows Workflow Foundation (WF) communication architecture and covers sending data out of a workflow and submitting data to running workflow instances.

  • Data Points: ADO.NET Entity Framework Overview
    John Papa - July 2007
    The new Entity Framework in ADO.NET will let you manipulate data using an object model. John Papa explains.

  • Security Briefs: Active Directory Cache Dependencies
    Keith Brown - July 2007
    If you're not taking advantage of Active Directory, you should be. Learn the benefits from Keith Brown.

  • Data Points: SQL Server Management Objects
    John Papa - June 2007
    SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.

  • Cutting Edge: Validating ASP.NET Query Strings
    Dino Esposito - March 2007


  • Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals
    Brian A. Randell - February 2007
    Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

  • SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier
    David Banister - February 2007
    Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

  • Data Points: Data Bound Applications with ADO.NET and Custom Objects
    John Papa - February 2007
    In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.

  • Data Points: Column Expressions, DataRelations, and Computations
    John Papa - January 2007
    This month John Papa fields some of his favorite questions regarding data manipulation with ADO.NET.

  • Extend ASP.NET: Simplify Data Binding In ASP.NET 2.0 With Our Custom Control
    Rick Strahl - December 2006
    The wwDataBinder control addresses simple control data binding--binding simple form controls like textboxes, checkboxes, and the selected values of list controls to individual data or object values.

  • Data Points: RSS Feeds on a Smartphone
    John Papa - December 2006
    John Papa builds a Windows Mobile 5.0 application that reads RSS feeds and loads them into an ADO.NET DataSet.

  • SQL Security: New SQL Truncation Attacks And How To Avoid Them
    Bala Neerumalla - November 2006
    Exploits using SQL injection have drawn a lot of attention for their ability to get through firewalls and intrusion detection systems to compromise your data layers. Whether it's a first-order or second-order injection, if you look at the basic code pattern, it is similar to any other injection issue where you use untrusted data in the construction of a statement.

  • Data Points: Revisiting System.Transactions
    John Papa - November 2006
    The System.Transactions namespace of the Microsoft .NET Framework makes handling transactions much simpler than previous techniques. Read all about it this month.

  • SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services
    Teo Lachev - October 2006
    Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

  • Toolbox: Protecting Code, Persisting Data, and More
    Scott Mitchell - October 2006
    This month obfuscating your code, persisting your data, and a good read on SQL Server 2005.

  • Security Briefs: CardSpace, SqlMembershipProvider, and More
    Keith Brown - October 2006
    This month Keith Brown fields some reader questions on InfoCard turned CardSpace and passwords for SqlMembershipProvider.

  • .NET Matters: Scope<T> and More
    Stephen Toub - September 2006
    This month Stephen Toub explains how you can get some of the functionality found in the TransactionScope class in your own classes.

  • Cutting Edge: All About Enums
    Dino Esposito - August 2006
    Dino Esposito reviews the basics of enumeration types and their implementation in the Microsoft .NET Framework.

  • Web App Follies: Keep Sites Running Smoothly By Avoiding These 10 Common ASP.NET Pitfalls
    Jeff Prosise - July 2006


  • Data Points: Report Controls in SQL Server 2005 Reporting Services
    John Papa - July 2006
    Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

  • Share The Load: Report Visual Studio Team System Load Test Results Via A Configurable Web Site
    Wen Ding - June 2006
    This article discusses a new load test tool in Visual Studio 2005 Team System for performance and stress testing your Web sites, Web services, and other server components. Combined with its handy reporting capabilities, the load test tool provides some powerful options for sharing and managing test results.

  • Data Points: Designing Reports with SQL Server Reporting Services 2005
    John Papa - June 2006
    Many applications require some degree of integration with a reporting tool. A good solution, SQL Server™ Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

  • Data Points: SQL Server 2005 XML Support, Exception Handling, and More
    John Papa - May 2006
    SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.

  • Office Unbound: Bring Your Documents To Life With Data Binding In Visual Studio Tools For Office
    Eric Carter and Eric Lippert - March 2006
    Thanks to Visual Studio 2005 Tools for the Microsoft Office System, Windows Forms controls can be bound to databases, Web services, or objects and added to a workbook or document. Find out how.

  • Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration
    Ed Hild - March 2006
    The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

  • Data Points: Using XQuery, New Large DataTypes, and More
    John Papa - March 2006
    SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.

  • Data Points: SqlConnectionStringBuilder, DataView, and More
    John Papa - January 2006
    Several significant enhancements have been made to ADO. NET 2. 0 in the areas of improved performance, increased flexibility, and added features. In my last column (Data Points: DataSet and DataTable in ADO.

  • Web Apps: An Overview Of The New Services, Controls, And Features In ASP.NET 2.0
    Jeff Prosise - Visual Studio 2005 Guided Tour 2006
    ASP.NET 2.0 aims to reduce the amount of code required to accomplish common Web programming tasks by 70 percent or more. New services, controls, and features make it almost as dramatic an improvement to ASP.NET 1.x as that was to ASP Classic. Here Jeff Prosise explores the new features.

  • Data Points: DataSet and DataTable in ADO.NET 2.0
    John Papa - November 2005
    ADO. NET 2. 0 sports some exciting enhancements to the core classes found in ADO. NET 1. x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency.

  • Data Points: The Enterprise Library Data Access Application Block, Part 3
    John Papa - October 2005
    E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.

  • SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
    Jay Nathan - September 2005
    SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.

  • Data Binding: Give Your Everyday Custom Collections a Design-Time Makeover
    Paul Ballard - August 2005
    In this article, Paul Ballard shows how you can provide data binding support for your custom collections to enable sorting, searching, and editing in as simple a manner as possible. In addition, he shows how to make all of these features available in the Windows and Web Forms Designers, just like an ADO.NET DataSet.

  • Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer
    Rob Howard - August 2005
    In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

  • Data Points: The Enterprise Library Data Access Application Block, Part 2
    John Papa - August 2005
    Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).

  • Cutting Edge: DataSets vs. Collections
    Dino Esposito - August 2005
    In software, five years is like a geological era. Five years ago, the Microsoft® . NET Framework had just been announced. Since then, the DataSet has emerged as the key object for performing a variety of data-related tasks in .

  • Data Points: The Enterprise Library Data Access Application Block, Part 1
    John Papa - July 2005
    A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.

  • Know Thy Code: Simplify Data Layer Unit Testing using Enterprise Services
    Roy Osherove - June 2005
    If you want to employ unit testing and test-driven development techniques in your database application development process, you'll have different factors to consider than you do when you're not involving a database. For example, you have to maintain a consistent state within the database and be able to roll back transactions when necessary. This article shows you how to get the best of unit testing for your database apps in a safe, usable manner.

  • Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications
    Liu Tang and Paul Bradley - June 2005
    Analysis Management Objects (AMO) for SQL Server 2005 facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions.

  • Cutting Edge: Data Repeater Controls in ASP.NET
    Dino Esposito - June 2005
    The ASP. NET Repeater is a basic container control that allows you to create custom lists from any data available to the page. It's a handy control, especially since most ASP. NET pages that display data need to repeat the same kinds of data over and over.

  • Data Points: XML Features in SQL Server 2000
    John Papa - June 2005
    SQL Server™ 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.

  • Wicked Code: Power Programming Tips for ASP.NET 2.0
    Jeff Prosise - June 2005
    In the February 2005 issue, I introduced five lesser-known features of ASP. NET 2. 0 that have the potential to make a significant impact on the security, performance, and robustness of your code (see Wicked Code: Five Undiscovered Features on ASP.

  • Cutting Edge: Collections and Data Binding
    Dino Esposito - May 2005
    When it's time to design the Data Access Layer (DAL) of your distributed Microsoft® . NET Framework-based app, one of the key decisions you'll make is how you'll pass data to and from methods of DAL classes.

  • Data Points: Data Access Strategies Using ADO.NET and SQL
    John Papa - May 2005
    When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy. You can't just do some testing on your production machines and rely on the results.

  • Extreme ASP.NET: A Little Bit of Control for Your Controls
    Rob Howard - May 2005
    Having worked for so many years designing and developing ASP. NET while at Microsoft, it's exciting now to have a venue in which to talk about it. In this new column, Extreme ASP. NET, I'll discuss and demonstrate time-tested techniques and approaches to implementing high-performance, reliable, secure, and user-friendly Web applications with ASP.

  • Flex Your Data: Teach Old Data New Tricks with the Fully Loaded Advances in ADO.NET 2.0
    Julia Lerman - April 2005
    ADO.NET 2.0 will streamline your data access development efforts. Its new features let you work better with XML and SQL Server, and they offer lots of other improvements as well. This article takes a detailed look at some of the more interesting enhancements and focuses on performance and flexibility.

  • Test Run: Automate Your ASP.NET Web Services Testing
    James McCaffrey - March 2005
    It's no exaggeration to say that Web services are revolutionizing application-to-application communication. Web services are already being used extensively in corporate intranet environments and are making their way into commercial use, too.

  • Office: Relive the Moment by Searching Your IM Logs with Custom Research Services
    John R. Durant - February 2005
    Often, IM conversations contain important information you'd like to keep and reuse. Fortunately, MSN Messenger 6.2 has a feature to keep a conversation history permanently in XML format. This article shows you how to leverage that conversation history by consolidating IM exchanges so they are indexed, searchable, and ultimately reusable using the Microsoft Office 2003 Research and Reference task pane.

  • SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services
    James Yip - February 2005
    SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

  • Data Points: ADO.NET and System.Transactions
    John Papa - February 2005
    The Microsoft® . NET Framework versions 1. 0 and 1. 1 represented major changes in software development. However, one important thing that did not change much was support for distributed transactions.

  • ASP.NET: 10 Tips for Writing High-Performance Web Applications
    Rob Howard - January 2005
    Writing a Web application with ASP.NET is unbelievably easy. So many developers don't take the time to structure their applications for great performance. In this article, the author presents 10 tips for writing high-performance Web apps. The discussion is not limited to ASP.NET applications because they are just one subset of Web applications.

  • Data Points: Data Source Controls in ASP.NET 2.0
    John Papa - January 2005
    ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.

  • Data Points: Efficient Coding With Strongly Typed DataSets
    John Papa - December 2004
    Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.

  • Web Q&A: ADO.NET Joins, HTML to XHTML, ASP.NET ViewState, and More
    Edited by Nancy Michell - November 2004


  • Data Points: Updating Data in Linked Servers, Information Schema Views, and More
    John Papa - November 2004
    Every day a developer somewhere needs to write code to iterate through SQL Server™ system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

  • Data Points: Handling Data Concurrency Using ADO.NET, Part 2
    John Papa - October 2004
    Enterprise development has been moving towards a discon-nected model in recent years and ADO. NET development is no exception. While the disconnected model of the ADO. NET DataSet offers great flexibility, that adaptability also means looser control over data updates than you get with a connected data access model.

  • Cutting Edge: Binary Serialization of DataSets
    Dino Esposito - October 2004
    The ADO. NET DataSet object plays an essential role in most of today's distributed, multitiered applications. Instances of the DataSet class are used to move data across the tiers and to exchange data with external services.

  • Data Security: Stop SQL Injection Attacks Before They Stop You
    Paul Litwin - September 2004
    To execute a SQL injection attack, a hacker writes a Web page that captures text in a textbox to be used to execute a query against a database. The hacker enters a malformed SQL statement into the textbox that causes the back-end database to perform operations the owners did not intend it to perform, like making unauthorized updates. This article explains how you can protect against the all too common SQL injection attack in your own database. The steps covered include data validation, proper exception handing, and much more.

  • SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005
    Jamie MacLennan - September 2004
    In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

  • Data Points: Handling Data Concurrency Using ADO.NET
    John Papa - September 2004
    One of the key features of the ADO. NET DataSet is that it can be a self-contained and disconnected data store. It can contain the schema and data from several rowsets in DataTable objects as well as information about how to relate the DataTable objects—all in memory.

  • Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services
    John C. Hancock - August 2004
    SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

  • GridView: Move Over DataGrid, There's a New Grid in Town!
    Dino Esposito - August 2004
    When incorporating the ASP.NET DataGrid control into your Web apps, common operations such as paging, sorting, editing, and deleting data require more effort than you might like to expend. But all that is about to change. The GridView control--the successor to the DataGrid-- extends the DataGrid's functionality it in a number of ways. First, it fully supports data source components and can automatically handle data operations, such as paging, sorting, and editing, as long as its bound data source object supports these capabilities. In addition, the GridView control offers some functional improvements over the DataGrid. Here DataGrid expert Dino Esposito introduces the GridView and explains all its long-awaited features.

  • Data Points: Migrating from ADO to ADO.NET, Part 2
    John Papa - August 2004
    As you move forward with your use of ADO. NET, you'll need to know how to approach situations that you previously learned to handle in ADO and now have to tackle with ADO. NET. Just as n-tiered solutions developed using Visual Basic®, C++, and ASP often rely on ADO for their data access needs, Windows® Forms, Web Forms, and Web services rely on ADO.

  • Web Q&A: Pop-Ups, Encrypting an ADO.NET Data Stream, and More
    Edited by Nancy Michell - July 2004


  • Data Points: Migrating from ADO to ADO.NET
    John Papa - July 2004
    In recent years ADO has taken the lead as the preferred method for implementing data access in Windows®-based applications. Huge numbers of ADO applications are in use today and many developers are well versed in ADO development.

  • Cutting Edge: Implement Custom Cache Dependencies in ASP.NET 1.x
    Dino Esposito - July 2004
    One of the most compelling improvements that ASP. NET brought to ASP programming was the Cache object. The Cache has some similarities to the Application object and is a container of global data (as opposed to session-specific data) that features a fair number of innovative characteristics.

  • Advanced Basics: Data Binding Radio Buttons to a List
    Duncan Mackenzie - July 2004


  • Data: More Load, Less Code with the Data Enhancements of ASP.NET 2.0
    Dino Esposito - June 2004
    A data source control is a server control that wraps some basic functions of a data source - be it a SQL Server database, an XML document, an Excel worksheet, or a sitemap description. Through the services of a similar component, data-bound controls can fetch data as well as insert new records or update and delete existing ones. Data source controls enable a consistent model across a variety of data sources and dramatically reduce the amount of code needed to implement a two-way data-binding scenario. This article provides an introduction to data source controls and other related data binding features.

  • Data Points: Contrasting the ADO.NET DataReader and DataSet
    John Papa - June 2004


  • Data Points: Saving Parent-child Data in a Multitiered App Using ADO.NET
    John Papa - May 2004


  • Web Q&A: JScript Leaks, Getting the XmlDataDocument, and ASPX Includes
    Edited by Nancy Michell - April 2004


  • Yukon Basics: XML, T-SQL, and the CLR Create a New World of Database Programming
    Eric Brown - February 2004
    The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored procedures, and triggers written in CLR-targeted languages, including Visual Basic .NET and C#. It supports a subset of the W3C standard XQuery language, and has native XML support.In this article, the author outlines the most significant language features and builds an order-entry sample app.

  • Web Q&A: Virtual Directories, Releasing DB Connections, and More
    Edited by Nancy Michell - December 2003


  • Advanced Basics: Windows Forms Q&A
    Ken Spencer - December 2003


  • Protect It: Safeguard Database Connection Strings and Other Sensitive Settings in Your Code
    Alek Davis - November 2003
    Protecting application secrets, such as database connection strings and passwords, requires careful consideration of a number of pertinent factors such as how sensitive the data is, who could gain access to it, how to balance security, performance, and maintainability, and so forth. This article explains the fundamentals of data protection and compares a variety of techniques that can be used to protect application settings. The author discusses what to avoid, such as hiding keys in source code and the use of Local Security Authority. In addition, he presents some effective solutions such as the Data Protection API.

  • Advanced Basics: SQL Server Metadata
    Ken Spencer - November 2003


  • Blogging: Design Your Own Weblog Application from Scratch Using ASP.NET, JavaScript, and OLE DB
    Marco Bellinaso - October 2003
    The ASP.NET advanced templated controls, such as the DataList and DataGrid, are perfect for many data representation situations. However, when you need the flexibility to render a variety of layouts, the Repeater control is what you need. In this article the author builds a full-featured blog application to illustrate the use of the Repeater and DataList controls that render nested data in a master-detail relationship. He then discusses how to override the default implementations of these controls by adding some client-side JavaScript code that makes the blog more responsive and enhances its usability.

  • Web Q&A: Schema From a DataSet, Exporting SQL Data to Excel, and More
    Edited by Nancy Michell - October 2003


  • Data Points: Exploring the ADO.NET DataRow
    John Papa - October 2003


  • Data Points: Developing Apps with the .NET Compact Framework, SQL Server CE, and Replication
    John Papa - September 2003


  • ASP.NET: Jump Start Your Web Site Development with the ASP.NET Starter Kits
    Paul Litwin - August 2003
    If you're building an ASP.NET Web site you could probably use a good, solid code foundation to start with and build upon. Wouldn't it be nice to start with a complete site, make a few tweaks and customizations, and go live? The ASP.NET Starter Kits are packaged solutions that let you do just that. The five kits—Community, Reports, Commerce, Portal, and Time Tracker—supply full, reusable code that can be easily customized. In addition, there are a number of ISPs that support automatic deployment of ASP.NET Starter Kit Web sites, leaving you with little left to do when you have to get there fast. Here, the author introduces the ASP.NET Starter Kits and builds a community Web site with lots of advanced features such as ratings, user polls, upload quotas, change notifications, and themes.

  • DataGrid: Tailor Your DataGrid Apps Using Table Style and Custom Column Style Objects
    Kristy Saunders - August 2003
    One of the most enduring challenges in writing user interfaces is figuring out how to display large amounts of data efficiently and intuitively without bewildering the user. The problem becomes particularly thorny when the interface must reflect hierarchical relationships within the data that the user needs to modify. The Windows Forms DataGrid control gives developers a powerful and flexible tool to meet this challenge. This article explains its basic operations and shows how to extend the DataGrid to display columns of data in an application-appropriate manner.

  • Advanced Basics: Data Binding in Visual Basic .NET
    Ken Spencer - August 2003
    Ken Spencer introduces data binding in Visual Basic .NET.

  • Data Points: Managing Hierarchical Inserts in ASP.NET and ADO.NET
    John Papa - July 2003


  • Data Points: Techniques in Filling ADO.NET DataTables: Performing Your Own Analysis
    John Papa - June 2003
    How do you know which technique is best for retrieving data and populating a DataSet in ADO.NET?. Since the Microsoft .NET Framework offers so many choices on how to write the code, many developers are now taking a close look at the different options. See what they are.

  • Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000
    Alok Mehta and Ricardo Rodriguez - May 2003
    SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

  • ADO.NET: Tackle Data Concurrency Exceptions Using the DataSet Object
    David Burgett - April 2003
    ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. This article examines the common causes behind data concurrency exceptions and presents techniques for overcoming them.

  • Advanced T-SQL: Automate the Generation of Stored Procedures for Your Database
    Peter W. DeBetta and J. Byer Hill - April 2003
    Design-time automation makes coding faster and ensures that all the procedures generated use the same naming conventions and structure. In an effort to improve their coding efficiency in a large SQL project, the authors wrote a set of design-time stored procedures that generate run-time stored procedures, and have used them in project after project ever since. Recently, the authors updated their procedures to make use of SQL Server 2000 features, including user-defined functions. This article covers the creation and execution of these dynamic T-SQL scripts to automate the coding of common database stored procedures.

  • Data Access: Implement a Data Access Layer for Your App with ADO.NET
    Dan Fox - April 2003
    Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelines, and carefully examining your needs before deciding on a presentation method and external interface.

  • The XML Files: Web Services and DataSets
    Aaron Skonnard - April 2003
    Programmers using Visual Basic® 6. 0 have long bowed to the altar of the ADO recordset. It's probably the most commonly used data structure in Windows®-based applications today. The ADO. NET DataSet is poised to play a similar role in the realm of managed Windows-based applications.

  • The XML Files: Web Services and DataSets
    Aaron Skonnard - April 2003
    Programmers using Visual Basic® 6. 0 have long bowed to the altar of the ADO recordset. It's probably the most commonly used data structure in Windows®-based applications today. The ADO. NET DataSet is poised to play a similar role in the realm of managed Windows-based applications.

  • Wicked Code: Supporting Database Cache Dependencies in ASP.NET
    Jeff Prosise - April 2003
    Developers love the ASP. NET application cache. One reason they love it is that ASP. NET lets them create dependencies between items placed in the cache and files in the file system. If a file targeted by a dependency changes, ASP.

  • Data Points: Expressions in ADO.NET
    John Papa - January 2003
    Managing relations in a database became a whole lot easier with ADO. NET. Instead of returning a single rowset to a data store, you can return a series of rowsets and relate them within a DataSet. There are numerous advantages to using related DataTables in ADO.

  • Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization
    David Burgett - December 2002
    Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

  • Cutting Edge: Binary Serialization of ADO.NET Objects
    Dino Esposito - December 2002
    One of the key elements that makes ADO. NET superior to ADO is the level of integration with XML. In ADO, XML is just an I/O format. In addition, the ADO XML format is totally inflexible and doesn't allow any type of customization.

  • Data Points: DataRelations in ADO.NET
    John Papa - November 2002
    One of the biggest differences between traditional ADO and ADO. NET is that the rowsets stored within ADO. NET can be truly relational. For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders.

  • Spider in .NET: Crawl Web Sites and Catalog Info to Any Data Store with ADO.NET and Visual Basic .NET
    Mark Gerlach - October 2002
    Visual Basic .NET comes loaded with features not available in previous versions, including a new threading model, custom class creation, and data streaming. Learn how to take advantage of these features with an application that is designed to extract information from Web pages for indexing purposes. This article also discusses basic database access, file I/O, extending classes for objects, and the use of opacity and transparency in forms.

  • Commerce with ASP.NET: Leverage the Authentication and Form Validation Features of ASP.NET to Bolster Your Commerce App
    Jason Lefebvre and Robert Lair - August 2002
    If you're planning to build an e-commerce site, you'll be pleased to see that ASP.NET makes it easier than ever. Existing controls can be used and extended to add a great deal more functionality than you might expect. In this article, forms-based authentication is used to verify the identity of users and make certain areas of the site, such as the check-out page, inaccessible to unauthorized users. The power and flexibility of validation controls are demonstrated using the CustomValidator control to connect to a Web Service that verifies addresses. A shopping cart is then implemented in ASP.NET using the DataGrid, and finally, credit card authorization and billing are performed.

  • .NET Reflection: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection
    Atif Aziz - August 2002
    One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.

  • Cutting Edge: Designing Reader Classes for .NET Documents
    Dino Esposito - August 2002


  • Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT
    Roy Margolis - July 2002
    One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

  • Advanced Basics: Viewing the Values of a DataSet in a Debug Window
    Ken Spencer - July 2002


  • Cutting Edge: Building a Data Navigator Control, Part III
    Dino Esposito - June 2002


  • SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000
    Christian Thilmany - May 2002
    XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

  • Crystal Reports: Add Professional Quality Reports to Your Application with Visual Studio .NET
    Andrew Brust - May 2002
    Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.

  • The XML Files: XSLT Processing, Processing Instructions in XML, Parameterizing Statements in XML, and More
    Aaron Skonnard - May 2002


  • Cutting Edge: ASP.NET Data Shaping
    Dino Esposito - March 2002


  • Cutting Edge: ASP.NET Data Shaping
    Dino Esposito - March 2002


  • The XML Files: Publishing and Discovering Web Services with DISCO and UDDI
    Aaron Skonnard - February 2002


  • Data Points: Establishing Relationships Between Rowsets with ADO.NET
    John Papa - February 2002


  • Cutting Edge: Data Binding Between Controls in Windows Forms
    Dino Esposito - February 2002


  • Data Points: Using the ADO.NET DataSet for Multitiered Apps
    John Papa - January 2002


  • Advanced Basics: Namespaces, Cursors, ADO.NET, Web Services, Inheritance, and More
    Ken Spencer - January 2002


  • ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework
    Bob Beauchemin - December 2001
    The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.

  • Cutting Edge: Using Session and Application Objects in ASP.NET, Part 2
    Dino Esposito - December 2001


  • Data Points: Abstracting ADO.NET
    John Papa - November 2001


  • ASP.NET: Collect Customer Order Information on an Internet Site Using XML and Web Forms
    Jeff Jorczak - September 2001
    XML has quickly become the new data structure standard for everything from database access to cross-platform computing. XML is typically considered to be a vehicle for data exchange, dynamic data presentation, and data storage. However, the potential of XML far surpasses those limited applications. This article examines one new use: the gathering of data across a number of forms in an ASP.NET Beta 1 framework application. The sample program is a Web app used for ordering pizza. It uses ASP and C# to gather order information and then stores it in XML. To build the application, several concepts are explained, including data collection, order persistence using cookies, grouping input forms, and formatting the data for display.

  • Data Points: ADO to XML: Building a Data Access Tier with the DataManager Component
    John Papa - August 2001


  • Cutting Edge: Custom Web Data Reporting
    Dino Esposito - July 2001


  • SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices
    Paul Yao and David Durant - June 2001
    Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

  • Data Points: Revisiting the Ad-Hoc Data Display Web Application
    John Papa - June 2001


  • Cutting Edge: Server-side ASP.NET Data Binding
    Dino Esposito - March 2001


  • Serving the Web: Stored Procedure Wizard in Visual Basic Boosts Productivity
    Ken Spencer - January 2001


  • Introducing ADO+: Data Access Services for the Microsoft .NET Framework
    Omri Gazitt - November 2000
    ADO+ is the new set of data access services for the .NET Framework. ADO+ is a natural evolution of ADO, built around n-tier development and architected with XML at its core. This article presents the design motivations behind ADO+, as well as a brief introduction to the various classes in the two layers that comprise the ADO+ framework-the connected Managed Providers and the disconnected DataSet. A drilldown into DataSets that covers populating data stores, relationships, filtering, searching and data views is provided. Finally, a discussion of the integration of ADO+ with the .NET XML Framework is presented.

  • Beyond ASP: XML and XSL-based Solutions Simplify Your Data Presentation Layer
    Scott Howlett and Jeff Dunmall - November 2000
    The combination of XML and XSL can provide a powerful alternative to ASP development. This article presents arguments for building even small-scale Internet applications on the XML model. An example written with traditional ASP programming is compared to the same example written with XML and XSL in order to show the benefits of this approach. The example is followed by nine good reasons to make the switch. These reasons include separation of presentation and data, reusability, extensibility, division of labor, enhanced testing, and legacy integration. The XML/XSL solutions described hold the promise of greater simplicity, flexibility, and durability than ASP solutions built the traditional way.

  • Taming the Stateless Beast: Managing Session State Across Servers on a Web Farm
    John Papa - October 2000
    Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.

  • The Programmable Web: The Web Services Platform Provides Building Blocks for Seamless App Integration
    Mary Kirtland - September 2000
    Web Services are building blocks for constructing distributed Web-based applications in a platform, object model, and multilanguage manner. Web Services are based on open Internet standards, such as HTTP and XML, and form the basis of Microsoft's vision of the programmable Web. This article defines Web Services and the key enabling technologies that ensure services can be aggregated into applications. It then describes Microsoft's new Microsoft .NET Framework and its support for creating and consuming Web Services.

  • Cutting Edge: SQL Server 7.0 and OLE DB Heterogeneous Queries
    Dino Esposito - August 2000


  • Serving the Web: XML Data Manipulation with ADO 2.5
    Ken Spencer - August 2000


  • Microsoft Office 2000: Create Dynamic Digital Dashboards Using Office, OLAP, and DHTML
    Todd Abel - July 2000
    Digital Dashboards provide users with one single interface through which they can view information from a variety of sources that have been chosen specifically for that user. In addition, dashboards allow a user to view the information offline, adding portability to the mix. This article discusses options for building a dashboard based on the Microsoft Outlook folder home pages feature. It covers culling the data from disparate sources and storing it using the MSDE. It then discusses the creation of nugget definitions for structuring the data, and providing a synchronization mechanism to update to the data stores.

  • SQL/MTS: Automating the Creation of COM+ Components for a Database Schema
    Aleksandr Mikunov - July 2000
    Using Microsoft Windows DNA architecture as a guideline, it's possible to create scalable multitier database applications with COM+ and Microsoft Transaction Services. In fact, you can use existing table definitions to automatically build the MTS/COM+ business logic layer and data access components for your application. This article will walk you through the development of database transactions by mapping the transactions to automatically generated MTS/COM+ components. This technique can greatly simplify the task of creating components for a large project.

  • Building a Custom Data Grid: Performing Ad Hoc Web Reporting with a VBScript 5.0 Class Object
    Randall Kindig - July 2000
    A flexible, customizable grid for displaying data is a useful tool for ASP developers. It allows Web visitors to customize their view of your data. This article takes the data grid presented in "Ad Hoc Web Reporting with ADO 2.0" by John Papa and Charles Caison (MIND, December 1998) and adds handy features such as a finds feature that supports multiple finds and a mode for adding and editing records. This version also improves response time by allowing asynchronous record download and it componentizes the code so it can be used as a standalone VBScript class object that can be reused in other pages.

  • Cutting Edge: Writing Custom OLE DB Providers Using ATL
    Dino Esposito - July 2000


  • House of COM: Using ADO to Create XML-based Recordsets
    Don Box - July 2000


  • Info on the Go: Wireless Internet Database Connectivity with ASP, XML, and SQL Server
    Srdjan Vujosevic and Robert Laberge - June 2000
    Many handheld wireless devices such as cellular phones and PDAs already have the ability to access Web sites. So how do you build Web applications that tap this wireless audience? Although there are a number of limitations to wireless devices-such as screen size, navigation, and connection speed-you can use familiar Web development technologies to make your existing Web applications available to mobile users. This article outlines the services and equipment currently available to support wireless Web access. A sample wireless-accessible Web site that dynamically draws data from a SQL Server database back end in real time is created using tools such as ASP and XML.

  • Advanced Basics: Transactional Programming Design and Optimization
    Jason Masterman - June 2000


  • B2B Frontiers in E-Commerce: Implement Affiliate Programs to Create New Partnerships and Generate Business
    Ted Coombs - May 2000
    Like the Internet itself, e-commerce is evolving. Today's e-commerce companies are allowing their customers to plug into existing catalogs and ordering systems, creating new synergistic relationships. Some companies are even adding real-time chat with customer service personnel. This article gives you an overview of some of the new e-commerce concepts and implementations that are helping forge those new relationships with customers, vendors, and shipping companies. The importance of these relationships, as well as the specific technologies used to encourage communication and collaboration are discussed and illustrated with representative code samples.

  • Serving the Web: Building and Testing ADO Components with Visual Basic
    Ken Spencer - May 2000


  • Build an Easy Maintenance Intranet Site: Using Office Docs, File System Object, and OLE Structured Storage
    Josef Finsel - March 2000
    If you've ever needed to build an easy-to-maintain intranet site, here's a solution based on Microsoft Office documents. Many sites require constant updating of their HTML, but the use of Word documents can simplify the process. This article details the construction of a human resources site that exploits the File System Object (FSO), OLE Structured Storage, and ActiveX capabilities of Word documents. This allows the HR staff to copy their revised or newly created Word files to the site, dynamically generate a list of links to their files, and free IS from the constant recoding of HR updates into new HTML pages.