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  

Average Visitor Rating: 0.00 (out of 5)
Number of ratings: 0 Votes

Visitor Rating

Integrating User Search with ASP and SQL Server Full-Text Search
2587 Integrating User Search with ASP and SQL Server Full-Text Search http://www.15seconds.com/Issue/010423.htm Microsoft 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-related Oct 10, 2006

Write a Review   Add to My Favorite   Refer it to Friend   Report Broken Link  

Bookmark Integrating User Search with ASP and SQL Server Full-Text Search:


Other links at ASP > Tips and Tutorials > Database-related
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.
Category:

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
Category:

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 :
Category:

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.
Category:

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.
Category:




Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
175

Join Mailing List
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.



Top 10
Directory Statistics

Links: 20048
Categories: 1275
Registered Users: 789
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234591

Pagerank Statistics
PR 10
1 site(s)
PR 9
9 site(s)
PR 8
53 site(s)
PR 7
201 site(s)
PR 6
645 site(s)
PR 5
1678 site(s)

PHP News