asp+excel multi-purpose query system v2021
2021
The asp+excel multi-purpose query system is an extremely simple but very versatile and convenient score query system that can be used for queries on almost all Excel single and two-dimensional data tables.
Just modify the query conditions and top and bottom text (very simple), and it can be used universally
1. Score query system, which can be used by every school, educational institution, public institution examination, etc.
2. Salary inquiry system, which can be used by every school, educational institution, public institution examination, etc.
3. Property fee query system, every enterprise, school, and all units may use it
4. Utility bill inquiry system, community, property company, university dormitory, etc.
5. Other query systems with few modifications, such as class placement query, admission query, certificate query, etc.
Product advantages
1. Very versatile. No matter how many columns or column titles you have in your Excel/Wps two-dimensional table, it is directly supported. Other formats are also supported after exporting to csv or excel. The query results are almost all controlled by your Excel two-dimensional table. You only need to maintain your Excel table. To operate Excel, almost every computer has software that can be opened and edited, and almost anyone can operate it.
2. Easy to use. Just modify the query conditions and title, and then copy, paste, rename, and upload the two-dimensional Excel table you usually enter. It is very convenient. You can publish a score query and it can be solved in half a minute. To modify the query conditions, etc., just open Notepad and edit a few words to customize whether to use the verification code.
3. Broad market. It can be widely used for one-time performance query with few changes, admission query, certificate query system (can be used in every school, educational institution, public institution examination, etc.), salary query system (every enterprise, school, all May be used by all units), water and electricity bill inquiry system, etc. (community, property company, university dormitory, etc.), admission, certificate inquiry system.
4. Flexible use: supports multiple queries. For example, salary queries often require multiple queries, so you only need to place one database per month, and the drop-down query options are automatically obtained (the options are file names); and each query is in addition to the set query conditions. Except for the column titles, which must be consistent, everything else is customizable and can be different (any number of columns, any column titles, any number of rows); if the query conditions are inconsistent, copy the code file and name it in a different folder, and then modify it. The query conditions can be used.
asp+excel multi-purpose query system update log
2021.03.18（）
1. 2021 version new interface (html+js+css)
2. The drop-down options are sorted by upload time
3. Built-in browser anti-cache design, jump, return and other full parameters
4. Privacy policy update: the input box no longer remembers the input content
5. More detailed optimizations are waiting for you to experience
2018.08.01
1. 2018 version new interface (html+js+css)
2. New query algorithm, three times faster +
2017.02.17
1. The interface has been completely changed: using the latest paid version interface, it is much more beautiful.
2. Major update of instructions for use: all instructions have been rearranged
2016.06.08
1. Data drop-down improvement: match uppercase and lowercase suffixes
Originally, the file suffix could only be lowercase, but now it matches uppercase and lowercase letters.
2. Data pull-down improvement: suffix algorithm is more accurate
It turns out that by judging by dots, if the file name is dotted, the judgment is inaccurate and the query cannot be performed.
3. Instructions for use updated: added data conversion video tutorial
This will be more suitable for more users.
4. Improve the query JS Alert prompt. Originally, some browsers would prompt garbled characters.
