Articles
DevASP - ASP and XML Articles, Samples, Toturials, Sample Chapters and resources for Developers Thursday, February 09, 2012
Home
Articles & Samples
Dev Search
Sample Chapters
Link to US
Contact
Search Directory
Applications
Articles & Samples
Components
Community
Database
Developer Sites
Downloads
Hosting Services
Introduction
Knowledge Base
Sample Chapters
WebCasts
ASP Directory
Applications
Articles & Samples
Components
Developer Sites
Knowledge Base
Sample Chapters
WebCasts
XML Directory
Applications
Articles & Samples
Developer Sites
Error, Bugs & Fixes
Downloads
Introduction
Knowledge Base
Sample Chapters
WebCasts

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Database > Data Searching
Search
DevASP

What's New
What's Hot

Advanced Data Shaping       
Total Hits: 146  |  Today: 0 Author: Chris Payne       Rating:  
Read Reviews | Write Review |              Your Rating: 

Our last article on data shaping introduced you to the basics, with a few applications. This time we'll talk about reshaping, and explore one topic more in depth - that of a hierarchical file system. Briefly, let's review what data shaping is....

Letting users search for information       
Total Hits: 205  |  Today: 0 Author: Rey Nuñez       Rating:  
Read Reviews | Write Review |              Your Rating: 

The simplest way to find data is to provide a full table-view where the user can browse thru the entire set of records, and simply use the client browser's Find dialog box to look for and navigate to whatever item to search for. Whilst that may be adequate for small data sets, that method is barely efficient in real-world applications.In this chapter, we look at the different ways to let users search a database for information, whether to look for a particular value, one record, or a group of re...

Letting users search for information       
Total Hits: 787  |  Today: 0 Author: ASPxtreme       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article is about how to retrieve and update information stored in databases, Using SQL to query and return search results and ADO Find Method....

Sorting and Searching Database       
Total Hits: 520  |  Today: 0 Author: Christopher Miller       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article will be a complete tutorial of creating your own search engine and web portal. Online demo is also available....

Parse Query       
Total Hits: 792  |  Today: 0 Author: Greg Gurath       Rating:  
Read Reviews | Write Review |              Your Rating: 

Code for parsing search strings (AND, OR, NOT, NEAR and quotes) for Microsoft SQL Server and other SQL servers that accept that syntax....

Searching Your Database       
Total Hits: 1449  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

If you have a database you'll want to be able to do searches against the records you have in it. With this script you can base your search on either a single field or all your table fields....

Using SQL To Query And Return Search Results       
Total Hits: 2159  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

When the form is sent (to the same page actually), we open a Recordset using SQL to select the record whose values in the lookup fields (UserEmail and Password) equally match the given strings....

Check If User Exists Before Inserting Into Database       
Total Hits: 1289  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This is a quick and dirty script that checks to see if a user exists in a database before inserting the record. The script also doesn't allow for empty form values. If either one of the cases are true, the user is redirected to the sign-in page....

Database Search Sample Code       
Total Hits: 1593  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This sample code answers the call for for a sample of how to search a DB for certain records. It's really no different then doing any other query except that you need to use wildcards....

Database Multi Word Text Search       
Total Hits: 848  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

I wrote this for my company's intranet to display a search for our standard operating procedures. It will search a table in my database that contains SOP titles and is multi-word capable. It will also display the results as hyperlinks to htm files containing the SOP's....

FinDb Searcher       
Total Hits: 846  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

It searchs all database for the keywords which you have written. It can search in every field, every table....

Search Form Tutorial And Sample Code       
Total Hits: 1443  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This tutorial creates a search utility designed to show you the basics behind doing a simple database search using ASP. If you just want to download it, change the data in the Access database, make a DSN called "Employees," and use it....go for it!...

Search DB By Field       
Total Hits: 814  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

Providing search capabilities to a db enables users to query on whichever element you target them to. However, allowing users to target which portion of the db they would like to query gives extra value....

Search Within Search Results       
Total Hits: 464  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also....

A Nifty Table Searching Script       
Total Hits: 408  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article, by Jerry Wood, shows a nifty little script, which, with just one ASP page, allows you to dynamically search a column in a table using a string comparison....

Search Database       
Total Hits: 917  |  Today: 0 Author: Natalia Babkina       Rating:  
Read Reviews | Write Review |              Your Rating: 

Step by step giving the instruction how to: - browse for table names in any database; - browse for column names in any table any database; - use a variable in query string instead of complicated functions and encoding....

Multiple filters on a WHERE clause       
Total Hits: 496  |  Today: 0 Author: fhunth       Rating:  
Read Reviews | Write Review |              Your Rating: 

Sometimes I had to develop a report or a something to show data, but previously the user‘d have the possibility to apply multiple filters so as so view the info that wants to be found.As ever I designed the User Interface with the filters then passed the filters through the different layers and finally, they came to a stored procedure that makes the query.
It returns the data and that’s all.
Several times I heard some colleagues telling that they must show data applying multiple filters an...

Search DB using 2 date fields       
Total Hits: 725  |  Today: 0 Author: Johannes J. Burger       Rating:  
Read Reviews | Write Review |              Your Rating: 

Searching a Database (SQL Server), on 2 datefields. Using 2 Database fields in a search query. How to search for overlapping date fields....

Searching and sorting records in a recordset       
Total Hits: 583  |  Today: 0 Author: Faisal Khan       Rating:  
Read Reviews | Write Review |              Your Rating: 

In this article we will see on how to search the database for a group of records. Searching a database is very easy and fun provided you know how to do it....

Database Search Sample Code       
Total Hits: 1433  |  Today: 0 Author: ASP101       Rating:  
Read Reviews | Write Review |              Your Rating: 

A sample of how to search a DB for certain records. It's really no different then doing any other query except that you need to use wildcards....


DevASP - Privacy - Disclaimer
Copyright © 2008 DevASP.com