NEW LISTINGS  HOT LISTINGS  TOP RATED  EDITOR PICK  ADD A LISTING  UPDATE A LISTING  GET RATED  UPGRADE A LISTING
  HOME     MY ACCOUNT     POWER SEARCH     REGISTER     MEMBER LIST     SUGGEST CATEGORY  
GLOBAL SEARCH

Browse a Listing

Subscribe to this category

Top > ASP > Tips and Tutorials > Database-related

Popular Tags

Free Script links
Sort By :
81. Two Table Join
Details

Visit

Refer

Review
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered) . The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement (state_order.state = state_capitals.state) looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

82. How to create a System DSN for Access database
Details

Visit

Refer

Review
You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.
Open Control Panel window, you will see different icons as shown in Pic 1.
Doubble click on ODBC Data Source Administrator icon.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

83. Presentation Of Hierarchical Data
Details

Visit

Refer

Review
A very good example is a form where the user needs to select a geographical region, a country within that region and a state within that country. If the user changes the geographical region, the countries and states within that geographical region need to be shown for selection
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

84. Adding Records to a Database using SQL
Details

Visit

Refer

Review
My purpose of this example is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database When I started doing ASP, getting records from an ASP page to a database was my 1st thing I wanted to do. I quickly discovered there was a few ways you could do that. This example uses formatted SQL and the Execute method of the Connection object to take data from a html form and submit to an ASP page that processes the data using SQL.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

85. Connecting to a Database and Retrieving Results in 9 Easy Steps
Details

Visit

Refer

Review
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it's hard to separate the database stuff from the rest of the code so I made this example
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

86. ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pag
Details

Visit

Refer

Review
Learn how to use the ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pages).
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

87. Updating records in the database with ASP
Details

Visit

Refer

Review
We have already discussed how to create DSN and show database contents in the ASP page in our tutorial Accessing Database from ASP. Then we moved on to learn how to add records to the database in the tutorial Adding Records to the Database. We will now see how to update the records in the database
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

88. Adding records to the database with ASP
Details

Visit

Refer

Review
No matter what kind of site you have got, you will need your ASP pages to access databases. ASP makes it easier to work with databases by providing support for ADO ( Activex Data Objects ). You already know how to build DSN ( Data Source Name ) and then access database, if you don't then you might want to check out my tutorial on Accessing Databases via ASP.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

89. Accessing database from an ASP page
Details

Visit

Refer

Review
Databases are a way of organizing and keeping your data. The data stored in databases can be anything from user email addresses to binary files. Databases have become so popular in the past decade that it is almost unimaginable to not to use them on the web.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 2 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

90. Connections, Commands and Procedures
Details

Visit

Refer

Review
In the previous chapter, we looked at the basics of ADO, concerning ourselves mainly with the Recordset object and the manipulation of data. In most of the examples, we obtained data by simply specifying the name of a database table, but as you've seen from the object model, ADO has other objects that allow data to be accessed.
Category:
ASP > Tips and Tutorials > Database-related

Write a Review   Add Favorite   Refer it to Friend   Report Broken Link  
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0

Member Reviews Visitor Ratings Google PR

Pages: [<< First] [< Previous] 2 3 4 5 6 7 8 9 10 11 [Next >]

Category Jump :