Integrating User Search with ASP and SQL Server Full-Text Search
2587Integrating User Search with ASP and SQL Server Full-Text Searchhttp://www.15seconds.com/Issue/010423.htmMicrosoft Index Server is a built-in feature of Windows 2000. It provides a service for automatically indexing documents such as HTML, text, and Office documents. The Index Server search facilities can then be used to quickly locate a document.ASP > Tips and Tutorials > Database-relatedOct 10, 2006
Dropdown lists in HTML are very useful for multiple-option choices, especially within a web form that user needs to fill out.
Producing them dynamically from a database can saves a lot of time and energy.
In this example, we will use ASP 3.0 to generate dynamic dropdown lists from a Microsoft Access database. The database table in question contains fruit and vegetable types.
Data repeaters in .NET are very usefull to display database records onto screen. But usually, in a real world situation, you don?t have enough functionality with 1 repeater. Take for example some kind of menu structure. You want to display a category, but every category can have 0 or more subcategories. With 1 repeater, this cannot be done in a simple way. In .NET, you can use nested repeaters for this
In the tutorials so far we have learned from connecting to the database via ASP to inerting, updating and selecting data from the database.
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point :
ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. I will show you how to do it two ways: in the global.asa and in any ASP page.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.