Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag ADO Rss

   Items 1 to 20 of 50    Older >>
 

Creating Functions for Stored Procedures

With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.  Read more...
By Alex Grinberg 2008/10/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,257 reads

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

This article shows how to retrieve both remote and local XML data and display it in a data Web control.  Read more...
By Additional Articles 2007/09/10 | Source: 4 Guys From Rolla | Category: basics
Rating:  Rate this |   Briefcase | 3,339 reads

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

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.  Read more...
By Additional Articles 2007/09/03 | Source: 4 Guys From Rolla | Category: ado
Rating:  Rate this |   Briefcase | 3,062 reads

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

This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.  Read more...
By Additional Articles 2007/08/27 | Source: 4 Guys From Rolla | Category: ado
Rating:  Rate this |   Briefcase | 3,166 reads

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

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.  Read more...
By Additional Articles 2007/08/20 | Source: 4 Guys From Rolla | Category: ado
Rating:  Rate this |   Briefcase | 1,765 reads

ADO.NET Entity Framework Overview

ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.  Read more...
By Additional Articles 2007/07/25 | Source: Microsoft MSDN | Category: ado
Rating:  Rate this |   Briefcase | 2,193 reads

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,459 reads

Connecting With Perl Using Win32 : ODBC

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.   Read more...
By Brian Kelley 2006/07/28 (first published: 2002/12/03) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 39,572 reads

Executing SQL Stored Procedures from inside a Web Application

This article, the last in the Stored Procedure series, will focus on RETURN parameters.   Read more...
By Additional Articles 2006/06/16 | Source: Database Journal | Category: ado
Rating:  Rate this |   Briefcase | 3,876 reads

Introduction to the ADO Connection Object

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?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,958 reads

Copying DTS Packages To a Different Server

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!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,494 reads

ADO.NET Data Sets

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.   Read more...
By Additional Articles 2005/08/05 | Source: Red-Gate | Category: ado
Rating:  Rate this |   Briefcase | 3,209 reads

Reducing Round Trips

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.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,864 reads

Should you use a DataReader or DataSet?

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.   Read more...
By Additional Articles 2005/07/05 | Source: Red-Gate | Category: ado
Rating:  Rate this |   Briefcase | 3,931 reads

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

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.   Read more...
By Additional Articles 2005/03/30 | Source: MSDN Communities | Category: ado
Rating:  Rate this |   Briefcase | 2,222 reads

Query Notifications in ADO.NET 2.0

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.   Read more...
By Additional Articles 2004/10/18 | Source: MSDN Communities | Category: .net
Rating:  Rate this |   Briefcase | 2,293 reads

ADO.NET - A Data Access Layer

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.   Read more...
By Patryk Nowakowski 2004/08/03 | Source: SQLServerCentral.com | Category: ado
Rating: |  Discuss |   Briefcase | 12,963 reads

Changing Databases Using XML

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.   Read more...
By Dinesh Asanka 2004/02/16 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 5,546 reads

Delphi Code Generator

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)   Read more...
By Additional Articles 2004/02/09 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,167 reads

Introduction to ADO Part 2 - Recordsets

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!   Read more...
By Andy Warren 2003/11/28 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,199 reads
   Items 1 to 20 of 50    Older >>
 
Tags
programming (44)    
visual basic 6 (14)    
miscellaneous (13)    
sql server 7 (12)    
t-sql (12)    
performance tuning (7)    
stored procedures (7)    
.net (5)    
administration (5)    
asp (5)    
basics (4)    
configuring (4)    
xml (3)    
database design (2)    
replication (2)    
sql-dmo (2)    
advanced querying (1)    
analysis services (ssas) (1)    
backup / restore (1)    
best and worst practices (1)    
data warehousing (1)    
dts (1)    
other (1)    
rants (1)    
security (1)    
sql puzzles (1)    
sql server 6.5 (1)    
updategrams (1)    
worst practices (1)