Graphical search of Excel database?
Posted 10 January 2011 - 05:54 PM
I have an excel database of over 9,000 karaoke songs. We are setting up 3 PC kiosks with steady state.
What I want is a graphical search engine type program that will bring up the line(s) with that matching entry when a user enters the text.
DRUNKS will be trying to use this! So I need it to be a simple and fool-proof as possible.
Does anyone have any suggestions? Price is a consideration also.
Posted 10 January 2011 - 09:15 PM
Then it's just a matter of having a trivial program where you can type text, and it does a substring search from that data, and then displays the relevant entries. Very simple system... Assuming that's all you want it to do (show song names).
The actual implementation would depend based on language/stack used... in C# I'd probably throw something together quickly that works like this (not exactly an enterprise-grade, robust system but it would do the job in a pinch):
1-loading the data into a plain old DataSet (sucking the data in using the Microsoft Jet OLE DB 4.0 provider, to read from the CSV file directly -- mind you it could read from Excel directly if you really wanted to...)
2-have a plain old DataGridView to show the data
3-add a DataView (having the DataSet as its source; you'd simply databind the DataGridView to this to view the data) -- this is what would handle the filtering ("searching") for you
4-have a textbox where the drunks can simply type what they're searching for, and have the TextChanged event handler set the filtering on the DataView (using its RowFilter property).
That would take less than a page of code. It's simple enough that price ought to be zero.
Again, that is assuming I'm understanding your needs perfectly (just search for songs and nothing else)
There might be pre-made apps for this kind of stuff. No idea...
Posted 10 January 2011 - 10:21 PM
How would I convert the excel to the preferred format? (Hopefully without having to re-enter all the entries)
Attached is a sample of the excel sheet. The goal is to get the number that matches the song OR title.
If you could help with this that would be the best...
Posted 10 January 2011 - 10:28 PM
File > Save As > change "Save as type" to CSV (or whatever)
That's just as easy. I just mean, you don't actually want it to play stuff, or do other tasks besides searching (seemingly not)
Just PM me a link to the Excel file (or CSV, doesn't matter one bit) and I'll take care of it tomorrow after work if that works for you (somewhat busy right now and it's almost midnight too, but I'll get around to it)