MSDN Magazine: Data Access
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
Marco Bellinaso - October 2003
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.