|
|
ASP » Tips and Tutorials » Database-related » Connecting to Database using DSN/DSN less Connections
A D V E R T I S E M E N T
Today's Special: Get free Magazine from SAP!
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
Scripts Related to - Connecting to Database using DSN/DSN less Connections
| Script Name |
This 4-page tutorial shows all the basics of using Active Server Pages and VBScript to work with databases. It covers Connecting to the Database, Working With Recordsets, and more.
|
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. 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).
|
This short tutorial demonstrates how to insert data into a SQL database using SQL statements.
|
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records
were returned from a query, and how to detect null and blank values in the data.
|
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin’ Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.
|
Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.
|
This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.
|
This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.
|
This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.
|
This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.
|
|
Google
Search
Source Codes World.com is a part of Vyom Network.
Vyom Network :
Free SMS, GRE, GMAT, MBA |
Online Exams |
Freshers Jobs |
Software Downloads |
Interview Questions |
Delhi Info |
Jobs, Discussions |
Placement Papers |
Free eBooks |
Free eBooks |
Free Business Info |
Interview Questions |
Free Tutorials |
Arabic, French, German |
IAS Preparation |
Jokes, Songs, Fun |
Free Classifieds |
Free Recipes |
Free Downloads |
Bangalore Info |
Tech Solutions |
Project Outsourcing, Web Hosting |
GATE Preparation |
MBA Preparation |
SAP Info |
Software Testing |
Google Logo Maker |
Freshers Jobs
Sitemap |
Privacy Policy
Copyright ©2003-2006 Vyom Technosoft Pvt. Ltd., All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/Connecting-to-Database-using-DSN-DSN-les-2442/default.asp
Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions
| |