15 Seconds is looking for technical professionals working in the Active Server field to write articles. If you are interested, take a look at our writer's guide and submit your ideas.
Data Access Section Active Data Object as they pertain to Active Server Pages.
Proposion N2N connects Microsoft .NET applications to Lotus Notes and Lotus Domino databases. This ADO.NET managed data provider allows you to perform blindingly fast queries and updates of Notes data from ASP.NET pages, .NET web services, Windows, or Mobile applications. An innovative SQL-like query language leverages the unique features of Notes and makes collaborative software accessible to relational database programmers.
Unlike text-based file formats image files aren't made up of words, which makes searching for an image file by keyword difficult. Instead of being able to simply open the file to see what it contains, we're stuck looking at the text around it and other metadata to determine the image's meaning. In this article, Ziran Sun shows you how to build a simple database-based image keyword system that allows you to associate keywords with images and use these keywords to make finding images easier. [Read This Article][Top]
In the second part of of his article on using MySQL with ASP.NET, Ziran Sun covers how to add a new MySQL user to the database server, assign the user the appropriate permissions, connect to the database, and build a simple ASP.NET page to perform a query. [Read This Article][Top]
Back in the days of classic ASP, if you were building a database-driven
web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server
(or some other enterprise-ready database) or invest a lot of time finding a way to deal with the
performance and scalability limitations of Microsoft Access. Luckily these days there's
another viable alternative: MySQL. [Read This Article][Top]
Moving or copying a SQL Server database from one machine to another requires a lot of preparation in order to ensure a smooth transfer. In this article, Dina Fleet Berry examines the different methods and highlights the different issues associated with each of them. [Read This Article][Top]
There are many times when using SQL Server 2000 Query Analyzer to debug SQL statements is a better choice than debugging in Visual Studio .NET. In this article, Dina Fleet Berry explains why and walks you through the debugging process step-by step. [Read This Article][Top]
As a follow up to his article on retrieving objects from SQL Server using SQLXML and serialization, Gianluca Nuzzo discusses saving objects back to SQL Server using a schema definition file and updategrams. [Read This Article][Top]
One area that stands out when comparing ADO.NET 1.x to ADO.NET 2.0 is transaction processing. Bill Ryan shows just how easy transaction processing has become with the TransactionScope object in ADO.NET 2.0. [Read This Article][Top]
Developers often use brute force coding to marshal data between the GUI and application objects. In this article, Luther Stanton explains how to use .NET's out-of-the box data-binding functionality to make this job much easier. [Read This Article][Top]
Learn how to create a console application to queue a message in Microsoft Message Queuing (MSMQ) and then use an extended stored procedure to call the console application from a SQL Server trigger. [Read This Article][Top]
Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. This article shows how to monitor the connection pool, diagnose a potential problem, and apply the appropriate fix. [Read This Article][Top]
This article will describe how to design a data access layer for a set of entities. You'll learn how to write an XSD schema and design two simple helper classes -- one for reading an XML stream from SQL Server using SQLXML and another for deserializing the XML stream. [Read This Article][Top]
Alex Homer discusses the simplification of, and extensions to, the ASP.NET 1.x data binding syntax, the new two-way data binding syntax for updating data sources, and the new syntax for binding to XML data in ASP.NET 2.0. [Read This Article][Top]
Rocky Lhotka discusses .NET 2.0's new smart DataTable technology and examines Whidbey's RAD support for object data binding in .NET 2.0 Windows Forms. [Read This Article][Top]
This article examines some of the new and exciting caching features in ASP.NET 2.0 and shows how to implement them in Web applications. [Read This Article][Top]
Thiru Thangarathinam explains how to implement strongly typed collection objects and discusses why they may be the best approach for returning data from the middle tier to an ASP.NET user interface. [Read This Article][Top]
Object-relational persistence can provide great benefits to data-based applications in .NET. Scott Bellware explains O/R persistence and examines what Microsoft is doing in .NET 2.0 to facilitate this sparsely used and often misunderstood practice. [Read This Article][Top]
Thom Robbins explains how DataSet object features can be combined with XML to create a new type of object called the typed DataSet, which simplifies the task of data navigation. [Read This Article][Top]
Frustrated with having to maintain separate Connection objects, DataAdapters, and DataSets in each form? Nathan Zobrist shows how to create and use an application-wide data component. [Read This Article][Top]
Part one showed how to transform XML data into HTML by using an XSL stylesheet from within a .NET application. This part explains how to make use of XSLT Extension objects and invoke a C# class method from an XSL stylesheet. [Read This Article][Top]
Learn how to transform XML data into HTML by using an XSL stylesheet from within a .NET application, and then implement a paging solution by declaring and supplying paging parameters to the stylesheet. [Read This Article][Top]
The Matisse post object-relational SQL database is equipped with an ADO.NET extension that returns objects instead of rows and thus eliminates the need for an O-R mapping layer. Benjamin Hautefeuille introduces Matisse, explains how to use its powerful features, and demonstrates how it can eliminate around 25% of an application's code and maintain performance levels as additional rows are added. [Read This Article][Top]
Bob McLeod shows how to create an object that accepts a dataset with
multiple tables and turns them into an Excel workbook with multiple sheets. [Read This Article][Top]
Data Transformation Services (DTS) is a built-in component of SQL Server that provides programmers and database administrators with a way to move
data from any source to any destination. Thiru Thangarathinam shows how to invoke DTS packages from a .NET application and explains how the unmanaged DTS SQL Server COM component is used in a .NET application. [Read This Article][Top]
Populating the TreeView Web Control from a database allows menu and input trees to change on the fly. Don Schlichting provides an introduction to the TreeView and then provides detailed steps for populating the tree from a database using ADO.NET. [Read This Article][Top]
Recently there has been a sudden increase in new development projects for migrating existing C/C++ applications written on the UNIX/Windows platform to .NET. This article demonstrates how to manipulate and expose raw data received from mainframes into well-defined managed C++ interfaces using the facilities and features provided by the .NET Framework and managed C++. [Read This Article][Top]
Several companies are tackling the issue of leveraging their investment in DB2 and embracing .NET for some new application development. This is a practical guide to getting started using DB2 from a .NET application developer's perspective. This article will discuss the basics of how to access DB2, what techniques work best, what functionality you can expect, and how to avoid problems. [Read This Article][Top]
This short article provides source code for a classic ASP online database functions testing application and shows how to configure and use the tool for either SQL Server or Oracle. [Read This Article][Top]
Wayne Plourde focuses on different approaches to concurrency locking and discusses how to handle the situations when they occur. [Read This Article][Top]
Traditional relational database management systems (RDBMS) don’t lend themselves very well to object-oriented programming. Matt Culbreth of Intellinet Corporation introduces object databases and explains why they can be a valuable alternative to RDBMSs. [Read This Article][Top]
This is the second part of our series on creating a Data Access Layer (DAL) in .NET. In this article, Wayne Plourde shows how to set up the code necessary for retrieving and manipulating data. [Read This Article][Top]
Wayne Plourde begins his two-part series on creating a robust data access layer in .NET. Before writing any code, it is important to establish goals and setup and secure a database. Part one examines all the ingredients that exist in a professional data access component. [Read This Article][Top]
Andrew Novick introduces the three types of user-defined functions (UDF) in SQL Server 2000 and shows why inline UDFs are ideal for efficient data retrieval. [Read This Article][Top]
Marcus Tucker benchmarks various methods of querying an Access database through ASP. He runs a series of tests, using each ADO object, that pit hardcoded dynamic queries against the less familiar Stored Queries. The results may surprise you! [Read This Article][Top]
Developers who don't want to spend a lot of money on SQL Server and who want a database that's more robust than Access may find MySQL to be a pleasant alternative. This introductory article covers the bare essentials for getting MySQL installed and running in the Win32 environment. [Read This Article][Top]
Mixing object-oriented development and relational databases can poison developer productivity and application quality. Sebastian Ware and Mats Helander concoct a cure using object-relational mapping. [Read This Article][Top]
Creating code to access new data stores can often be a heroic task. Adam Sills shows how to create a simple abstract factory pattern for pluggable data access. [Read This Article][Top]
The first article in this two-part series provides a basic understanding of the theoretical principles of database design and describes some key elements and rules of creating relational databases. [Read This Article][Top]
A few members of the 15 Seconds discussion list talk about the proper way to use methods in order to prevent ADO object errors. [Read This Article][Top]
In the first of this four-part series, David Penton describes a quick and efficient way to delete duplicate records from a table. [Read This Article][Top]
Including charts on a Web site is now commonplace, but often these are static and therefore quickly outdated. In this article by Mark Mathieson, we first explore how to create charts generated on the fly from a database, using IntrChart. Secondly, we delve into IntrChart's hot-spot capabilities to dynamically drill down to other pages or charts. [Read This Article][Top]
Ed Myers' article shows several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. A simple tool is provided for verifying that the results are uniformly random. A technique for bubbling records with certain attributes to the top of an otherwise randomized list is also shown. [Read This Article][Top]
In the third and final installment of Advanced Form Presentation and Printing, Eric Coffman describes how to separate form presentation in a browser from the way the form prints out without processing the form through a CGI script or other means; everything is handled client-side. Learn how to create pleasing-looking forms without the need for Adobe Acrobat or Adobe Acrobat Reader. [Read This Article][Top]
In part two of advanced form presentation and printing, Eric Coffman uses the FDF Toolkit ActiveX version to show the versatility of the FDFApp object and demonstrates how to handle a Forms Data Format (FDF) file in a real-world situation. [Read This Article][Top]
This three-part article by Eric Coffman details the dynamic creation of Adobe Acrobat 5.0 PDF forms with ASP and describes the handling of all the most common form elements. You will be able to connect Adobe Acrobat 5.0 PDF forms to a database and retain, even extend Adobe's acclaimed portability and printability. This is like eating your cake and having TWO left! And if that's not enough, part three describes a method of simulating Adobe's features with CSS level 2's @media features combined with DHTML. [Read This Article][Top]
With the release of the .NET Framework SDK Beta 2, Microsoft has made some fundamental changes. One area that has been changed is ADO.NET. This article illustrates these changes so you can move your ADO code from Beta 1 to Beta 2 as simply as possible. [Read This Article][Top]
Repetitive tasks are nothing new to a developer. Writing ADO interface code is one of these tasks. In this article David R. K. DeLoveh shows us how to write code to generate code for calling stored procedures in SQL Server 7. [Read This Article][Top]
AddCriteria is a short function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. [Read This Article][Top]
S.S. Ahmed's article will demonstrate the usage of the SQL-DMO library to administer the SQL Server remotely. It shows how to create a component capable of creating SQL tasks remotely. Once the task is executed successfully, the task would be deleted automatically. [Read This Article][Top]
Members of the 15Seconds discussion list debate the best methods for connecting to a database while philosophizing about code optimization. [Read This Article][Top]
In this article, Matt Duckhouse describes how to connect a Macromedia Flash movie to an Access database using an ASP page as the data-transfer mechanism. [Read This Article][Top]
When should it be used and when should it not? Members of the 15 Seconds discussion list provide some insight into using Microsoft Access for Web applications. When should it be used and when should it not? [Read This Article][Top]
This article presents sample source code for a user query parser that allows users to submit full-text search queries from ASP to SQL Server 2000. [Read This Article][Top]
Many hosted e-commerce Web sites today still rely on their ISPs for shopping cart functionality - at additional monthly fees. This article by Manny Agrinya shows how you can painlessly design and program a multifunctional shopping cart application using standard hosting plan features like SQL Server, ASP, and ODBC. [Read This Article][Top]
At some point in their career, most developers have had to create and store a hierarchy of information. Craig Huber will show you a brief overview of ADO Data Shaping and its associated limitations. Then he will explore a solution that overcomes the limitations and supports infinite levels in a hierarchy. [Read This Article][Top]
Read what advice members of the 15Seconds Discussion list had to offer on importing files into a database where field 1 contains the filename and field 2 contains the contents. [Read This Article][Top]
IE provides the perfect tool for accessing legacy data stored in various formats over the Web. Ian Vink shows us how to harness the power of the Tabular Data Control feature. [Read This Article][Top]
SQL Server is packed with features for retrieving XML documents. Steven
Woods offers a demonstration of extending a SQL Query via the RAW, AUTO,
and EXPLICIT modes to illustrate the functionality available. The article
then discusses the concept of templates, which allow the creation of
dynamic parameter-based XML documents, and how templates can be executed
via Visual Basic. [Read This Article][Top]
Creating an ASP component to manage SQL Server remotely is fairly easy. It
only requires a basic knowledge of ASP, VB, and SQL Server. S.S. Ahmed's
article demonstrates how to create a component that harnesses the power of
SQL-DMO so you can manage SQL tasks remotely. [Read This Article][Top]
If you're an ASPiring developer looking for a solid foundation in dynamic Web site creation, then look no further. This article for ASP beginners details how to
connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and
Open Database Connectivity (ODBC). [Read This Article][Top]
Thought displaying file ACLs on a Web
page in a browser was impossible without Active Directory installed? Think again.
Through a patchwork of technologies, Larry Schwartz proves otherwise. [Read This Article][Top]
Select boxes must often communicate with one another (i.e., a Child select object's option values depend on the value selected in the Parent object). Jason Butler details how to create a hierarchy of select objects using ASP, SQL, ADO, and JavaScript. [Read This Article][Top]
User-defined functions are a new feature in SQL Server 2000. Karen Gayda
shows how UDFs can be used to enhance queries and provide functionality
that was previously unavailable. [Read This Article][Top]
With a low-level database, offering only basic data storing functionality,
SQL code often needs to be embedded in Active Server Pages. With a more
sophisticated database, stored procedures can be far more effective. Here's
a case study, including code, showing how a database was converted to
stored procedures. [Read This Article][Top]
Automated content management is a must for many web sites. It's difficult to provide fresh new content without a standard automated system. This article discusses how to generate a general submission system, as well as how to manage the work flow, all with examples! [Read This Article][Top]
Many offices, particularly in military and government organizations, are required to have someone in charge during office hours. If the official manager is absent, that person delegates responsibility to someone else as acting, but who?
A Key Personnel Today table shows who is acting in every official position and how to reach them.
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times. In my tests, I've seen as much as a 5000% increase in performance. [Read This Article][Top]
Developer Stephan Onisick shows us how to create a standalone/custom recordset and use its organizational ability to perform logical tasks with data without connecting to a database. This article uses a small application written using VBScript, ADO 2.1, and an Excel spreadsheet to record and print computer expenses for tax preparations. The standalone recordset is saved in XML format, and the file can be updated with new data simply by reopening as a recordset and using normal recordset methods. [Read This Article][Top]
Cindy Cruciger claims there is a better way to write a functional Active Server Page that allows interaction between a database file and the Web, without getting caught in an SQL nightmare. She offers a snippet of SQL code and adds some logical layers, error checking and formatting. [Read This Article][Top]
Boaz Sigelman shows how to seamlessly convert between HTML form entry and database storage. The article contains example and code that shows how to use the 1touch component. [Read This Article][Top]
Selva Kumar’s article shows how to create practical Oracle database connectivity from ASP using Oracle Objects for OLE (OO4O). OO40, the Oracle middleware, allows native access to Oracle from client applications using the Microsoft Object Linking and Embedding (OLE) standard. Sample code is provided. [Read This Article][Top]
The help system presented in Vujosevic and Laberge's article is self contained and can be updated and altered without impacting the original Web application. Much like an online book, the help icon in the Web application dives into an application system for the help option. Each Web page has its own separate help page with a database that contains one row in a table for every calling Web page. Sample code is provided. [Read This Article][Top]
Bill Jeffries's article on Excel's Web Query tool demonstrates how to update selected spreadsheet cells instantly over an HTTP connection. [Read This Article][Top]
In this article Amos El-Roy demonstrates how to create a file repository using ASP pages. A seamless approach that maximizes accessibility and lowers administrative overhead is illustrated in the article's example, which is available for download. [Read This Article][Top]
Connection pooling might be the easiest way to speed up your dynamic web pages reading from SQL Server. Unfortunately, connection pooling within is turned off by default in Active Server pages. Probably because connection pooling is rarely understood in its entirety. This issue discusses connection pooling with ASP, ISAPI, IDC, and Visual Basic applications. Included is a discussion about ODBC 3.0 and the newest bug fix for ODBC. [Read This Article][Top]
This issue of 15 Seconds contain an example of how to create an ISAPI server extension in MSVC 4.2 with ODBC 3.0 connection pooling. There is also an evaluation of ODBC 3.0, OLEDB, ADO and DAO. [Read This Article][Top]
ActiveNews(NOTE: ASPToday articles require a paid subscription)
This alternative method, using the sysindexes system table, will cut
down the time it takes to return the total row count of very large
tables! [Read The Article]
Microsoft today announced the first beta version of its highly anticipated Visual Studio.NET platform. Combining
Visual Basic, Visual C++, and its new C# programming languages, the Studio helps developers create Web based
services based on the Microsoft .NET platform. [Read The Article]
Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures. [Read The Article]
This article explains how it is possible to connect and query a MS SQL
server database (running under a Windows operating system) from php
installed on a unix box. [Read The Article]
Axcess is a small multi-threaded server whose function is to provide a
middle ware interface to MS access database files (acting as data sources)
and return the results. This allows any client to use or test the database
without the use of a DBMS or without a Web server having to support
servlets (typically for an applet). Axcess can also be adapted to work with
other databases as well. [Read The Article]
MSDN Magazine examines what's new in SQL Server 2000 product features, including Address Windowing Extensions support, new data types, and new built-in functions. [Read The Article]
Many companies today have spent a lot of money and resources scanning images, blueprints, invoices, and so on, into the TIFF format. This format offers many advantages over others that are used on the Web today. Dale Sides creates an application, using ASP and the Windows built-in imaging tools, to make TIFF images accessible, with all their functionlity in tact, over the Internet or Intranet. [Read The Article]
This article, by Scott Sargent demonstrates a technique to maintain state using globally unique identifiers (GUIDs) with a SQL Server
database. Scott discusses the pros and cons of various session management approaches before providing the source code and explanation for the GUID approach. If standard session variables gotcha down, read on. [Read The Article]
Developer Stephan Onisick shows us how to create a standalone/custom recordset and use its organizational ability to perform logical tasks with data without connecting to a database. This article uses a small application written using VBScript, ADO 2.1, and an Excel spreadsheet to record and print computer expenses for tax preparations. The standalone recordset is saved in XML format, and the file can be updated with new data simply by reopening as a recordset and using normal recordset methods. [Read The Article]
Omer Kudat shares his experiences of using ASP-db to set up an online library of resources. With only prior knowledge of HTML, learning ASP-db was a breeze compared to some of the other main-stream programming languages. [Read The Article]
In previous articles on ASPToday we have seen how it is possible to build a simple search engine for an Access database. This article takes the idea one step further and shows how it is possible to search for multiple words across multiple fields and add a score to the search. This allows us to show the user the results of a search sorted by relevancy. David McAlister has focused on the most efficient way to do this using a single query. This article makes use of an Access database and the Microsoft Jet OLE DB provider. [Read The Article]
In Part 1 of this two-part series Vikash and Rohit showed how to use a chart or graph to represent data in web applications by using a server-side ActiveX dll. This article will be totally inclined to those who are interested in the component itself, explaining component development and exploring the power of tools like Excel [Read The Article]
Wireless technology is becoming ever more versatile. In this article Lee Wei Meng takes a look at a practical application created using WML and ASP. This application will illustrate several concepts in WML (Wireless Markup Language) and how WML and ASP can be used together to create a dynamic WAP application. We will develop an online shopping cart for a hypothetical company. The proposed application will allow the company's travelling salesman to check its inventory using his WAP phone and at the same time allowing him to place an order for his client. [Read The Article]
A picture is worth a thousand words. Vikash and Rohit show how to use a chart or graph to represent a data set in web applications. In this first of two parts, you are stepped through the process of using a pre-built component dll which exposes methods and properties of MS Excel to a thin client. Part 2 of the article will be totally inclined to those who are interested in the component itself, explaining component development, COM and exploring the power of tools like Excel. This article not only demonstrates the purpose and power of a particular technology with a few code snippets but also includes a complete real-life example in a step-by-step fashion both from the user and developer point of view. [Read The Article]
A vital component of any enterprise level DBMS is the ability to create dynamic reports that pull from a database. Diana Leech shows you how to extend the capabilities of ASP to create and customize your own reports using Seagate's Crystal Reports. [Read The Article]
Adrian Forbes put together this demo that shows you how to execute a stored procedure that has input parameters, output parameters, a returned recordset and a return value. [Read The Article]
Microsoft English Query is a tool that sits on top of SQL Server, and lets you issue queries against it, using your natural language instead of SQL. In this first article, Dino Esposito gives an overview of the MSEQ, the environment, what you need, how to get it, and ends with a quick demo just to form an idea. [Read The Article]
This article demonstrates how you can run dynamic SQL statements inside of
stored procedures. Oftentimes you'd like to be able to customize a stored procedure so that a
different table could be queried, based upon the passed in parameters. To accomplish this, you need to use
the <CODE>EXEC</CODE> function. [Read The Article]
This article, by Mike Shaffer, provides a free component to obtain a delimited list of System DSNs on a Web server! This component works with both PWS and IIS. If you have any administration-type pages, such as the SQL Query Test Page, this component will save you time and automatically account for any DSN changes you may make in the future! Not only is the component DLL freely available, but the source code is available too! [Read The Article]
This article, by Geno Timlin, demonstrates how to create an easy-to-use web
page to run test SQL queries against a number of DSNs. When creating a
data-driven Web site, often you need to test your SQL queries before placing
them in your production web site. This article shows you how to create a
simple, elegant web page to use to test SQL queries! [Read The Article]
If your stored procedures are a bit troublesome, the code lengthy, error prone and, frankly, you've better things to do, try this code, as explained by Gardiner Jones which creates the ASP code for you. [Read The Article]
Ashish Varan discusses how to develop ASP applications using both MTS 2.0 and Oracle 8.0. He addresses component registration, configuration of the MTS 2.0 server and common networking problems. [Read The Article]
Darshan Singh demonstrates the code that can be used to manage SQL Server(s) through a browser with Distributed Management Objects and ASP. [Read The Article]
