SQLServerCentral.com Content tagged Programming, ADO

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

Mon, 10 Sep 2007 06:00:00 UT

This article shows how to retrieve both remote and local XML data and display it in a data Web control.

Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data wi

Mon, 03 Sep 2007 06:00:00 UT

Learn how to retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page, session variables, and so on.

Accessing and Updating Data in ASP.NET 2.0: Accessing Database Data

Mon, 27 Aug 2007 06:00:00 UT

This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.

Accessing and Updating Data in ASP.NET 2.0: Data Source Control Basics

Mon, 20 Aug 2007 06:00:00 UT

This article explores the concepts and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.

ADO.NET Entity Framework Overview

Wed, 25 Jul 2007 06:00:00 UT

ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.

Introduction to ADO - The Command Object

Fri, 09 Feb 2007 07:00:00 UT

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.

Connecting With Perl Using Win32 : ODBC

Fri, 28 Jul 2006 06:00:00 UT

Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.

Executing SQL Stored Procedures from inside a Web Application

Fri, 16 Jun 2006 06:00:00 UT

This article, the last in the Stored Procedure series, will focus on RETURN parameters.

Introduction to the ADO Connection Object

Fri, 26 May 2006 06:00:00 UT

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?

Copying DTS Packages To a Different Server

Fri, 05 May 2006 06:00:00 UT

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!

ADO.NET Data Sets

Fri, 05 Aug 2005 06:00:00 UT

This article looks at how partial classes can be used to implement business logic into datasets so that they are more business aware and intelligent. The dataset is an integral part of Microsoft’s new data access model ADO.NET. It introduces a simple offline method for retrieving and updating data. Before using the dataset, you should have an understanding of the Microsoft .NET platform and a basic understanding of the dataset model.

Reducing Round Trips

Fri, 15 Jul 2005 06:00:00 UT

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.

Should you use a DataReader or DataSet?

Tue, 05 Jul 2005 06:00:00 UT

In the beginning, there was the recordset, a central feature of classic ADO. Like a Swiss army knife, it wasn’t the perfect tool for every job, but given the correct configuration, it could do whatever you needed it to do. The recordset wasn’t always pretty to watch, however, and it came into prominence at a time when client/server applications for which it was optimized were being replaced by web applications. Its dark side included an amazing level of complexity and the number of special cases when it was used with particular providers.

Teach Old Data New Tricks with the Fully Loaded Advances in ADO.NET 2.

Wed, 30 Mar 2005 06:00:00 UT

The Microsoft® .NET Framework 2.0 delivers an updated ADO.NET that will streamline your data access development efforts. The ADO.NET team has worked with both the System.Xml team and the SQL Server™ team to provide a consistently rich developer experience, crossing technology boundaries from ADO.NET to XML and back. This will all be apparent as you dig into ADO.NET 2.0. There are improvements on so many fronts that you will certainly be pleased. Rather than attempt to list every new and updated feature of ADO.NET 2.0, I will discuss in detail some of the more interesting improvements and focus on performance and flexibility.

Query Notifications in ADO.NET 2.0

Mon, 18 Oct 2004 06:00:00 UT

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.

ADO.NET - A Data Access Layer

Tue, 03 Aug 2004 06:00:00 UT

Developing applications for SQL Server usually results in a variety of access methods that the programmers use. A data access layer class, given to the developers, is usually seen as the best practice, but one that isn't usually implemented. In fact, in most software I've built, each developer uses his own method, or may cut and paste from another, but rarely is there a central access class. New Author Patryk Nowakowski brings us his solution using ADO.NET.

Changing Databases Using XML

Mon, 16 Feb 2004 07:00:00 UT

Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app.

Delphi Code Generator

Mon, 09 Feb 2004 07:00:00 UT

You point this application at a database and it generates a code unti that allows you to easily execute stored procedures and functions from Delphi. (Not Reviewed)

Introduction to ADO Part 2 - Recordsets

Fri, 28 Nov 2003 07:00:00 UT

Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Fri, 01 Aug 2003 06:00:00 UT

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Murach's VB.NET Database Programming with ADO.NET

Thu, 05 Jun 2003 06:00:00 UT

If you're a VB.NET programmer who wants to learn database programming with ADO.NET, here's a new book that presents all the skills you need in a logical progression from the simple to the complex. Along the way, you'll learn how to use the classes, properties, methods, events, and techniques that have made this subject so hard to master. And when you're done, you'll have a reference that you'll use on the job every day. (Publisher Provided Description, not reviewed)

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Default Values and Named Parameters for Stored Procs

Wed, 08 Jan 2003 07:00:00 UT

Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.

Connecting With Perl Using Win32 : ODBC

Fri, 28 Jul 2006 06:00:00 UT

Review of Real-World SQL-DMO

Tue, 19 Nov 2002 07:00:00 UT

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!

Review of Micrsoft ADO.Net Step by Step

Fri, 23 Aug 2002 06:00:00 UT

Andy takes a look at another entry level book, this one on ADO.Net.

Generating HTML Tables

Mon, 05 Aug 2002 06:00:00 UT

In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.

Copying DTS Packages To a Different Server

Fri, 05 May 2006 06:00:00 UT

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Reducing Round Trips - Part 3

Mon, 11 Mar 2002 06:00:00 UT

This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.

Performance Comparison: Data Access Techniques

Fri, 01 Mar 2002 07:00:00 UT

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Reducing Round Trips - Part 2

Wed, 06 Feb 2002 07:00:00 UT

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!