asp+xls quick search system, the results will be displayed instantly on the page. It has a wide range of uses and can be used to quickly check whether people or vehicles are in the community during the epidemic, check technician error codes, check after-sales outlets, and quickly check inventory and storage locations. Easy to use, just edit the form and drop it into the designated folder. Supports multiple databases. If there are no valid query conditions, the first column of each file will be searched.
Usage
There are following ways (choose one)
1. Deploy this source code in asp virtual website space and access it through the website address.
2. Open a website space on an independent server to deploy this source code, and access it through URL or IP.
3. Open a website space on an ordinary PC server in the intranet to deploy this source code, and access it through the intranet IP.
4. [Everyone can use it] Build an IIS environment on a win7+ ordinary desktop computer or use NetBox.exe (Baidu for details) to access it locally.
Why asp+xls
1. You can try Netbox.exe (details on Baidu) for asp. You can quickly set up and use it on your own Windows system computer.
2. The xls format can be opened and edited on almost every computer, and quick saving makes it easy for users to operate.
3. Easy to use. After editing the form, just throw it into the designated folder.
Quick start
It is recommended to directly upload FTP to the corresponding space for testing without modifying any content.
Query page access: http://website/directory/ (upload and use directly)
1. Check the rules and then modify the parameters: open inc/conn.Asp in notepad++ to view the correspondence between the web page and the parameters.
In addition: the file name desc.txt in the inc folder is the query page description file (supports html)
2. Then open the default built-in database to view the rules and compare the query results to help quickly understand the working principle.
How to open the xls version: You can directly double-click to open and view the Excel file in xls format.
3. Experience: Most of the online decompression function file names containing Chinese names are garbled. It is recommended to upload by FTP specified encoding (gb2312).
4. It is recommended to keep this test page: it is normal but if it is abnormal after you modify it, it means that it is a problem with your operation.
5. The compressed package contains usage steps, video tutorials and other information (HTML files); each file has its own meaning and is recommended to be retained.