
|
1-20 of 45 ASP Databases > Displaying Records sites are shown.
|
|
This code creates a CSS drop-down (small text/colours - whatever) that pulls values from a DB. It also validates the browser to check for CSS compatability.
|
|
|
|
|
|
|
This article will show you how to dynamically populate a dropdown list, select an item from the dropdown list, and search your database based on this item.
|
|
|
|
|
|
|
Any ASP developer who has been around the block a few times has written code that creates a list box containing the elements from a database query. A list box is comprised of a number of options. Each option has a displayed title, and a hidden value. It is this value of the selected list box option that is passed onto the ASP page that the form is submitted to.
|
|
|
|
|
|
|
Now with more options, including multiple select, size, and default selected option. Quickly and easily creates select list combo boxes from a database for your web forms. Uses .GetString rather than recordset looping.
|
|
|
|
|
|
|
Displays years pulled from a database into a drop down box.
|
|
|
|
|
|
|
Ever wonder how the search engines pull off that cool trick of only showing you the first ten results that your query pulls back from their gigantic database? Well, rest assured that you're not alone.
|
|
|
|
|
|
|
Ever wonder how the search engines pull off that cool trick of only showing you the first ten results that your query pulls back from their gigantic database? Well, rest assured that you're not alone.
|
|
|
|
|
|
|
Paging is a very useful way of presenting data. It allows you to show 5, 10 or whatever number of records you want per page and then show typical 'first page', 'last page', 'previous page', 'next page' etc buttons to navigate between pages.
|
|
|
|
|
|
|
article will compare the three ways in which paging can be achieved for an ASP/SQL Server 7 application. The first uses ActiveX Data Object (ADO) paging; the second uses getrows and an array; and the third uses a SQL Server 7 stored procedure.
|
|
|
|
|
|
|
Recordset paging is the process of breaking up a recordset into multiple "pages" of information for display.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
This article is about a solution worked out to display a table with multiple records per row rather than with just one record per row.
|
|
|
|
|
|
|
Here is some code that will generically display the reqults of a SQL query in the form of a table. The code will draw columns and rows for each field and record the resultset returns. You do not need to know what will be returned ahead of time to construct the table.
|
|
|
|
|
|
|
Reading records
from a table is not hard, reading records in a optimized way is a
little tougher.
|
|
|
|
|
|
|
A generalised open connection command to use before all database reading .
|
|
|
|
|
|
|
If you know you are
just gonna use one single record ( like when displaying the details
for a single article for example ) then be sure to specify MaxRecords,
since it makes the drivers optimize their memory allocations and
therefore make the call much faster.
|
|
|
|
|
|
|
If you know you are
gonna loop through a lot of records ( like when displaying a table of
all articles in the system ) then use CacheSize to the drivers
optimize their memory allocations and therefore make the call much
faster.
|
|
|
|
|
|
|
I recently was putting together some web-based screens and I wanted an easy way to display a certain number of records on each page. I wanted it to be flexible enough I could change it on-the-fly.
|
|
|
|
|
|
|
This example shows using the Command Object, the main reason is the dis-connected recordset model of using Database resources most efficently
|
|
|
|
|
|
|
This tutorial shows how to use the GetString Method of the ADO Recordset object to return and write out records. this method is a lot faster and easier than using .Movenext method. There are many benefits to using the technique and its very easy to use. I'd suggest spending a few minutes and try this example.
|
|
|
|
|
|