Articles   Dev Forums   Personalize   Favorites   Member Login        Active Users:  879
DevASP - ASP and XML Articles, Samples, Toturials, Sample Chapters and resources for Developers Thursday, September 02, 2010
Home
Articles & Samples
Dev Search
Dev Forum
Add a Listing
Sample Chapters
Directory Feed
Link to US
Contact

Search Directory
Applications
Articles & Samples
Components
Community
Database
Developer Sites
Downloads
Hosting Services
Introduction
Knowledge Base
Sample Chapters
WebCasts
ASP Directory
Applications
Articles & Samples
Components
Developer Sites
Knowledge Base
Sample Chapters
WebCasts
XML Directory
Applications
Articles & Samples
Developer Sites
Error, Bugs & Fixes
Downloads
Introduction
Knowledge Base
Sample Chapters
WebCasts

Build the right apps the right way with powerful development tools.
Visual Studio 2010. Learn more...

Home > Search > Database
Search
DevASP

What's New
What's Hot
Listings for Access Access (36)
Listings for ActiveX Data Object ActiveX Data Object (43)
Listings for Add Records Add Records (30)
Listings for Connections Connections (49)
Listings for Data Management Data Management (46)
Listings for Data Searching Data Searching (24)
Listings for Delete Records Delete Records (23)
More Categories for Display Records Display Records (60)
Listings for Edit Records Edit Records (34)
Listings for Insert Binary  Data Insert Binary Data (3)
Listings for Introduction Introduction (30)
Listings for Oracle & ASP Oracle & ASP (12)
Listings for Records  Counts Records Counts (10)
Listings for Recordset Recordset (54)
Listings for SQL 6.5, 7.0 SQL 6.5, 7.0 (75)
Listings for Stored Procedures Stored Procedures (54)
Listings for Tips & Tricks Tips & Tricks (40)
 


Using OpenSearch to Create a Multi-Search Form       
Total Hits: 88  |  Today: 1 Author: John Peterson       Rating:  
Read Reviews | Write Review |              Your Rating: 

For the past 10 years or so, instead of simply using a search engine as my browser's start page, I've been using my own self-designed page. The page may not look like much, but what it lacks in looks, it more then makes up for in functionality. It has links to the sites and admin pages that I tend to access frequently, search boxes to send queries to the sites I often search, stock quotes for a few different stock symbols, the latest headlines from some RSS feeds, a link to the company phone lis...

Designing N-Tiered Data Access Layer Using Datasets - Part 4       
Total Hits: 100  |  Today: 0 Author: David Catherman       Rating:  
Read Reviews | Write Review |              Your Rating: 

Part of the business logic encapsulated in the Typed DataSet is the ability to add specialized queries to the table adapters to retrieve the data with different filters. By manipulating the XML schema that defines the dataset and adding the correct XML metadata, Visual Studio will generate the added queries for us. In this article, filtering queries will be automatically added to each table adapter for each field that is indexed on the table in the database....

Designing N-Tiered Data Access Layer Using Datasets - Part 4       
Total Hits: 100  |  Today: 0 Author: David Catherman       Rating:  
Read Reviews | Write Review |              Your Rating: 

Part of the business logic encapsulated in the Typed DataSet is the ability to add specialized queries to the table adapters to retrieve the data with different filters. By manipulating the XML schema that defines the dataset and adding the correct XML metadata, Visual Studio will generate the added queries for us. In this article, filtering queries will be automatically added to each table adapter for each field that is indexed on the table in the database....

SQL Server 2005 XQuery and XML-DML - Part 3       
Total Hits: 53  |  Today: 0 Author: Alex Homer       Rating:  
Read Reviews | Write Review |              Your Rating: 

This is the third and final article in a series of three that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and query XML documents that are stored within the database. SQL Server 2005 provides native support for XML that can vastly improve application performance, while supporting robust and safe multi-user access to the data...

Visitor Contributions       
Total Hits: 83  |  Today: 0 Author: www.asp101.com       Rating:  
Read Reviews | Write Review |              Your Rating: 

This area is for useful scripts that some of our visitors have contributed. ASP 101 did not write them and is not responsible for the operation of these scripts... heck we don't even take responsibility for our own. ;) We simply found them interesting and or useful and thought some of you might too!...

Advanced Data Shaping       
Total Hits: 68  |  Today: 0 Author: Chris Payne       Rating:  
Read Reviews | Write Review |              Your Rating: 

Our last article on data shaping introduced you to the basics, with a few applications. This time we'll talk about reshaping, and explore one topic more in depth - that of a hierarchical file system. Briefly, let's review what data shaping is....

Using the SQL Distributed Management Objects       
Total Hits: 89  |  Today: 0 Author: Carvin Wilson       Rating:  
Read Reviews | Write Review |              Your Rating: 

The SQL Distributed Management Objects (SQL-DMO) provide a set of OLE objects that enable applications to use management features of SQL Server. This functionality helps to extend the capabilities of SQL Server by providing access to any 32-bit OLE-compliant application. This article gives an overview of SQL-DMO and provides a demonstration on how to access SQL-DMO via Active Server Pages (ASP)....

A Brief Overview of SQL Server's Data Transformation Services       
Total Hits: 68  |  Today: 0 Author: Carvin Wilson       Rating:  
Read Reviews | Write Review |              Your Rating: 

The Data Transformation Services (DTS) within SQL Server help to solve business problems by providing graphical tools and COM objects that can be used to extract, transform, and consolidate data from different sources. This article will give you a brief overview of DTS, and show you how to create and execute packages within Active Server Pages (ASP)....

Centralizing Database Access With Visual Basic ActiveX DLL's       
Total Hits: 69  |  Today: 0 Author: Carvin Wilson       Rating:  
Read Reviews | Write Review |              Your Rating: 

By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo....

Using SQL-DMO To Backup and Verify a Database       
Total Hits: 86  |  Today: 0 Author: Carvin Wilson       Rating:  
Read Reviews | Write Review |              Your Rating: 

The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database....

Building an ASP.NET App: John's DVD Catalog - Part 1: The Idea       
Total Hits: 103  |  Today: 1 Author: John Peterson       Rating:  
Read Reviews | Write Review |              Your Rating: 

Here's the plan in a nutshell... to build as ASP.NET application to manage my DVD collection. Now let me back up and explain that I'm not crazy and why this is actually a good idea.
was surfing the site looking for typos, out of date info, etc. when it occurred to me that while we have tons of code and articles, we have very few complete applications for you to look at and the last one I remember writing is so old I can't remember when I wrote it! Most everything on the site can be covered ...

Securing ASP Data Access Credentials Using the IIS Metabase       
Total Hits: 72  |  Today: 1 Author: Thomas C. Carpe       Rating:  
Read Reviews | Write Review |              Your Rating: 

As an ASP programmer, I am always writing code that accesses databases. Many applications, such as Site Server, Commerce Server, SharePoint, and Content Management Server provide their own API that helps an ASP programmer tie into this data in a secure and efficient way. That's nice if you have access to these remarkably expensive platforms, but what about the rest of us? Well, you could roll up your sleeves and just whip off a couple COM objects; however unless you are a crewmember of the stars...


DevASP - Privacy - Disclaimer
Copyright © 2008 DevASP.com