Add to Favorites    Make Home Page 15313 Online  
 Language Categories  
 Our Services  
 Home  


Database-related
ASP » Tips and Tutorials » Database-related

A D V E R T I S E M E N T

Search Projects & Source Codes:


  • Bullschmidt ASP Web Database Sample - Freeware
    This sample ASP Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.
  • Migrating ASP from Microsoft IIS to Linux
    This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.
  • ASP Speed Tricks
    This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages.
  • Suggestion Box
    Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.
  • Using Stored Procedures - Free
    A stored procedure is like a map to commonly requested information, which can speed things up. This is because stored procedures are cached in the server.
  • Using GetRows To Get All Records From Table - FRee
    Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
  • Uploading Images to Database Using Persist AspUpload - Free
    You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.
  • How to Get Identity of New Record - Free
    Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.
  • Using SUM Function in An SQL Statement - Freeware
    Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
  • Compacting an Access database from ASP code
    This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.
  • Executing Transact-SQL UPDATE statement
    In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database
  • Executing Transact-SQL INSERT statement
    In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.
  • Counting Records In A Database Table
    We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.
  • Executing Transact-SQL DELETE statement
    In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
  • Simple database techniques - Freeware
    When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects.
  • Add N number of records to a dB
    This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers.
  • Custom Paging in ASP
    This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.
  • Paging Records With GetRows
    You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!
  • How to display records from top 4 database systems using plain ASP?
    Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server).
  • Dynamic, database backed dropdown lists
    How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list.

  • Page 1   Page 2   Page 3   Page 4   Page 5   Page 6   Page 7  

    A D V E R T I S E M E N T




    Google Groups Subscribe to SourceCodesWorld - Techies Talk
    Email:

    Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

     Advertisements  

    Google Search

    Google

    Source Codes World.com is a part of Vyom Network.

    Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | 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 | Terms and Conditions
    Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
    Page URL: http://www.sourcecodesworld.com/scripts/Database-related-137/Default.asp


    Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review