Sorry your browser is not supported!

Hi!
im making a small database....
and i need to make a kind of searcher....
example....: if i take the name: Oliver.. then i want so i can click on the "O" button and then the database will show all the names there starting whit "O"
how i make that..?

The Nerd

So i take it you want to code the Database in DB. Not interact with a database from db.

If so.

You need to decide what type of data structure you will use. I have a entire volume on searching and sorting algorithms.

Data stuctures:From dyanmic arrays, trees, linked lists, etc..

Sorting algorithms:
(bubblesorts, selection sort, Parallel Sort/merge, quicksort, heapsort, Batcher's odd-even sort, hashing,

Which one you use depends on How large will the Database be. Speed VS. memory. Will you want to be able to use other key fields to search? Will you want to be able to sort the database in other ways (like a-z, z-a, first name, last name etc..)

If you are just looking to have it alphebetaized by last name (and that's all you ever want) i can give you code to insert into an array. But if you plan on developing further there are (little but more complex) but better methods. Also will the Databse be a fixed size or will it be changing drastically. Let me know.

~zen

"If you are just looking to have it alphebetaized by last name (and that's all you ever want) i can give you code to insert into an array"

i just want that..

Since this is DBC, an arraylist is gonna be a problem. I mean it can be done by creating your own arraylist, but it's slow.
Ok, given your database array, you'll have a search result array as well. Use a search a method to find whatever you're looking for. Count the number of search results found, make an array of that size, then fill it with the results.