| Related Articles |
|
|
| Jan 24, 1997 - Simple ASP Chat | | This 15 Seconds' issue contains source code and step by step instructions for creating a chat session using Active Server pages, HTML and a standard web browser. Also demonstrated is writing and reading of a file with an Active Server page. [Read This Article] [Top] |
|
| Apr 6, 1997 - Creating a List Server with ASP | | This issue describes how to make a list server using Active Server, SQL Server, and Stephen Genusa's ASPMail Component. Included are source and instructions for adding the user to the list from a Active Server page, removing the user from the list via a Active Server page, and sending mail to the whole list. [Read This Article] [Top] |
|
| Apr 22, 1997 - Active Server Components with VS 5.0 | | A rewrite of part one of a four-part series on Active Server objects. A simple example of creating a Active Server Component in Visual Studio 5.0 using the Active Template Library 2.0. The example component retrieves the user's cookie, if not available issues a new 128-bit cookie. Included in the issue is the source code and step by step instructions. This issue has been rewritten to illustrate the use of Visual Studio 5.0 and ATL 2.0 in writing Active Server Components. [Read This Article] [Top] |
|
| May 31, 1997 - Connection Pooling with ASP | | 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] |
|
| May 31, 1997 - Connection Pooling with ASP | | 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] |
|
| Jul 31, 1997 - Creating a Category Site with ASP | | In this issue 15 Seconds implements a catalog site that is build with Active Server pages and SQL Server. Along with the implementation there is source code and a discussion of the advantages and disadvantages of creating a catalog site that gets its content from a database. Included are pages for displaying products, creating a menu page, category page, and running a search across a database. [Read This Article] [Top] |
|
|
|
|
| Nov 11, 1999 - Database-Driven WWW Help System | | 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] |
|
| Jan 31, 2000 - ASP-Oracle Connectivity Using OO4O | | 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] |
|
| Mar 9, 2000 - SQL Solutions | | 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] |
|
| Mar 23, 2000 - Using an ADO Standalone/Custom Recordset in VBScript | | 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] |
|
| Jun 8, 2000 - Get Your Data Faster with a Data Cache | | 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] |
|
| Jun 21, 2000 - Keeping Track of Who's In Charge Today | | 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. [Read This Article] [Top] |
|
|
|
|
|
|
| Nov 2, 2000 - Retrieving Dynamic XML from SQL Server 7.0 and 2000 | | 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] |
|
|
|
|
|
| Mar 29, 2001 - Overcome Data Shaping Limitations | | 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] |
|
|
|
|
|
|
|
| Jun 18, 2001 - ASP AND SQL-DMO - Part 2 | | 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] |
|
|
|
| Aug 22, 2001 - Advanced Form Presentation and Printing w/ PDF, FDF, ASP, and DHTML - Part 1 | | 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] |
|
|
|
| Sep 14, 2001 - Charting the Internet | | 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] |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sep 11, 2001 - Randomizing a Recordset | | 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] |
|
|
|
|
|
| Jun 23, 2003 - A Primer on Using DB2 with .NET | | 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] |
|
|
|
| Sep 9, 2003 - DTS and C# | | 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] |
|
|
| Oct 13, 2003 - A Simpler Way of Getting .NET Objects out of ADO.NET | | 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] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Feb 10, 2005 - A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1 | | 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] |
|
|
 | Sep 15, 2005 - Building an Image Keyword System | | 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] |
|