|
1-20 of 45 ASP Databases > Displaying Records sites are shown.
|
|
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.
|
|
|
|
|
|
|
Code showing how to load a ComboBox with records that are retrieved from a database.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Displays years pulled from a database into a drop down box.
|
|
|
|
|
|
|
One of the most common questions we receive from new ASP developers is "how do I fill a list box with choices from a database table"? Fortunately, this is a pretty simple thing to do.
|
|
|
|
|
|
|
This article shows how to create a page with multiple dropdowns. The first dropdown gives the initial values to choose from. Once submitted another dropdown is created and the values in it are based on the value selected from the first dropdown.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
Votes:151
Hits:4580
