1. Parameters and stored procedures should be used in data access, so as to improve efficiency and prevent injection attacks.
2. You should manage the connection strings in a unified manner and put them in webconfig or a specific file. If they are placed in webconfig, you must encrypt them and thenProgramIn the same way, it will be convenient to change the connection string later.
3. Avoid data access on the same page as much as possible in the program design. If the page has five data binding controls, you need to retrieve the data to access the database once.
4. NoteCodeAnd put the class into a specific project using the component programming idea.
5. You can consider using threads in complex search to greatly improve efficiency.
6. Remove the view status of the control. Some controls can remove the view status and reduce the page size without retaining data.
To be continued .................