more Tag: sample, database, web database, asp web, web database sample,

Also see ...

1)    Making the Switch from ODBC to OLE DB  ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page.... 2)    ASP and Databases  The ASP data access component is one of the most powerful features of ASP. With this component you are able to interface your database(s) directly with your webserver. Database access in ASP is, or can be, very complex. This online tutorial focuses on just a few objects to help you get started with the basics and you can then move forward from there.... 3)    Simple Table Display With Where Clause (Hard Coded)  Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.... 4)    How to create DSN for Microsoft SQL Server  This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.... 5)    Querying an Access database in ASP  Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes.... 6)    File DSNs - Use and Reuse  Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.... 7)    Using ASP to create, edit, or delete information in a database.  This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).... 8)    SQL Tutorial  SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn`t tell you where the error is. This tutorial provides a nice summary of SQL statements.... 9)    Simple Web-Database System Application  This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construct the Active Server Page....

1)    MailListBot  Developers can utilize this efficient email component to deliver the applications faster and in an effective manner. This component is easy to install and very fast. This component supports both HTML and plain text formatting. This component performs mail merge and personalization. Using this component, users can embed images, sounds, macromedia presentations etc., This component provides options like logging and debugging that enables easy identification of any type of errors.... 2)    Basics of ASP  Those who need to learn the ASP basics and it's working principles can go through this online ASP tutorial. How to integrate ASP within HTML coding and VBScript is described in detail. Given sample coding comes with complete comments about functions that are used to display the current date and time on web page. And creating form to get values from user and submitting it to another page is explained clearly.... 3)    Sending a Email Using CDONTS  Learning as well as implementing an ASP based email system can be done perfectly from this online ASP material. Describes how ASP works together with the server component CDONTS for executing the mailing function through web based interface. Provides the source code seperately that provides the executable syntax of required methods and objects of CDONTS.... 4)    ASP Newsletter Manager Plus.Attach  Easy to use, ASP mass mailing solution with attachment support. Compose, archive and send HTML & Text newsletters. Dynamic HMTL editor to compose your newsletters. Upload utility for your attachments. Full subscriber management and opt-in/out forms to place in your site. Send personalized messages, with your signature and unsubscribe link. Subscribe-confirmation emails sent automatically. Works with all major email components. Ready to use with MSAccess (included) and MSSQL. Detailed, illust... 5)    Free ASP counter  From this site the webmasters will get several tips and hints about how to create a simple and powerful hit counter and also it guides them how to use on their web page. Example for demo and for test drive is given for the users .... 6)    CartExpress  CartExpress is an online e-commerce software enriched with both vendor and product management features. Using this ASP application webmasters would be able to sell their products and services online through popular authorized payment gateway systems. You can create and maintain product catalogs with the ability to update, remove and delete products from the catalog and can also subscribe affilitaes for the cart. Invoice creation, multi-level coupons and discounts, customer interface, shippin... 7)    Implementing a Guest Book Using ADO  If you want to add a guest book to your site, then this article is for you - it contains full source code and the necessary Access database to get up and running immediately. A complete introduction to ADO is provided.... 8)    Display an Excel DB  The author writes "For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale." This exmaple code demonstrates how to display data from Excel using sample data of Hank Greenberg`s career statistics. Example code available for download.... 9)    SQLServerTools Object  This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure....